thow to turn-off caching for specific queries

[former_member378832]

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?

regards

supriatna

[Former Member]

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,

Anil

[Former Member]

Supriatna,

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 !

Bye,

Roberto