Skip to Content
0
Former Member
Sep 02, 2010 at 03:27 PM

Query contains double value - seems cache problem

34 Views

Hi experts,

in a Query (integrated planning) based on an Aggregationlevel based on a Multicube.

The Multicube contains an Realtime InfoProvider to store planning data and a normal InfoProvider to show actual values.

The load of actual values to the InfoProvider can be executed several times a month via ProcessChain -

it´s a full load so the data loaded before will be deleted during the month in order to save the new monthly dataload.

In the Query there were double values displayed for actual data after several loads during the month -

but in the acutal InfoProvider only a single value is stored!

It seems to be a buffer problem, since a deletion of all system buffers solves the problem - but this is not the way to handle the problem in productive area.

How can the problem be solved?

Setting of Planbufferquery of acutal data InfoProvider to not using Cache doesn't help.

Thank you!

Angie