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.
