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.

[damovand]

Hi,

Running Lite optimization can potentially reduce the number of records in the Fact table(s) and speed up queries. However, depending on your BPC and data base version, HANA vs. non-HANA, and the volume of updates the effect of Lite optimize may or may not be significant. If after executing Lite optimize you are still having this issue then I recommend checking the process from the serve side to determine what is going on. I would recommend using SM50 or SM66 to track the execution and to capture ST12 trace to start with.

Best Regards,

Leila Lappin