topic MSOLAP.4 data cubes and qv in QlikView https://community.qlik.com/t5/QlikView/MSOLAP-4-data-cubes-and-qv/m-p/196799#M715351 <HTML><HEAD></HEAD><BODY><P>We are now testing QV solution for our client reporting analysis. Data source will be MSOLAP.4 data cubes that we would like to access straight form QV using MDX queries.<BR />There is no single working example of doing that, we know that we need to use OPENROWSET and it works with MSSQL database (we tested that<BR />solution) but we can make QV connect to OLAP cubes using it. C We also tried to use QV generated connection string to MSOLAP.4 but with no luck also.<BR />Can you point some example or help about OPENROWSET and MSOLAP?</P><P><BR />PS. I tried examples from forum, maybe we need some kind of tutorial <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Wed, 22 Sep 2010 12:30:57 GMT 2010-09-22T12:30:57Z MSOLAP.4 data cubes and qv https://community.qlik.com/t5/QlikView/MSOLAP-4-data-cubes-and-qv/m-p/196799#M715351 <HTML><HEAD></HEAD><BODY><P>We are now testing QV solution for our client reporting analysis. Data source will be MSOLAP.4 data cubes that we would like to access straight form QV using MDX queries.<BR />There is no single working example of doing that, we know that we need to use OPENROWSET and it works with MSSQL database (we tested that<BR />solution) but we can make QV connect to OLAP cubes using it. C We also tried to use QV generated connection string to MSOLAP.4 but with no luck also.<BR />Can you point some example or help about OPENROWSET and MSOLAP?</P><P><BR />PS. I tried examples from forum, maybe we need some kind of tutorial <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Wed, 22 Sep 2010 12:30:57 GMT https://community.qlik.com/t5/QlikView/MSOLAP-4-data-cubes-and-qv/m-p/196799#M715351 2010-09-22T12:30:57Z