Cache not created for some queries

[#1]

Hi,

We are finding that when the queries are run on BI 7.0 cache is not created for some queries but it does created for others.

Can anyone advise if there are certain scenarios when the cache would not be created ?

In my scenario e.g. for one query which is base on a multiprovider and having few formuales as well as a calculated key figure + a unit conversion for one key figure. Cache is not getting created for this query.

regards

Kulmohan

[Former Member]

Cache will be created only when the users execute the query atleast once. If you want to create cache manually, go to RSRT transaction, press Execute+Debug, there is an option to fill the cache .

Execute all your queries to fill the cache.

[Former Member]

Thanks SDBI,

I tried through RSRT as well though did not try the debuging option yet. Do you think it would be different if I was to try the Execute+Debug option to fill the cache

regards

Kulmohan

[Former Member]

Execute + Debug had a option for fill the cache. This will give insight whether the cache being filled for a particular query during its run or not. Then you can pin down why cache is not getting created for some queries...you can debug