This discussion is archived
4 Replies Latest reply: May 21, 2013 7:33 AM by _RahulS_ RSS

Data retrieval

995806 Newbie
Currently Being Moderated
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 ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points