topic Re: export full data from SSAS in QlikSense in Connectivity & Data Prep

export full data from SSAS in QlikSense

Anonymous — Thu, 09 Aug 2018 10:42:28 GMT

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

Re: export full data from SSAS in QlikSense

bwisealiahmad — Sat, 11 Aug 2018 08:31:15 GMT

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

Re: export full data from SSAS in QlikSense

petter — Sat, 11 Aug 2018 08:51:54 GMT

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

Re: export full data from SSAS in QlikSense

jonathanhvid — Thu, 06 May 2021 13:10:20 GMT

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