Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is mdx language supported for qlikview

is mdx language supported for qlikview ?

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

10 Replies
brunomarques
Contributor III
Contributor III

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
Former Employee
Former Employee

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

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

Not applicable
Author

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
Partner - Creator
Partner - Creator

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.

Not applicable
Author

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
Partner - Specialist II
Partner - Specialist II

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

regards

brunomarques
Contributor III
Contributor III

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

Not applicable
Author

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?