export full data from SSAS in QlikSense

[Anonymous]

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

[bwisealiahmad]

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

[petter]

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

[jonathanhvid]

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