How to cache Large Worksheets ?
Hi All,
We have some consolidated Quarterly Worksheets which are working OK when we have medium data volume. However when the number of combinations are large say in the range of 30K..we are not seeing any data. By fuiltering the data we can see the data.
We have seen a White Paper - Oracle Demantra Worksheet Performance May 2010..which is asking to Worksheet Caching (manual caching).
How does caching work..do we need to runa workflow for each worksheet or a generic workflow for all teh data.
Any gotcha's for using the cached worksheets?
Please advice the limitations of the caching for large worksheets.