Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Query MDX

Hello, i have a question, i need execute a mdx, i achieved connect to server through OLEDB but when i execute the query, qlikview give me a error.  Which is the syntaxis for run  queries mdx ?

Thanks

1 Reply
Not applicable
Author

OLEDB CONNECT TO [Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDataBaseName;Data Source=YourServerName;Location=YourServerName];

SELECT

{

      [Measures].[Amount]

}

DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY

(

      {[Transaction Date].[Financial Period].Children as [Period]},

      {[Sales Group].[Name].Children}

                )

ON ROWS

FROM [YourCubeName]

;