BW Integrated Planning

[#1]

Hi Experts,

I m new in BW-IP. I have following plan :

For a plan ID- 4011 having planing data as follow:

Material      jan-2013   feb-2013   mar-2013      jan-2014 feb-2014 mar-2014

    M1               10          20               30                20          40          60

I aggregation level have material, calmonth, year , keyfigure and other chars.

My requirement is data will show like below:

Material     2013     2014

  M1            60          120

and if I change data for either of year that difference data will be updated only in first month of the respective year .i.e.

Changed data as:

Material     2013     2014

M1            70        140

In my realtime cube data will saved as below:

Material      jan-2013   feb-2013   mar-2013      jan-2014 feb-2014 mar-2014

   M1              20        20               30                40          40          60

How it will be achieved. Please help me.

Thanks in Advanced !!!

Regards,

Abhishek

[MGrob]

Hi

To distribute the data like this you need to develop a planing function that does distribution by reference data. If you search in scn I'm sure you find plenty documents

Here is the help.sap link

http://help.sap.com/saphelp_nw70/helpdata/en/43/1dfeff41130bd5e10000000a422035/content.htm

Hope it helps

Martin

[Former Member]

Hi Martin,

Thanks for your reply,

I have try to do distribution by Key Function Type, which show me following behavior :

Original data:

Material     2013     2014

  M1            60          120

if I changed  60 to 70 for 2013, it set 70 for Jan-2013 and other month 0.

But I need  10 (70-60) need to be added in jan-2013 and rest of the month as it was i.e feb-2013 is 20 and mar-2013 is 30.

Can you please explain me how to do.

Regards,

Abhishek

[MGrob]

HI

Try by reference data and refer to the current fiscalyear/periods you already have.

Martin

[Former Member]

Thanks Martin,

Now some useful result is coming. Now I am using distribution by reference.

Now it distributed the values among all the three months.

My Planning Function setting is

Change char is : 0calyear

Reference Data Selection : 0calmonth

But my requirement is effective changed value need to be added in first month only;

My Planning Function input parameter is :

0calyear:2013

0calmonth:01.2013

Regards,

Abhishek

[Former Member]

Hi Martin,

Can we do this in Formula planning function type??

Regards,

Abhishek

[MGrob]

Hi

That should work. Have you seen this

http://help.sap.com/saphelp_nw73/helpdata/en/4c/a22668bebd6642e10000000a15822b/content.htm

hope it helps

Martin