Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Error Connecting SSAS Cube from Qlikview

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?

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.

Community Browser