is mdx language supported for qlikview - Qlik Community

Report Inappropriate Content · ‎2013-01-04

is mdx language supported for qlikview ?

I can connect a cube with the qlikview but, I can´t extract information.

brunomarques · ‎2013-01-21

Started with the same problem, and always received the answer that, no it's not possible. But it is, you just need to build the MDX query with some minor changes.

You can use this tool I've build :

http://xthview.com/index.php/download/

It connects to the SSAS Cubes and help's you generate a MDX query that QlikView can understand.

Have fun!

hic · ‎2013-01-22

QlikView never interprets the SELECT statement. It only sends it to the ODBC driver or OLE DB provider.

So if you have have an OLE DB provider that supports MDX, you should be able to do this. Look in the documentation of the OLE DB provider for syntax and possible limitations.

HIC

brunomarques · ‎2013-01-28

Added a quick manual to the tool, just check the "manual" link along side the download one.

Report Inappropriate Content · ‎2013-02-27

Hi

Did you check O-delta™?

"O-delta™ by DataForce Ltd. is the most comprehensive Solution today for companies to dramatically cut down Time & Money of Connection, Migration & Integration of OLAP (mdx.) data cubes to any QlikView’s models, from months/ weeks to days/ hours !!! Http://www.dataforce-solutions.com The Benefits are: • Minimum need of skills/ knowledge of the current OLAP cubes’ structure • Leverages OLAP cubes development investments • Intuitive, integrated & consolidated view of all BI information as a front end • Mobile availability of old and new BI applications"

http://www.youtube.com/watch?feature=player_embedded&v=dlb6nf0w6TQ

www.dataforce-solutions.com

bradshields · ‎2014-01-30

Hi Bruno,

I used your QV.Mdx query generator. I added the sample olap cubes that ship with AdventureWorks for sql 2012 and could connect to them with ease. I tested the results back to excel and confirmed all was working as expected. I could not choose all Dimensions and Metrics and run the query in either your tool or QlikView. I suspect it was just too big for my laptop but other than that it worked perfectly. Thank you.

If anyone else needs some help please post here as I will monitor this discussion.

Report Inappropriate Content · ‎2014-01-30

Hi,

Out of the box and supported by Qliktech - No (not to date, as far as I am aware - I had enquired about it a while back - but going forward - who knows?)

But there is nothing stopping you from building a custom framework that works for you as some of the other posters have alluded to.

Regards,

Alex.

jaimeaguilar · ‎2014-08-12

Does it work only with OLE DB or can the connection be made with ODBC as well?

regards

brunomarques · ‎2014-08-13

Never found a ODBC client for SSAS, so as far as I know the answer would be no.

Report Inappropriate Content · ‎2014-10-17

Hello Antonio,

Thanks so much it worked. But i want to save to QVD file what do i do? I tried the normal

Store * [Source] into file.qvd(qvd);

What do i do?