Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rodriguembognefotsi
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