Backup livecache data is different to data in demand planning
I have an issue that some of the livecache data in the backup cube is different to the KF's data in live demand planning. It's very random and only some months can be affected but not always the same months.
The KF data is generated by a macro and the data is save as the lowest level in DP.
Some of this data hasn't been changed, yet the LC value is different to what we see in DP.
And this also means that the forecast transferred to ECC will be incorrect.
How can we have certainty that the livecache data in DP is ALWAYS the same as the backup cube?
We are on SCM 7.0 and SP 2.
Do we need to apply any SP or notes to stop this problem happening?
Has anyone else experienced this issue?
Appreciate any advice.