Skip to Content
0
Jun 02, 2009 at 08:04 PM

Caching problem for planning query

266 Views

Hi,

when checking the query properties of the plan query used in our planning application in rsrt,

the system displays the message, that "Cache Mode - Cache not used by the query" or

"Cache Update - Query does not use Delta Process".

However the MultiCube below the Aggregation Level where the query has been defined on

does support Cache via Main Memory. Same with the Cubes integrated in this Mulitprovider.

But when trying to set the Query properties to Cache Mode = 1 (Main Memory Cache without

Swapping) the system does not store this parameter. The parameter for Cache Update can not

be set at all.

So are there any settings I need to do on aggregation level? Or what other parameters are

necessary to get the OLAP cache working on planning queries?

Thank you guys!

K. Reiner