Skip to main content
Showing results for 
Search instead for 
Did you mean: 
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
Former Employee
Former Employee

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

Not applicable

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 ,