on 08-15-2017 9:20 PM
Hi Friends
Env BPC 10.1
I have a question related to the best practices of calculating variances in BPC reports.
Variances could be Actual-Plan, Actual - PY Actual, Actual - Working forecast, Plan-workingforecast to name a few.
Currently these are simple excel calculations in a BPC reports as local members.
Users want to store these and some other variances(Performance Variance which takes into consideration FX changes) in the BPC database, so that they can be easily pulled into a report.
Is it a best practice to store these variances in BPC.
Thanks for your time
Ed
No, use Excel formulas for variance calculations. Strange users 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vadim for your reply. Is there any best practice document or any SAP document which suggests not storing these variances or calculating performance variances.
Its getting difficult to convince the users. 😞
Or is there a way that we can generate these variances on the fly using member formula's so that we are not storing it in our DB.
(checked fhttps://websmp109.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700000469872011E link, not very clear on the concepts on how it achieves variance analysis)
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Edward.
Member formula is possible. If you want to calculate variance on Budget vs Actual, a dummy CATEGORY must be created and assign a formula to it.
Example
[CATEGORY].[Budget] - [CATEGORY].[Actual]
Drawback:
- It will only calculate variance on Budget vs Actual. If you want to see variance on another pair of CATEGORIES, creation of more dummy members and formulas would be needed.
Best regards,
Joaquín.
My recommendation is the same - use Excel formulas in local members.
User | Count |
---|---|
15 | |
3 | |
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.