Skip to Content
0
Former Member
Sep 27, 2011 at 04:51 AM

US elimiation

24 Views

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