Using dimension property in factor in *REC statement

[Former Member]

Hi all,

I have this script:

*WHEN BUSINESSPARTNER.ENTITY 

*IS<>"" 

*REC(FACTOR = ([ACCOUNT].[A_IC_PROFIT5_PERC],[ENTITY].[BUSINESSPARTNER.ENTITY],[BUSINESSPARTNER].[ENTITY.INTCO]),ACCOUNT = ACCOUNT.IC_PROFIT_STOCK_DEST,AUDITID = AD_12,SPECIFICATION = S_99)

*ENDWHEN

My problem is the entity and partner element in the factor. Basically when I am currently entity A with partner I_B I want to read the factor from entity B with partner I_A.

Is there a way to get this information?

Thanks,
Arnold

[former_member186338 · Accepted solution]

Use LOOKUP for the same model:

*LOOKUP xxx
*DIM FCT: ENTITY=BUSINESSPARTNER.ENTITY
*DIM FCT: BUSINESSPARTNER=ENTITY.INTCO
*ENDLOOKUP

...
*REC(FACTOR=LOOKUP(FCT),...

[Former Member]

Thanks Vadim