https://community.qlik.com/t5/App-Development/Direct-Query-to-gat-data-from-SSAS-cube/m-p/1563739#M41052 <P>Hello,</P><P>Can you please tell me if it is possible to use Direct Query to load data from an SSAS Cube?</P><P><BR />For example, how to transform the following MDX code into a live query?</P><P><EM><STRONG>SELECT NON EMPTY { [Measures].[Moy. SMS], [Measures].[Moy. SMS émis] } ON COLUMNS,</STRONG></EM><BR /><EM><STRONG>NON EMPTY { ([Dates].[Dates].[Semaine].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Model] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</STRONG></EM></P><P>&nbsp;</P><P>Thank you in advance for your assistance.</P><P>Rodrigure.</P> Tue, 02 Apr 2019 07:55:05 GMT rodriguembognefotsi 2019-04-02T07:55:05Z https://community.qlik.com/t5/App-Development/Direct-Query-to-gat-data-from-SSAS-cube/m-p/1563739#M41052 <P>Hello,</P><P>Can you please tell me if it is possible to use Direct Query to load data from an SSAS Cube?</P><P><BR />For example, how to transform the following MDX code into a live query?</P><P><EM><STRONG>SELECT NON EMPTY { [Measures].[Moy. SMS], [Measures].[Moy. SMS émis] } ON COLUMNS,</STRONG></EM><BR /><EM><STRONG>NON EMPTY { ([Dates].[Dates].[Semaine].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Model] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</STRONG></EM></P><P>&nbsp;</P><P>Thank you in advance for your assistance.</P><P>Rodrigure.</P> Tue, 02 Apr 2019 07:55:05 GMT https://community.qlik.com/t5/App-Development/Direct-Query-to-gat-data-from-SSAS-cube/m-p/1563739#M41052 rodriguembognefotsi 2019-04-02T07:55:05Z