Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
;