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

    SSAS and Qlikview Connection Script



      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 *
      ,'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.