​Lookup in same model

[former_member661728]

Hello,

I have written a script logic which should bring me data from the same model. All the data is on static members except the dimension SALES_ORDER which is "the driver" of my following lookup.

I used to do it with a lookup statement , but it's returning 0

*XDIM_MEMBERSET ACTIVITY = SE

*XDIM_MEMBERSET AUDIT_TRAIL = LOCAL

*XDIM_MEMBERSET CURRENCY = LC

*XDIM_MEMBERSET ENGINE_FAMILY = <ALL>

*XDIM_MEMBERSET FRONT_OFFICE = <ALL>

*XDIM_MEMBERSET IG_OG = OG

*XDIM_MEMBERSET OTHER_COST_TYPE = OTHER_COST_TYPE_NA

*XDIM_MEMBERSET PART_NUMBER = <ALL>

*XDIM_MEMBERSET PAYER_CUSTOMER = <ALL>

*XDIM_MEMBERSET PERIOD = %PERIOD_SET%

*XDIM_MEMBERSET RATIO = SE

*XDIM_MEMBERSET SALES_ORDER = <ALL>

*XDIM_MEMBERSET SO_ITEM = <ALL>

*XDIM_MEMBERSET STP_CUSTOMER = <ALL>

*XDIM_MEMBERSET VERSION = ACTUAL

*XDIM_MEMBERSET WBS_REF = <ALL>

*LOOKUP MBS

*DIM RATIO = "SE"

*DIM ENGINE_FAMILY = "ENGINE_FAMILY_NA"

*DIM FRONT_OFFICE = "FRONT_OFFICE_NA"

*DIM ACTIVITY = "SE"

*DIM AUDIT_TRAIL = "METHODE_1_TMP"

*DIM CURRENCY = "EUR"

*DIM IG_OG = "IG"

*DIM OTHER_COST_TYPE = "OTHER_COST_TYPE_NA"

*DIM PART_NUMBER = "PART_NUMBER_NA"

*DIM PAYER_CUSTOMER = "PAYER_CUSTOMER_NA"

*DIM LOOKUP_SO:SALES_ORDER = SALES_ORDER.ID

*DIM SO_ITEM = "SO_ITEM_NA"

*DIM WBS_REF = "WBS_REF_NA"

*DIM MEASURES = "PERIODIC"

*ENDLOOKUP

*WHEN RATIO

*IS "SE"

*REC(EXPRESSION = LOOKUP(LOOKUP_SO),RATIO = "SE",AUDIT_TRAIL = "METHODE_1", CURRENCY ="EUR",IG_OG="OG")

*ENDWHEN

I used to work with solution below , but as I said my SALES_ORDER's dimension contains a dynamic value.

How Can I write a dynamic value in a tuple ?

*REC(EXPRESSION=([ENGINE_FAMILY].[ENGINE_FAMILY_NA],[FRONT_OFFICE].[FRONT_OFFICE_NA],[PART_NUMBER].[PART_NUMBER_NA],[PAYER_CUSTOMER].[PAYER_CUSTOMER_NA],[SO_ITEM].[SO_ITEM_NA],[STP_CUSTOMER].[STP_CUSTOMER_NA],[WBS_REF].[WBS_REF_NA],[AUDIT_TRAIL].[METHODE_1_TMP],[CURRENCY].[EUR],[ACTIVITY].[SE],[SALES_ORDER].[ID]),RATIO = "SE",AUDIT_TRAIL = "METHODE_1", CURRENCY = "EUR",IG_OG="OG")

Thank you for your Help.

BR,

Baraa

[former_member186338]

You don't need a lookup!

Just remove ",[SALES_ORDER].[ID]" from tuple

SALES_ORDER ID will come from WHEN/ENDWHEN loop

May be also the loop is incorrect, test:

*REC(EXPRESSION = 5,RATIO=SE,AUDIT_TRAIL=METHODE_1,CURRENCY=EUR,IG_OG=OG)

Do you see resulting records with 5?