Allocation to write in other aplication area

[Former Member]

Hi Experts:

We have one aplication area to plan cost centers and another one to plan by profitabilty analisis (gross sales, net sales, COGS, etc) by several dimensions. It corresponds with the SAP ERP moduls of Cost Centers and COPA.

Would it be possible to make an allocation to post cost center plan in the COPA aplication area? We would run the aplication in cost center and should see result in COPA infocube.

Thanks in advance for your help

Kinds regards

Jose

[former_member200327 · Accepted solution]

Hi Jose,

I assume that you want to keep CCA and CO-PA as two Applications of one AppSet.

Right now Allocations can not post result into a different Application, but you can combine RUNALLOCATION with DESTINATION_APP in one script. Than you can see result in a different Application.

Most probably your CCA has multiple steps, I'd suggest run all those steps in one Application and than move results to a different Application.

Please let me know if I misunderstood your question.

Gersh

[Former Member · Accepted solution]

Thanks Gersh,

You understood well. In the script, I suppose I will be able to see from the script the receiver infocube to pick up drivers for the allocation. For example, to divide up the cost of the IT between several business unit depending on the FTE's. FTE's values and business unit dimension will be only in the receiver application set, They don`t exist in CCA application set.

In order to imagine what I will be able to do in a BPC script. Would it be similar to BPC functions and ABAP programs? Can I pick up information from any infocube that I need to and eventually to write data in any other infocube?

I apologize wheather this question is so simple. I have a wide experience in SAP ERP and a medium knowledge in BW, BPS and IP but I am just finding out the logical of BPC.

Thanks again for your help

Kind regards from Spain

Jose

[former_member200327 · Accepted solution]

Hi Jose,

First of all, it looks like you are using interchangeably Applications and Application Sets. Those are to different things in BPC. Right now there is nothing that allows to run something on data from 2 Application Sets, while LOOKUP and DESTINATION _APP allow to do pull and push from/to different Application. Application is a component of Application Set (AppSet).

So, if you have WHAT values in one Application and USING values in another Application - this is not going to work. Why can't you bring everything you need for allocations into one Application, say CCA, calculate allocations there and than send results to another Application?

I'm not sure what you are calling BPC function, BPC standard script is definitely not so powerful as ABAP. You can enhance BPC script by developing you own BADIs and calling them in BPC script.

So, BPC is quite different from ERP, but is based on BW and has many similarities with BPS and IP (where FOX is also not as flexible as ABAP:))

Regards,

Gersh

[Former Member · Accepted solution]

Hi Gersh:

Thanks for your help. It is very useful.

I understand that you say. First of all, sorry, I wrote BPC functions intead of BPS functions.

You are proposing to use only an application area for all planning if we have to use allocations. It seems the better solution. For me, It is a little bit strange, perhaps because I am used to SAP ERP. We have worked at many companies with some performance problems, especially in COPA area. If I share my application set among COPA, CCA, PS, internal order, etc..., I am transferring my COPA performance problems to CCA, PS, CO. At BPS or IP implementations we always implemented the CCA planning in a different infocube, separated from COPA and there were no problems to make allocations. That's the reason why I was looking for a solution with different application sets.

Anyway, If I can call a BADI from the script, I undertand that I coult try to write in other infocube by using ABAP functions.

Nevertheless, I understand your explanation. Its now for me clear that the idea of BPC is sharing the same application set for an entire area. It means that I will only have a application set for all CO. In terms of performance, in my opinion, the infocube is not as optimum as possible.

Best regards

Jose

[former_member200327 · Accepted solution]

Hi Jose,

In BPC performance of one Application doesn't affect performance of another Application; it does't matter if they are in same AppSet or not. This is like CCA andC O-PA being in same system in ERP.

You should look at an Application is an InfoCube. So, I didn't suggest putting all CO in one Application, I suggested putting all CCA in one Application, all CO-PA in another, etc., but all in one AppSet.

It's exactly how you did it in BPS and IP.

Hope this clarifies things,

Gersh

[Jeffrey_Holdema · Accepted solution]

I don't think you would want to combine all of Controlling components in 1 BPC application set. Rather I think it makes a lot more sense to have different applications that approximate the different ERP components/BW cubes. In other words, don't try to combine CCA and IO and COPA in one BPC application because each of these areas have different planning requirements and work at different levels of detail. This will help avoid any performance issue. But even more important, remember there is no unassigned member values in BPC, like which is possible in BPS. So this means if you were to combine CCA and COPA data in one BPC application, then you would have to specifiy customer/product/order etc when you are just doing simple CCA planning/reporting.

As for your original question how to allocate CCA data in a BPC COPA like application, I suggest the following. After completing the cost center planning including any cost center to cost center allocations, transfer the CCA data to your COPA application. You can do so using 1 of 3 techniques:

1) use the destination application function or BAdI

2) use a simple copy package

3) use an InfoProvider load

In the case of the third option it would be possible to summarize the cost center data into cost center groups using a conversion sheet, if data volumes and performance is an issue.

Afterward, you can use the RUNALLOCATION function to distribute the cost center costs to customers/products within the COPA planning cube. The same approach would be used in an internal order planning app.

Best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP Labs, LLC

BusinessObjects Division

Americas Applications Regional Implementation Group (RIG)

[Former Member · Accepted solution]

Hi Gersh and Jeffrey:

Thanks for your huge help and for spending so much time.

First af all, I have to say that I made a mistake when I wrote Application Set instead application. Of course, I have only an application set. Sorry for this huge mistake. I was thinking in application but writing application set (as Gersh mentions in a prior answer). Today, I has been very bussy and I read his answer too fastly. This happens because my english is not enough good and I have to get concentrated in too things.

Anyway, I have right now clear the entire scenario. I will use one application set (of course) and several application as I would do in BPS or IP and I will do what you suggest to make the allocation. The only new thing is that I will have to create the cost center dimension in my COPA application (I don't usually have it) .

Beside, I didn`t know that there is no unassigned member values in BPC. Anyway, I suppose I can maintain the value '#' as a value because there will be many situations that I don`t have all dimensions (I could have gross sales up to customer level and marketing cost up to business unit level).

Thanks you both for your help again. I wish I can help you in a future occasion.

Best regards

Jose