Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tsglenn22
Contributor III
Contributor III

Connecting Qlik Sense to an OLAP Cube

Hey community,

I've seen a few posts about this so far but haven't had any luck with the responses provided. I'm trying to connect to an OLAP cube using Qlik. I realize this is not the ideal way to use Qlik to its full potential but it is what I need to accomplish given the data I have to work with on this project.

The auto generated script seems to break when it arrives to the SQL Select. I've read that MDX queries can be used here but it's not something I am familiar with and am having trouble implementing. I've also changed Qlik Sense into legacy mode so that I am able to use a OLEDB Connect statement instead of a Lib Connect. This works for connecting but I get the same undefined error.

Are there any suggestions that the community might have? Thank you for all the help!

2 Replies
wdchristensen
Specialist
Specialist

Hey Tanner,

Did you end up getting the OLAP Cube as a datasource working or did you end up rebuilding your data model in Qlik?

wdchristensen
Specialist
Specialist

Dalton Ruer has a good video on OLAP MDX queries on youtube:

OLAP MDX Query - YouTube