on 07-15-2015 6:35 AM
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.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.