Skip to Content

Variance Calculation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 15, 2017 at 08:35 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • 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 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.

    Add comment
    10|10000 characters needed characters exceeded