2 Replies Latest reply: Jun 6, 2012 4:43 PM by zainabjaber RSS

    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