Skip to Content

Variance Calculation

Aug 15, 2017 at 08:20 PM


avatar image

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Aug 15, 2017 at 08:35 PM

No, use Excel formulas for variance calculations. Strange users :)

10 |10000 characters needed characters left characters exceeded
Edward Masarri Aug 16, 2017 at 02:42 AM

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 f link, not very clear on the concepts on how it achieves variance analysis)


Show 3 Share
10 |10000 characters needed characters left characters exceeded

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.


[CATEGORY].[Budget] - [CATEGORY].[Actual]


- 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,



I do not recommend member formulas for variance calculations - will slow down reports significantly.


My recommendation is the same - use Excel formulas in local members.