Showing results for 
Search instead for 
Did you mean: 

thow to turn-off caching for specific queries

0 Kudos

Anyone knows how to turn-off caching for specific queries?

I get this step from article "How to Report Data in Alternate Units of Measure.pdf" in comment section.

I had finish all step the article but the result is not OK, any body had try this article and successful, will u share ur experience about this?



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi supriatna,

I think you can findout and change the cache seeting of specific Query in "RSRT" transaction.In that transaction you have enter the name of qury , and then press properties button .So you can see and change the settings there.

Hope this helps you.

with rgds,


Former Member
0 Kudos


just a little more info...

- To deactivating the cache for a certain query.

Transaction RSRT or RSRT2 -> Select query ->'Attributes' button.

Set cache mode to 'Cache is inactive'.

- To deactivating the cache for testing the query execution in RSRT/RSRT2.

Execute query + debug button -> Select 'Do not use cache'.

However look at OSS Note 456068 'OLAP: Deactivating query cache/deleting cache data'.

Hope it helps !