Interpret code

[Former Member]

hi mates, could any one explain what below code do,

*XDIM_MEMBERSET P_ACCT = CE0004010,CE0652000 

*WHEN P_ACCT 

*IS "CE0004010"

*REC(EXPRESSION=([P_ACCT].[CE0004010],[P_ACTIVITY].[NONE])/([P_ACCT].[CE0652000],[P_ACTIVITY].[LABPRD]), RPTCURRENCY=[ENTITY].CURRENCY, P_ACCT=CE0661000) 

*ENDWHEN

As per my understand, below line generates a numeric value for Expression

([P_ACCT].[CE0004010],[P_ACTIVITY].[NONE])/([P_ACCT].[CE0652000],[P_ACTIVITY].[LABPRD]), 

then that value is multiplied by source record for posting into target record(P_ACCT=CE0661000).Also, target record RPTCURRENCY dim value is posted with [ENTITY].CURRENCY value.

Is above interpretation is correct?

TH

[esjewett · Accepted solution]

Hi Naresh,

I think you've got it right except that this code doesn't multiple by the source value. In order to do that you would need to have your expression statement read as follows:

%VALUE%*([P_ACCT].[CE0004010],[P_ACTIVITY].[NONE])/([P_ACCT].[CE0652000],[P_ACTIVITY].[LABPRD])

Ethan

P.S. When you use the code formatting, please make sure you don't use long lines of text. It really messes up the formatting for the entire thread.