Question:
Hi everyone,
I have a couple of questions regarding OLAP Cache.
1. In SPRO, I have set the 'Global Cache Settings' to be active, with Persistence Mode = Cluster Table. However, I want to make the Cache Mode to one of my ODS inactive.
So, at the same SPRO screen, at the 'InfoProvider Properties', I put in the ODS name, and I set the Cache Mode to be 'Cache is Inactive'. But this doesn't work, at least the way I expected it to. After running some queries from this ODS, and then I run transaction RSRCACHE, I still see that cache is created for that ODS/query.
Why is this so? Have I misunderstood the function of the settings? How can I disable cache creation for query/infoprovider? Does anyone know of a function module to delete this cache via ABAP?
2. On a separate issue, I have created a scheduling package using reporting agent. This package is basically used to 'warm up the cache', so to speak, so that the subsequent running of the query is faster.
I have created a few query variants to run, and after the prescheduling has finished running, subsequent report execution is very fast and almost immediate, as expected. But the funny thing is, these queries are speedy ONLY when you run them with the same saved variant, and when you type in the parameters yourself, it doesn't work and the query execution is slow.
In other words, I have variant ZVAR1 with:
0CALMONTH = 01.2004 to 12.2004 and
0COMP_CODE = '0001'
0PLANT = '0002'.
When I run query by selecting this variant, everything is fine & dandy.
BUT when I type in the same values as in the variant, it does NOT work.
Why is it behaving this way? Is this normal? Kinda silly isn't it?
I thank you all in advance.
_________________
I'm loving angels instead
Answer:
Hi,
Did you schedule your query using Reporting Agent with the printing settings?
I also want to "warm up" the cache in order to get faster results in some critical queries.
I used the printing settings. But I´m not sure if I´m getting fast results with this.
How did you schedule your query?
Thanks.