Get data from SSAS cube using Openrowset

nikhilgandhi715 — Tue, 02 Dec 2014 08:43:03 GMT

Hi All,

I am trying to get the data from SSAS Cube. I am able to connect to the Cube and get the Measures and Dimension attributes, however facing some issues with my MDX query. The quey is working fine in the SSMS.

My query is as belows:

Data:

Load *;
SQL SELECT * FROM
openrowset('MSOLAP.5','Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Dashboard;Data Source=MyServer',
'select {[Measures].[Rate],[Measures].[Instalment]} on Columns,
[Hierarchy].[Area].members on Rows
from [Model]');

I searched a lot on the forums but could not get any solution. Any help would be much appreciated.

Note: I would not like to use any third party apps to achieve this.

topic Get data from SSAS cube using Openrowset in QlikView

Get data from SSAS cube using Openrowset