Integrated Planning with COPA and Cost centre planning

[Former Member]

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

[Former Member]

Hi Yogesh,

I am curious are you use multi planning area or use mutiprovider as the data provider in you third planning area, in your first post you indicate the the first one, in your last post, you indicate the second one.

are those two the same ir there is difference?

[Former Member]

dear JW,

Initially, i was using multi planning area.Afterwards Alberto suggested me to create multiprovider and asked me to use planning area based on this mutiprovider.

In the above mentioned problem i am not able to get why the data doesnt get refreshed in the third layout of the web interface.

If i exit the web interface and come back again i am able to see the changed data.

Could you help me in this regard?

Thanks in advance.

regards,

Yogesh

[Former Member]

Yogesh,

What you are trying to do has some common sense but it won't work.

Looking at your Cost Center cube, the cost of 500 is stored against Profit Center #, not again Cost Center PSAG as you would expect.

I guess you have, at least 4 ways to solve the problem.

First, you could use some sort of allocation function to post the cost to the right Profit Center. I don't recommend this as you will need to copy actuals to a transactional cube.

Second, you could modify your basic cubes so that your costs are "posted" to the right profit Center by means or update rules.

Third, you coudl also build a third basic cube with all the information you need. Problem of data redundancy. Not recomended.

Finally, what I would really recomend is to create a multiprovider over the cost center cube and identify profit center with the navigational atribute of cost center. In BPS rather than the basic cube I would use the multiprovider. And that's all your data will have the right reference with no data redundancy and no datamodel changes.

Hope it helps,

Alberto Sabate

[Former Member]

Dear Alberto,

First of all thanks for your help.As you told i have one planning area for Cost centre planning in which he plans for cost centre.I have a seperate planning area for COPA planning in which he plans for profit centre.

Now i created a multiprovider using cost centre cube and COPA cube.Created a planning area using a multiprovider.

Now i created a web interface for this application in which there are three layouts:

1) For Cost centre planning based on cost centre cube

2) For COPA Planning based on COPA cube

3) Integrated planning from COPA and Cost centre based on multi provider.The data in this layout is uneditable.

The user is able to see all the three layouts.At the first instance when he did planning for COPA and cost centre all the three layouts look fine but when any changes is made in either COPA or cost centre planning through layout what i am expecting is it should be reflected in my 3rd layout.But it is not happening so.

Could you give me some suggestion ? Thanks in advance.

regards,

Yogesh

[Former Member]

Yogesh,

Well, I feel you are close to solve the problem.

Your problem know is that you don't know exactly where data is being stored. Your third non editable layout is displaying records that not the same that you are editing in the two previous layouts.

I will just put you some questions that should make you think...

Are you properly selecting the planning area in your third layout?

If you plan at cost center "x" an amount of 500 USD and your display layout also contains in the level the characteristic cost center filtered at "#" you won't be able to see anything.

When I don't know what is happening I basically do one of this 2:

Execute the function in mode "Execute with Trace"

or even better execute the function, saved it and go to the cube and write down all the characteristics that you have written.

Now go to your third layout and you will see that you are restricting too much...that's why you don't see your data.

Regards,

Alberto

[Former Member]

hello Alberto,

I would like to state my problem in detail.It is as follows:

I created a Cost centre planning area based on cost centre cube (added planning item to the cube).Created a COPA planning area based on COPA based on COPA cube(here also added planning item).

Planned the following data in Cost centre planning area:

CostElement: 489600

ProfitCentre: PSAG

PlanningItem: Land

Amount: 300.00 INR

CostElement: 489530

ProfitCentre: PSAG

PlanningItem: Land

Amount: 300.00 INR

Planned the following data in COPA planning area:

ProfitCentre: PSAG

PlanningItem: NetSales

Amount: 4,000.00 INR

Now i have planning area based on mulitprovider using COPA and COst centre cube.

In the layout of multiprovider planning area the following data is getting displayed:

For ProfitCentre=PSAG

PlanningItem: Amount

Net Sales: 4,000.00 INR

Land: 600.00 INR

i have created a web interface using all the three layouts.Now i make some change in the amount of first layout for CostElement 489530.Say from 300 to 500.

After saving it what i expect in third layout is:

PlanningItem: Amount

Net Sales: 4,000.00 INR

Land: 800.00 INR

But it is not happening so.But when i exit the web interface and come back again i am able to see the expected result as above.

My problem is why the value is not getting changed as soon as i save in the first layout.Why i have to exit and come back again?

Any suggestions would be greatly appreciable.Thanks in advance.

regards,

Yogesh

[Former Member]

Yogesh,

So data is being properly posted but for some reason the web interface needs a refresh.

That's quite strange but there a certainly solutions.

I would seggest yiou to use the new web interface. In the web Interface Builder set the property "Old interface" to FALSE. Finally you could also use the function "function after data change" to force some sort of dummy fresh.

If you can, try to use the web component TAB_STRIP. Maybe they refresh the "target" layout automatically.

Playing a little bit more with your application you will find an acceptable answer.

Cheers,

Alberto Sabate

[Former Member]

Hi Alberto,

Your suggestion was helpful to me.At last i found the solution to my problem.I have solved it by using a kind of dummy refresh button which uses the planning function based on EXIT.In EXIT i have mentioned the function module <b>API_SEMBPS_REFRESH</b>.

This has really solved my problem.

Thanks and regards,

Yogesh