Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Get data from SSAS cube using Openrowset

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:



Load *;
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.

0 Replies