SSAS and Qlikview Connection Script

Tue, 03 Sep 2013 13:17:24 GMT

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

topic SSAS and Qlikview Connection Script in QlikView

SSAS and Qlikview Connection Script