cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC EPM dynamic table member

Former Member
0 Kudos

I'm quiet new with BPC and I struggle right now with something looking easy. I basically have a table splitted in 3 parts. In the first 2 data are coming from a cube in the 3rd part (IN RED), data are calculated with excel formulas FORMULA of cell D33 :(=D26 - D40) ....

This work perfectly as long as the dimension doesn't move, if I add a new member then all formualas and number are shifted and don't match anymore.. What would be the solution to solve that and stay dynamic ? I tried several option like EPMFormattingSheet , Excel formulas, Local member and formulas :((( Has anybody an idea on how to solve that ? Thank you very much E.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Emmanuel,

Use local members with proper references! Read help "16.4.3 Local Members - Examples" - the keyword EPMMEMBER.

Vadim

P.S. Looks like publishing business ?