Direct Query to gat data from SSAS cube

[rodriguembognefotsi]

Hello,

Can you please tell me if it is possible to use Direct Query to load data from an SSAS Cube?

For example, how to transform the following MDX code into a live query?

SELECT NON EMPTY { [Measures].[Moy. SMS], [Measures].[Moy. SMS émis] } ON COLUMNS,
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

Thank you in advance for your assistance.

Rodrigure.