Want to plan at top - down based on Actuals

[Former Member]

Hi Everyone,

I want to plan at Entity level(Non Base member) and it has to be distribute to all base members based on actuals data.

Please let me know how can i achieve this requirement.

Regards,

Viswanath

[Former Member · Accepted solution]

Hi Viswanath,

Have an INP member for the parent members. While doing the planning, enter data in this INP member. After this use script logic to distribute the value from INP member to all the base level members of the parent member.

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan,

I am new to this, Can you please explain in briefly like what are the steps i will need to do.

My requirement is below:

If i plan at LEVEL0(Product Hierarchy) and it has to be distribute to all base member based on last year  data i.e actuals

Thanks in advance!!

Regards,

Viswanath

[lucas_costa3 · Accepted solution]

As I said in the other thread you opened,

You can do this by using a WRITEBACK badi, then inside this BADI you can retrieve the actual data and use it as you need to allocate values. There is some methods in the interface IF_UJO_QUERY like RUN_RSDRI_QUERY that can retrieve these data.

This is very generic and you have to use ABAP.

Best Regards,

Lucas

[Former Member · Accepted solution]

Hi,

I have used below script logic to distribute the planning data to all the base member.

But I am getting error "Invalid select statement" while validating in UJKT and running through the DM Package

Please let me know if there is any replacement code for below select statement.

*XDIM_MEMBERSET SKU_ACCOUNT = PL010

*XDIM_MEMBERSET SKU_RPTCURRENCY = %SKU_RPTCURRENCY_SET%

*XDIM_MEMBERSET SKU_ENTITY = %SKU_ENTITY_SET%

*XDIM_MEMBERSET SKU_TIME = %SKU_TIME_SET%

*SELECT (%PRODSET%,"ID",SKU_PRODUCT,"GROUP='$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*FOR %SKU-TIME%=%SKU_TIME_SET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM SKU_CATEGORY WHAT = Plan; WHERE =Plan; USING = Actual; TOTAL = <<<;

*DIM SKU_PRODUCT WHAT = %PROD%_NODE; WHERE =BAS(%PROD%); USING = <<<;                       TOTAL = <<<;

*DIM SKU_TIME WHAT= %SKU_TIME_SET%; WHERE= %SKU_TIME_SET%;USING=                           TMVL(-12,%SKU_TIME%); TOTAL=<<<;

*ENDALLOCATION

*WHEN SKU_ACCOUNT

*IS PL010

*REC(EXPRESSION=0,SKU_CATEGORY=Plan, SKU_PRODUCT=%PROD%_NODE, SKU_TIME = 2014.04)

*ENDWHEN

*NEXT

*NEXT

[lucas_costa3 · Accepted solution]

The statement:

*FOR %SKU-TIME%=%SKU_TIME_SET%

In the code %SKU-TIME% (With underline)

[former_member186338 · Accepted solution]

Hi Viswanath,

Please show the screenshot of UJKT validation. Have you set the parameter $COMBOBOX$?

For DM please show the advanced script.

And it's better to replace *FOR %SKU-TIME% with *FOR %SKUTIME%

and

*DIM SKU_TIME WHAT= %SKU_TIME_SET%; WHERE= %SKU_TIME_SET%;USING=

TMVL(-12,%SKUTIME%); TOTAL=<<<;

Vadim

[Former Member · Accepted solution]

Hi Kalinin,

I have made changed to "SKU_TIME" from SKU-TIME.

Please see the below snap shot of UJKT.

Here is the Advanced script logic:

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

PROMPT(COMBOBOX,%COMBOBOX%, "Choose the level :",0,LEVEL0,{LEVEL0,LEVEL1,LEVEL2,LEVEL3})

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,DIS_PLAN.LGF)

Regards,

Viswanath

[former_member186338 · Accepted solution]

First - on the screenshot I don't see PARAM line - where you have to set $COMBOBOX$ variable (look here:

Second - in the advanced script the line:

TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,COMBOBOX...

is missing! No value is passed to $COMBOBOX$ variable.

Vadim

[Former Member · Accepted solution]

Thanks Kalinin,

As you said, I have added missing line in my Advanced script, And now it is working fine.

Thanks,

Viswanath