topic Re: is mdx language supported for qlikview in QlikView

is mdx language supported for qlikview

Fri, 04 Jan 2013 15:51:11 GMT

is mdx language supported for qlikview ?

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

Re: is mdx language supported for qlikview

brunomarques — Mon, 21 Jan 2013 20:00:03 GMT

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!

Re: is mdx language supported for qlikview

hic — Tue, 22 Jan 2013 09:32:43 GMT

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

Re: is mdx language supported for qlikview

brunomarques — Mon, 28 Jan 2013 22:57:06 GMT

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

Re: is mdx language supported for qlikview

Wed, 27 Feb 2013 14:37:24 GMT

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

Re: is mdx language supported for qlikview

bradshields — Fri, 31 Jan 2014 02:21:15 GMT

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.

Re: is mdx language supported for qlikview

Fri, 31 Jan 2014 04:01:53 GMT

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.

Re: is mdx language supported for qlikview

jaimeaguilar — Tue, 12 Aug 2014 15:46:51 GMT

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

regards

Re: is mdx language supported for qlikview

brunomarques — Wed, 13 Aug 2014 16:27:18 GMT

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

Re: is mdx language supported for qlikview

Fri, 17 Oct 2014 19:56:33 GMT

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?

Re: is mdx language supported for qlikview

marcus_malinow — Mon, 31 Jul 2017 08:06:05 GMT

Hi Bruno,

do you have a current URL for your tool?

Thanks,

Marcus