Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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]

;