Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I connect my ssas cube in Qlik sense and I do the query MDX without problem, but these create a dataset table with some measures and dimensions.
I need import all dimension and measure in Qlik.I want see in the data model of Qlik same of SSAS cube.
It's possible?
thanks
Chiara
Hi,
I don't think you can just import the measures and dimensions directly, but you can re-create them in Qlik with Master Items or through scripting.
Best,
Ali A
By going to StackOverflow you can find good advice on how to do that like this for example:
ssas - List dimension members with MDX query - Stack Overflow
Hi,
There is a connector that makes it possible to look directly into your cube SSAS from Qlik and easily export all the measures and dimensions you like:
The Cube Connector for Microsoft SSAS & AAS | Stretch Qonnect
Hope this helps.
/ Jonathan