Delta load based MultiProvider scenario with actuals and budget data
We implemented the Delta load based MultiProvider scenario for BCS out of performance reasons.
For us the use case for reporting is reporting mode "Restatement". In that case we have to do an INIT load per closing period (every month) because the organizational hierarchy changes every month.
Till now this INIT takes a long time, because we did not use the correct scenario. We defined a new scenario:
- once (first time with new scenario) an INIT with all data (fiscper and fiscyear) on all reference periods till now (eg April 2011)
- afterwards every closing period only an INIT on the new reference period
This works fine for actuals (all data on all reference periods available till current or closing period).
It does not work in combination with budget data. Because budget data concerns fiscal year/period in future!
- If the filter in infopackage is limited to reference period = closing period, also fiscal period/year after or greater than reference period is not loaded into the PSA.
I'm not sure this is a known 'problem' or on purpose (to avoid doubling on data in future).
- Does anyone have a suggestion on an optimal scenario for R modus, where the INIT on monthly basis is as minimal as possible and also this works for the past 3, current and next fiscal year (budget), so fiscyear 2008 to 2012 has to be available against every reference period till current or closing reference period.
Thanks in advance.
With best regards,