on 12-04-2014 3:20 PM
Hi Experts,
we have used local member formulas for variances,However if i copied the local member formula cell and paste this value into another cell it seems okay.However after refresh the copied cell disappears. how should i copy local member formula cell.
I have tried with local member recognition on with position in axis,Keep formula on data but could not able to copy.
BPC10,Sp17 patch 2.
Before refresh:
A1 B1 C1
Actual Budget Variance(local member formula)
1000 2000 1000(budget-actual)
A2 B2 C2
1000 2000 1000(copy/paste C1)
After refresh:
A1 B1 C1
Actual Budget Variance(local member formula)
1000 2000 1000(budget-actual)
A2 B2 C2
1000 2000
Can any one help me on this.
Thanks,
Kiran
Check in EPM Editor, whether Local member is created on Local Member tab?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi kiran,
Please use local member editor in Edit Report instead of recognition of local member (works only for very simple cases).
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.