cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 7.5 drilldown report with sheet expansion

maxime_lessard
Explorer
0 Kudos

Hello,

I require some assistance with a BPC 7.5 report.  It is a report of company operating expenses by account.

I have set up the row key range so the user can "drill down" by double clicking on the rollup account member, to the dependents, then again to the base member GL level.  This part works fine.

Where I need help is with a sheet expansion on company sectors, that preserves the drilled down state on each sheet.

For example:

On the mainsheet, the user might drill down to the account GL level as follows:

Computer Services

---> Processing Services

--------->67301 - Technology Subscription

(The lower level is revealed indented on double clicking the parent. This is accomplished by using the Excel REPT function and the BPC property HLEVEL in the formula).

When the sheet expansion occurs on the sectors, I would like each sheet to display the same indented hierarchy as on the mainsheet.

If someone has done something similar and can point me in the right direction, I would appreciate it.

Please let me know if you need additional information.

Many thanks,

Steve

Accepted Solutions (1)

Accepted Solutions (1)

maxime_lessard
Explorer
0 Kudos

We managed to get around this with "if" statements that manually lists the expansion and a macro that deletes all the expansion in sheets each times the report is refreshed.

Answers (0)