4 Replies Latest reply: May 21, 2013 9:33 AM by _RahulS_ RSS

    Data retrieval

    995806
      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 ?