Skip to Content
0
Apr 10, 2014 at 08:30 PM

Issue with Local Member

131 Views

Hi BPC Experts,

We have migrated our environment from BPC 7.5 to BPC 10. We have also migrated our reports from EVDRE to EPM.

Now we have few reports where local members are used.

The report is buil up like this -

Entity in columns and account in rows.

We have created blocks in the report to show the grouping which is general while creating balance sheet or P&L report.

Local members are created to show the total at the bottom under each group. For ex.,

Cash account is a node we have in report.

Structure in account dimension -

Cash

A_100

A_123

A_124

B_100

B_123

B_124

C_100

C_123

C_124

In report, we have -

CASH

Current Assets

Investments

Fixed Assets

Total Assets - =round(sum(all four above),-3)

Now the total asset is local member here.

When we drill down on CASH, it generates additional members in the report (as shown above). The local member does not go down on drill down.

When we drill down on any parent node, we expect that local member should also get drilled down and show the correct value. However, this is not happening.

Could you please share some light on how to make local members dynamic with drill down on parent node?

We are on SP14 patch with .Net4.

Best Regards,

Ashwin.