Skip to Content
0
Former Member
Jun 05, 2009 at 12:49 PM

Hierarchy Level Limit in BPC 5.1 Reports

70 Views

Hello,

We are currently running BPC 5.1 SP7 and have a Account Hierarchy that has 15 levels. In the standard trend report, the control panel contains a drop-down list for rows and columns but is limited to 9 levels.

So we found the following formula in the row/column expansion and changed cell F21 which references the drop-down list of levels to "15".

=IF($F$26="ON",EVEXP($C$17,$F$19,C47:C58,D47:P58,TRUE,$C$2,$F$21,F22,$E$2),"OFF")

1. Is it ok to retrieve data at 15 levels down?

2. Does it slow down reporting? Is there any negative impact of doing this?

3. Is there a limit on the number of levels that a hierarchy can have?

We understand that we need to re-save all of these templates again in the wizard folder and increase the template version to trigger a download of the update.

Thank You,

Nikunj

Edited by: Nikunj Patel on Jun 5, 2009 2:49 PM