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