Improve performance Demand Planning Live Cache

[jan_vereecken]

I am wandering if the performance of the Demand Planning can be improved by building aggregates on the Infocube PLOB .

Are there other measures which can be taken to improve the performance ?

Thanks

Vereecken, Jan

[Former Member · Accepted solution]

Building aggregates will improve performance under a few conditions

As far as reading of data in interactive demand planning books are concerned

for seeing visible improvement in loading data you need to ensure that the data is loaded at the exact characteristic level at which you create the aggregates.

While saving data at any level, it is also calculated and written at the aggregate levels (and hence takes more time to save).

If you load data at a level that is not matching with the aggregates there will be no great performance improvements

[Former Member · Accepted solution]

Another improvement is to use LiveCache keyfigures instead of InfoCube keyfigures.

regards

JB

[jan_vereecken]

Some very usefull feed back

[Former Member]

Hi JB,

Check out the note 515120. This may be useful for you.

Regards,

Siva.