Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script Logic > Obtain the value of dimension property inside REC statement

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?

Former Member
Not what you were looking for? View more on this topic or Ask a question