Hello All,
I have one script to solve, and I want to know If it's possible to do the operation described below.
I have these dimensions and dimension members:
ENTITY
ID Entity_Dest
EntityA EntityC
EntityB EntityD
EntityC
EntityD
ACCOUNT
ID Property1
AA CAL
BB NOCAL
I have these data in application
ENTITY ACCOUNT DATASRC SignData
EntityA AA INPUT 200
EntityB AA INPUT 300
EntityC BB INPUT 5
EntityD BB INPUT 10
I want to calculate (Note: replace } by ])
*WHEN ACCOUNT.Property1
*IS CAL
//Multiply the signdata by a factor, these factor can be obtained from Entity_Dest
*REC(FACTOR = ([ENTITY}.[Dinamic value, the property ENTITY.Entity_Dest},[ACCOUNT}.[BB}),DATASRC=CALC)
*ENDWHEN
I want these data as output
ENTITY ACCOUNT DATASRC SignData
EntityA AA INPUT 200
EntityB AA INPUT 200
EntityC BB INPUT 5
EntityD BB INPUT 10
EntityA AA CALC 200*5=1000
EntityB AA CALC 300*10=3000
The code below is not running: (Note: replace } by ])
*WHEN ACCOUNT.Property1
*IS A
*REC(FACTOR = ([ENTITY}.[ENTITY.Entity_Dest},[ACCOUNT}.[BB}),DATASRC=CALC)
*ENDWHEN
It says this message: UJK_VALIDATION_EXCEPTION:The member "ENTITY.Entity_Dest" does not exist
How can I obtain the value of the property Entity_Dest from ENTITY inside the REC statement? Is that posible?