Qlik Community

Qlik Scalability

A group dedicated to advancing QlikView's scalability and performance. In this group we will share knowledge on how to perform load tests of Qlikview.

Highlighted
Not applicable

connection to sql server analysis service problem

Dear ALL

I have a problem using multiple data tables and  make a link betwen them , or use multiple queries in qlikview when connecting sqlserver analysis server , I have used this code to made connection :

OLEDB CONNECT TO [Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Stock Analysis;Data Source=user1];

select distinct  nonempty([Measures].members ) on columns,

distinct nonempty({[Vwtime].[calander].[year]}  on rows

from [Data]

every thing is fine , but when i  continue to make another select statement , an error occurs and data are not loaded successfully.

Can any one please help me ??

Best Regards

2 Replies
Employee
Employee

connection to sql server analysis service problem

can you post the full statement with the other connect statements and the error message, sounds like just a syntax error

Not applicable

connection to sql server analysis service problem

Hi nam

Before sending you the error . I want to know if qlikview can read fact table and dimentions from business analysis cube  in the same way that excell can see it ,because writing a huge MDX query may take a lot of time and i see it not the best way ,