topic Qlik Sense: connect to SSAS in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-connect-to-SSAS/m-p/1197832#M2184 <HTML><HEAD></HEAD><BODY><P>We are trying to load data from SSAS. Since this is using MDX, a different approach is needed as opposed to 'simple' SQL.</P><P></P><P>The data can be loaded using MDX queries in QlikView using the very nifty software by xthview: <A href="http://xthview.com/index.php/download/" title="http://xthview.com/index.php/download/">Downloads | xthView</A></P><P></P><P>However, the syntax produced does not work in Qlik Sense.</P><P></P><P>Does anyone have any experience/pointers as to how to approach this issue? Right now the data is generated in QV, sent to QVD, and picked up bij QS, which obviously isn't a very pretty/sturdy solution.</P></BODY></HTML> Mon, 03 Oct 2016 09:09:36 GMT terrorthijs 2016-10-03T09:09:36Z Qlik Sense: connect to SSAS https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-connect-to-SSAS/m-p/1197832#M2184 <HTML><HEAD></HEAD><BODY><P>We are trying to load data from SSAS. Since this is using MDX, a different approach is needed as opposed to 'simple' SQL.</P><P></P><P>The data can be loaded using MDX queries in QlikView using the very nifty software by xthview: <A href="http://xthview.com/index.php/download/" title="http://xthview.com/index.php/download/">Downloads | xthView</A></P><P></P><P>However, the syntax produced does not work in Qlik Sense.</P><P></P><P>Does anyone have any experience/pointers as to how to approach this issue? Right now the data is generated in QV, sent to QVD, and picked up bij QS, which obviously isn't a very pretty/sturdy solution.</P></BODY></HTML> Mon, 03 Oct 2016 09:09:36 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-connect-to-SSAS/m-p/1197832#M2184 terrorthijs 2016-10-03T09:09:36Z