BPC Performance

[Former Member]

One of our large BPC rpeort with 250 rows and 100 columns hangs with out refreshing.

The same report was running sucessfully with out issue before.

I noticed that optimization was not run recently for past 6 months. Could this be the reason?

Is there any concern in the middle of year end closing if the optimization is run? Will it affect any exisiting data or reporting any way?

What is the right optimization to be run FULL optimization or LITE. We have 4 years worth of planning and consolidation data.

Appreciate your inputs.

[SeerOfSig]

Ram, a few points regarding optimization.

Normally, only lite optimization is necessary. Full optimization is rarely needed and in fact in most cases will default to lite optimize even if run. See SAP KBA 1621911 regarding the differences between lite and full optimization.

Also keep in mind that it is possible that the lite optimize may time out if it has not been run in a substantial amount of time. See SAP KBA "1934009 - Optimization fails due to time out" regarding how to change the time out setting and SAP KBA "1935969 - Lite Optimize Data Manager package aborts / times out" regarding how to compress the requests manually via the backend.

Regards,

Peter Kreutlein