Variance Calculation

[sap_user62]

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

[former_member186338]

No, use Excel formulas for variance calculations. Strange users 🙂

[sap_user62]

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.

[former_member496237]

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.

[former_member186338]

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

[former_member186338]

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