0 Replies Latest reply: Aug 28, 2013 2:13 PM by Vinodkumar Dhanabalan RSS

    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.