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.