Error Connecting SSAS Cube from Qlikview

Wed, 28 Aug 2013 19:20:08 GMT

Hi,

I have been working on connecting the SSAS Cube from Qlikview. I took help of the community to execute the script. Most of the answers shows the adventure works sample query. Based on this here is my Facts and Dimensions.

Measures:

Total Qty, TEM, Fact Sales Count

Dimensions:

Dim Customer, Dim Time, Dim Product, DIM ALIGNMENT ZIP TERR

The above is the structure of my cube. It is a star schema.

Qlikview Script:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CUBE NAME;Data Source=SERVER NAME(wher my cube is deployed);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SERVER NAME (QV is residing);Use Encryption for Data=False;Tag with column collation when possible=False];

SQL SELECT * FROM OPENROWSET

('MSOLAP.5',

'Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=False;

Data Source=SERVER NAME(where my cube is deployed);Initial Catalog=CUBE NAME',

'SELECT {[Measures].[TOTAL QTY]} ON COLUMNS,

{[ZIP_ID].[SALES_TERR_CD].[DIM_ALIGNMENT_ZIP_TERR]} ON ROWS FROM [CUBE NAME]')

Error:

Connection failed:

SQLState: '42000'

SQL Server Error: 4060

Cannot open database "MEDINCQV" requested by the login. The login failed.

1) How to rectify this error. Is there any problem with my QV Script?

2) Do I have any access issue?

3) Do I have to do settings from SSAS also?

NOTE: I do not want to use any third party application to achieve this.

If someone could help it would be greatly appreciated.

Thanks in Advance.

topic Error Connecting SSAS Cube from Qlikview in QlikView

Error Connecting SSAS Cube from Qlikview