Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

OLAP MDX Queries inside of Qlik Sense?

Employee
Employee

OLAP MDX Queries inside of Qlik Sense?

Have to give you the standard disclaimer that I think it's crazy to bring in pre-aggregated data ... however, I understand their are political forces that are driving you to ask that question.

In this short video I demonstrate that it's not only possible, but incredibly easy to load data from OLAP cubes using MDX. I begin by playing with an MDX query right in the SQL Server Management Console. I copy the query, create a connection inside of Qlik Sense, then paste the MDX Query, and run it. BOOM. Your OLAP data served up inside of Qlik Sense.

Wait you want more? You want to see if I can change the query right inside of Qlik Sense to ensure I'm not pulling out aces that were up my sleeve? Ok, I do that as well.

MDX inside of Qlik? Yeah we've got that. Because we run any native command you can throw at it.

Comments
alip_nath
Contributor

Hi There - This is great to know! However, a few follow up questions:

  • Is there any implementation approach by connecting to Cube directly? More keen to know how will be performance and behavior
  • continuing with the the above approach, we can also create QVDs and use them in Apps as in the usual qlik way
Version history
Revision #:
1 of 1
Last update:
‎07-30-2017 10:38 AM
Updated by:
Employee