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.