Cache not created for some queries

[Former Member]

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]

Thanks

[former_member184494]

singh,

Cache is first in first out... if you exceute too many queries then cache might force out the first query for want of memory. Check the cache immediately after the query is ruin once then you should also check the cache settings for the query in RSRT to see if cache is enabled for the query. Ideally the option for cache should be " Main memory cache with swapping " in RSRT. or the option that you have set for other queries that generate the cache entries.

Edited by: Arun Varadarajan on Jan 1, 2009 1:04 PM

[Former Member]

Dear Arun,

You wrote

=============

Cache is first in first out... if you exceute too many queries then cache might force out the first query for want of memory. Check the cache immediately after the query is ruin once then you should also check the cache settings for the query in RSRT to see if cache is enabled for the query. Ideally the option for cache should be " Main memory cache with swapping " in RSRT.

==============

I executed my query in question as the first query but no cache was created. The options for the cache mode was 'H Query reads data upon navigation' and 'main memory without swapping' along with a tick in the 'Query cache added to Delta' checkbox.

Just to check, i went on removing formulaes and calculated key figures and free characteristics from the query one by one and in the end the cache did get created for the same query. But I still could not pinpoint the exact reason for the query not producing cahce in its original form.

It only makes me think that there may be a particular scenarios or a peculiarity pertaining to the design of a query, that would prevent its cache being generated.

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