Planning at higher level

[Former Member]

Hi all,

We are implementing multiple Planning, Budgeting and Forecasting. Budgeting and Forecasting will be done at the base level whereas Planning is done at the higher level. Now the concern I have is in BPC we can not post data at parent level so is it even possible to Plan at higher level.

If yes, then how can we do it. Please share your views.

Thanks,

Diksha.

[RichHeilman · Accepted solution]

You can use the write back BAdI to insert custom code to allow you to plan at a parent level. This how-to guide shows exactly how to do that, including the a code sample for even dissagregation.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0309226-814f-2d10-61a6-ef8da29e3727

Regards,

Rich Heilman

[Former Member · Accepted solution]

Hi Rich,

Thanks for your Input. I implemented the HTD but it fails when I send data as shown in HTD. The error is P_CC is not a base member. I think it is failing to call BADI. Do I have to call the BADi through default logic or it should automatically call it as addressed in HTD.

Please suggest.

Diksha.

[RichHeilman · Accepted solution]

If you followed the HTG step by step, it should be called automatically, but it appears that it is not. Check that you have set the filter values correctly in the BAdI implementation.

Regards,

Rich Heilman

[Former Member · Accepted solution]

Hi Rich,

As per this document we post the numbers to the parent node and this number gets distributed to its base level members equally or based on some percentages. But when we actually look at the data base, there won't be any record for the parent member.

Is there any way that we record values to the parent members and that stays as a record at parent level without getting distributed.

Thanks

Anjali

[RichHeilman · Accepted solution]

That's right, the Write Back BAdi allows you to intercept the record of the parent node, and redistribute to the base members, you are essentially deleting the parent record and create records for its children. BPC stores ALL data at the base level member and it is not possible to write to the DB at the parent level. This HTG make it appear that you are doing so, but in reality you are writing to base level members.

Regards,

Rich Heilman

[Former Member · Accepted solution]

Hi ,

Following is my filter value:

APPLICATION_ID = PLANNING

APPSET_ID = NGRID_FITEAM

MODULE_ID = MAN

My CV is as follows:

APPSET: NGRID_FITEAM

Application: PLANNING

Category: ACTUAL

P_ACCT: CE0004000

P_Activity: Line

P_CC: NA

P_DataSrc: UPLOAD

RptCurrency: LC

TIME: 2008.TOTAL

MEASURE: PERIODIC

Please let me know if you want me to check anything else. I dont think its invoking my BADI if i am not wrong.

Thanks,

Diksha.

Edited by: Diksha Chopra on Apr 6, 2011 8:17 PM

[RichHeilman · Accepted solution]

Not really sure, I would have to get into your system to figure out what is happening, or in this case not happening.

Cheers,

Rich Heilman

[Former Member · Accepted solution]

Hi all,

I figured out the issue. I has my Appset ID as lower case and so it was not able to recognize it. I created a new appset with Caps on and it worked fine. Thanks a lot you guys.

It works on average. How can I use percentage way to allocate values? Any ideas?

Diksha.

Edited by: Diksha Chopra on Apr 6, 2011 8:31 PM

[Former Member · Accepted solution]

Hi Rich,

Thanks for your reply. I have some more questions on this document.

1. If I want to plan at a much higher level , will this BADI work. Say for example: the base level members are at level 6, I want to plan at level 2 or level 3. Will it still write the records to level 6 members though they are not immediate dependants.

2. In the example given in the document, both the base level members and the parent member is in the input schedule. If I don't have the base level members shown in the input schedule, and I only have the parent member, will this BADI still post data to the base members.

For example: I have some 500 base members to one parent node. I don't want to display the 500 base members. I will only have one parent member in the input schedule and post data to that member only. Will it still say that 500 records are submitted.

How is the scoping done for this BADI. Generally for the default logic, scoping will be based on the members on the input schedule.

Thanks

Anjali

[RichHeilman · Accepted solution]

Yes, would you simply have to change the code in the BADI implementation to do the calucation as per your requirement.

Cheers,

Rich Heilman

[Former Member]

Hi Diksha,

The only way to put a vlue directly to a parenth member is using script logic, so for you porpuse it is better to create a a new application only for the planning part with the old dimension but resume. Or create the same tree in the same dimension but taking out the basemembers.

hope it helps,

[Former Member]

You can have dummy base level members which may represent your parent members and plan on them. But while defining the hierarchy you need to be careful so that all the data correctly roll up and data is not double counted. You can use a different data source and category to distinguish this.

thanks

Anjali