I have a question on best practice with regards to version and switchover date...
My model uses 3 separate data sources for Salary, Income and Other Costs, which are stored in 3 separate modules.
Initially, I built the model assuming that each of my 3 data sources will be actualised to the same time point.
At the start of the budget process, I would upload data covering Jan- June for all three data sources and set switchover date on the forecast version to July.
I now want to actualise my data to August, but actuals are only available for Income and Other Costs. Therefore if I actualise Income and Other Costs to August and set switchover to September, my forecast modules work correctly for Income and Other Costs. However, my *Salary* forecast modules now show actuals up to June, blanks during July and August and forecast from September.
As a workaround, I have created a separate version with July switchover inorder to store the salary data but this requires hardcoded version selection when integrating + sparsity issues.
Is there a best practice for dealing with this scenario?