Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Direct Query to gat data from SSAS cube

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.

0 Replies