topic Query MDX in QlikView https://community.qlik.com/t5/QlikView/Query-MDX/m-p/554238#M207077 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Which is the syntaxis for run&nbsp; queries mdx ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 20 Nov 2013 18:10:50 GMT 2013-11-20T18:10:50Z Query MDX https://community.qlik.com/t5/QlikView/Query-MDX/m-p/554238#M207077 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Which is the syntaxis for run&nbsp; queries mdx ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 20 Nov 2013 18:10:50 GMT https://community.qlik.com/t5/QlikView/Query-MDX/m-p/554238#M207077 2013-11-20T18:10:50Z Re: Query MDX https://community.qlik.com/t5/QlikView/Query-MDX/m-p/554239#M207078 <HTML><HEAD></HEAD><BODY><P>OLEDB CONNECT TO [Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=<SPAN style="color: red;">YourDataBaseName</SPAN>;Data Source=<SPAN style="color: red;">YourServerName</SPAN>;Location=<SPAN style="color: red;">YourServerName</SPAN>];</P><P></P><P>SELECT</P><P>{</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Measures].[Amount]</P><P>}</P><P>DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY</P><P>(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {[Transaction Date].[Financial Period].Children as [Period]},</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {[Sales Group].[Name].Children}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>ON ROWS </P><P>FROM [<SPAN style="color: red;">YourCubeName</SPAN>] </P><P>;</P></BODY></HTML> Tue, 22 Apr 2014 20:05:48 GMT https://community.qlik.com/t5/QlikView/Query-MDX/m-p/554239#M207078 2014-04-22T20:05:48Z