Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
Dalton Ruer has a good video on OLAP MDX queries on youtube: