0 Replies Latest reply: Sep 3, 2013 9:17 AM by Joe Berry RSS

    SSAS and Qlikview Connection Script

      Hi,

       

      I have a SQL Server (server0001s) that pushes data out to Analysis Services (on server0004s).

       

      I am trying to connect to the data in Analysis Services through Qlikview but am unable to do so; is this because SQL Server and Analysis Services sit on different servers?

       

      My script currently looks like this:

       

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=2Live;Data Source=server0001s;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONL7042;Use Encryption for Data=False;Tag with column collation when possible=False];


      SQL SELECT *
      FROM OPENROWSET
      ('MSOLAP.3'
      ,'Data Source=server0004S'
      ,'Initial Catalog=2Live'
      ,'SELECT {[BU].[BusinessUnits].[Front Office]} on columns, {[Acct].[Accounts].&[43]} on rows FROM [AA_12]');

       

      I can connect to the datasource fine but the SQL query does not seem to work.

       

      Thanks,

       

      Joe