I'm currently trying to connect Qlikview to SSAS cube to display multidimensional data.. Initially i selected OLEDB provider for Analysis Services 9.0 and tried creating objects in qlikview,which did not yield any outcome.
Later i used ,OLEDB provider for SQL Server(by creating new Linked Server), and used MDX query for the same using table object for one field which is as follows :
SELECT * FROM OPENquery
(RWA_IRB_SSAS,
'SELECT {
[Measures].[EXP_MS_VALUE]
} on columns,
{
[DATA SOURCE].[Data Source Name].MEMBERS
} on ROWS
FROM [RWA]'
);
That seemed to work .I was able to see populated values in table object of QV.
Please let me know how to achieve the same using Analysis Services?
