Executing Query Views not populating Query Cache?

[sap_cohort]

Hi, I'm executing 3 query views in a web template. I was expecting this to populate the cache for the query which they are based upon, but they are not?

Can anyone verify this behavior?

Thanks!

[Former Member]

Hi,

A query uses a cache entry only if it is suitable for it regarding navigational status, filters...

I recommend you to read this how to guide:

https://websmp103.sap-ag.de/~sapdownload/011000358700004339892004E/HowToOLAPCache.pdf

Have a detalied look at sections 3.4 and 3.5:

<i>Cached query results can be used only for the same query. In some cases, real subsets of

cached query result sets can be used; this is possible, if the three following requirements are

met:

• It is the same query ID

• All selection criteria of the second query must be contained in those of the first call, i.e.

the query result set of the cached query is a superset of the second query

Note that the selection variable must defined as ‘changeable with query navigation’! If the

variable was not changeable, the variable value would be part of cache entry key and,

hence, the cache entry could only be used for exactly the same variable values.

• The characteristics with differing selection criteria are included in the drill-down of the

cached query result</i>

Hope it helps,

David.

Message was edited by: David Sirvent