Skip to Content
0
Former Member
Jun 10, 2016 at 04:43 AM

*REC Dependent on Property of Target Dimension Member

47 Views

Hi Experts

This doesn't work, but I'm hoping the bold lines explains what I'm trying to do

$TGTVER$ is a single member passed from DMP

*SELECT(%TGTTYPE%,GROUP,VERSION,ID=$TGTVER$)

*WHEN ASSETCLASS.DEPN_EXP_ACC

*IS %DEPACC%

*REC(FACTOR=((%TGTTYPE%="FORECAST")*1),VERSION=$TGTVER$,COSTCENTRE=COSTCENTRE.FCGROUP,DATASRC=Input)

*REC(FACTOR=((%TGTTYPE%<>"FORECAST")*1),VERSION=$TGTVER$,DATASRC=Input)

*ENDWHEN

That is: when the GROUP Property of the Target Version is FORECAST, write to the COSTCENTRE member that matches COSTCENTRE.FCGROUP in the source. In all other cases, write to the same COSTCENTRE member as the source.

I tried this as well. No sausage. Ternaries probably only work with values

*REC(FACTOR=(%TGTTYPE%="FORECAST") ? -1:0,VERSION=$TGTVER$,COSTCENTRE=COSTCENTRE.FCGROUP,DATASRC=Input)