Skip to Content
0
Former Member
Jul 26, 2016 at 12:08 PM

Restriction with a local member in a report BPC 10.1

272 Views

Hello experts,

I am facing with a issue related with local member in a report. I don't really know if there is a limitation of the local member usage or simply I haven't yet found the way to do it.

I am working on:

BPC NW 10.1

EPM 10.0 SP

Due to my requirement, I would need to insert a local member in order to get the balance carryforward from the previous period. I have to enter it here:

My local member is called "CF - Total". For the period 2016.02, its formula should be =C10+D6+D7+D8+D9. For the period 2016.03, should be =D10+E6+E7+E8+E9 and so on.

I am unable to get this. I tried:

  1. Entering directly the formula in the cell, with the flags "activate local member recognition" and "use position in axis" selected. In this way, the local member formular is changed automatically:

2. Using the command EPMMEMBER into de local member formula (in the report editor), but the local member disappears (the whole file).

Really is it possible to make the calculation that I want with the local member feature?

I would appreciate your help.

Best regards,

Manu

Attachments