topic connection to sql server analysis service problem in Scalability

connection to sql server analysis service problem

Fri, 01 Jun 2012 21:10:25 GMT

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

connection to sql server analysis service problem

nam — Wed, 06 Jun 2012 08:04:30 GMT

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

connection to sql server analysis service problem

Wed, 06 Jun 2012 20:43:52 GMT

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 ,