IS Cache

[bo5i]

Hi, Need clarification on how cache works in Intelligence server.

I have reports executed inturn creating cache for this months(say January month) data. When i run the same reports next month(Feb month), does it going to retrieve me the latest months data as well ? or just the last months data. I am sure cache is not a cube to store data in it. I guess cache stores only the information about reports objects and sql.

Thanks

 

[reisw]

The cache will only return what you have executed the last time. If you want Feb data in the report you will need to reexecute the report so it pulls in the new data.

 

[nlim]

Since you have NEW Feb data, the Jan cache won't have it. So you'll have to re-run the report (manually or scheduled) to refresh the cache. All products have the same issue...Powercubes need to be "incrementally refreshed", same for BO microcubes.

Cache works better with prompts. If you have a report with a prompt filter, the cache will keep track of all different prompt answers. If your prompt answers matches any one of the caches, it will pull from cache. This sets MSTR apart.