BPC limitations Dimensions/Performance

[Former Member]

What is the limitation on the number of dimensions BPC (Outlooksoft) can have? And how is the performance affected with more or less dimensions being used on BPC Excel. Is there and performance measure in place?

Thanks

[Former Member]

In NW version of BPC, the limitation is removed. More dimensions will not affect performance as long as the dimensions and modeled properly.

Ravi Thothadri

[Former Member]

Ravi, could you please provide any SAP note(s) that talk about the removal of limitation for BPC NW version? Thanks!

[Former Member]

For SAP BPC 5.1, SAP recommends max of 20 dimensions per application. I had an application which had 15 dimensions and one of the biggest templates (excel) had 5 dimensions in row expansion and 1 dimension (time) in column expansion. The template had close to 1000 rows of data and it used to take close to 6 minutes to open. This has been my worst experience.

I am not sure if there is a performance metrics published by SAP but you might find something in their implementation guides.

Thanks,

Ameya Kulkarni