In our scenario i have one cube for Profitability planning(COPA) and another cube for cost centre planning. For COPA i am planning net revenue profit centrewise.For eg:
Profit Centre PSAG
Net revenue 100000
For cost centre planning i am planning for differrent cost elements restricted on cost centres whose attribute is PSAG (Profit centre).
Cost element 489530
Cost 200
Cost element 489600
Cost 300
I have created a multi planning area containing planning aeas of COPA and Coste centre.In the layout of multi planning area what i am expecting is it should show the profit centre,cost and net revenue.For eg:
Profit centre PSAG
Cost 500
Net revenue 100000
Here the cost is the aggregated cost of all the cost elements who are responsible for profit centre PSAG means the cost centres of all these cost element have the attribute PSAG (Profit centre).
-
or
2. do we need to desgin a seperate cube for integrtaed scenario and do planning on it?
Any suggestions would be greatly appreciated.
Thanks in advance.
regards,
Yogesh
