US elimiation

[Former Member]

HI friends,

i'm working on US elimination.

Dim: ENTITY , is it mandatory to maintain INTCO property for each of entity.

Eg: two entities E_US,E_UK in ENTITY Dim and I_US,I_UK are ids of INTCO dim.

Usually in INTCO dim, for each intco member id (I_US), we need to maintain propery "Entity" (i.e E_US).

source records:

Time | Parterner| Rptcurrency|Acct| Category| Datasrc| Flow| Groups| Intco| Amount

2010.APR E_US USD ICSALES 100 INPUT F_NONE LC I_JP 20.000,0000000-

2010.APR E_JP USD ICCOST 100 INPUT F_NONE LC I_US 20.000,0000000

Script logic Is: 
*RUN_PROGRAM US_ELIM
CATEGORY = %C_CATEGORY_SET%
GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
OTHER = [ ]
*ENDRUN_PROGRAM

BPC excel, DM package (dynamic view editor) : code:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,GROUPS,%TIME_DIM%")
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/IC_ELIMINATION_LOGIC,TAB,%TAB%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,EQU,%EQU%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SUSER,%USER%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,LOGICFILENAME,ICELIM.LGF)

After running DM package, in formula log: 0 submitted 0 success 0 fail.

Is passage of group value from DM script to script logic is correct or not?

thanks,

naresh

[Former Member]

resolved

[Former Member]

Hi Naresh,

How did you solve your issue.

After running DM package I also get in formula log: 0 submitted 0 success 0 fail.

Thanks,

Aldrin Liendo

[Former Member]

Modified script: 

*RUN_PROGRAM US_ELIM
CATEGORY = %C_CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%  
GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
ENTITY=%ENTITY_SET% 
*ENDRUN_PROGRAM

DM script :

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CURRENCY_DIM%,%CATEGORY_DIM%,GROUPS,%TIME_DIM%")
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/IC_ELIMINATION_LOGIC,TAB,%TAB%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,EQU,%EQU%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SUSER,%USER%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,LOGICFILENAME,ICELIM.LGF)

Package log still shows: 0 submitted 0 success 0 fail.

could any one guide me where i went wrong.

thanks.

[Former Member]

Hi Naresh,

Under each node you need to maintain elimination entities so that system will post the entries to elimination entities.

Select the property "ELIM" as "Y" to indicate the elimination entity.

Regards

Naveen

[Former Member]

Entity dim is properly configured as per SAP guide lines.

[Former Member]

Time | Parterner| Rptcurrency|Acct| Category| Datasrc| Flow| Groups| Intco| Amount

2010.APR | E_US |USD| ICSALES | 100 | INPUT | F_NONE |G_NONE | I_JP |20.000,0000000-

2010.APR | E_JP | USD | ICCOST | 100 | INPUT | F_NONE | G_NONE | I_US | 20.000,0000000

Groups Dim:

ID | EVdescriptionj | curr_type

LC | Local currency | L

G_NONE | No Group | L

Entity Dim:

ID | EvDescription | Intco | Currency

E_US | USA | I_US | JPY

E_JP | JAPAN | I_JP | USD

Intco Dim:

ID | Evdes | Entity

I_JP | Intco Japan | E_JP

I_US | Intco US | E_US

Datasrc Dim:

ID | Evdes | datasrc_type | is_converted

INPUT | Manual input | I | Y

AJ_ELIM | Adj Elimin | A |

Does above configuration requires any modification ?

thanks.

[Former Member]

Hi Naresh,

I am not finding any elimination entity as part of your entity dimention.

create one entity called ex: E_DUMMY under node between E_US and E_JP then select ELIM property as Y

Regards

Naveen

[Former Member]

Have you maintained property called "ELIMACCT" and buiness rule for US elimination????

[Former Member]

yes i maintained Account dim with ELIMACC property.

ID | EVDES | ACCTYPE | ELIMACC

ICSales | Sales | INC | ICDUMMY

ICCOST | Expense | EXP | ICDUMMY

ICDUMMY | Dummy | INC |

Maintained business rule and confirmed bus rule table also successfully

ID | SOURCE DATASRC | DESTINATION DATASRC | Remark

IC01 | INPUT | AJ_ELIM | Intco tr elim

[Former Member]

What about elimination entity????

[Former Member]

Entity Dim:

ID | EvDescription | Intco | Currency |parenth1 |ELIM

E_US | USA | I_US | JPY | E_ALL |

E_JP | JAPAN | I_JP | USD | E_ALL |

E_ELIM | Elim entity | USD | E_ALL | Y

E_ALL | All entity | USD |

[Former Member]

I resolved issue.

Adjusted script as below

*RUN_PROGRAM US_ELIM

CATEGORY = %C_CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

//GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%]

*ENDRUN_PROGRAM