Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

export full data from SSAS in QlikSense

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

3 Replies
bwisealiahmad
Partner - Specialist
Partner - Specialist

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
Partner - Champion III
Partner - Champion III

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
Partner - Contributor III
Partner - Contributor III

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