on 2023 Sep 24 9:38 PM
Hi SAP folks,
The business has a requirement to see Plan Vs Actual data store wise in SAC.
Each store is mapped to a profit & cost center.
Planning cycle is done for April to March Fiscal year. Team begins planning in the month of January.
In January, there are certain stores that the business plans to open up in the month of August, Sept. But there are no such profit centers codes created yet in the system.
What should be the way this is managed in SAC planning (since it is not necessary that the store might actually open)? Also ensuring, once the profit center code is created then plan Vs Actuals gets reported based on the profit center?
Regards,
Gavin.
Request clarification before answering.
gavin2160
gavin2160One possible approach could to be to use dummy PC and CC during the phase of planning where Actual PC and CC codes are not in system. Its logical that the dummy PC and CC will hold only Plan data as Actuals will be only on real PC and CC codes. You can maintain attribute say SAP_PC in the dimension and once the real PC is created, you can maintain this as attribute value against the dummy PC. You can use SAC Data Action to transfer the data from dummy to real codes later when they materialize. You can group all dummy PC and CC under a separate parent node for easier reporting.
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
59 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.