4 Replies Latest reply on May 21, 2013 2:33 PM by _RahulS_

    Data retrieval

      Hi All,
      Can you please help me in tuning the data retrieval . The retrieval in excel is taking lot of time. In the outline , there are two dimensions which have somany members in it.
      I changed the settings on caches as well.
      Index file size : 8000KB
      Page size : 9000KB

      Index cache : 10000KB
      DataCache : 4200000KB

      Hit ratio for Index 1.0 , data cache : 0.97

      Please let me know how i can get the results fast in the excel ?