Skip to Content
0
Former Member
Nov 04, 2011 at 09:40 AM

Using dimension properties in LOOKUP

116 Views

Hi,

I'm trying to use dimension properties in a LOOKUP, but when I execute the script the log tells me that COMPANY, SALESORG, PRODUCT and TRANSCURRENCY is not defined and therefore create a lookup on all members.

THe usage of properties in LOOKUP is described in the documentation, but somehow it doesn't seem to work for me. Can anyone help me?

*LOOKUP ACTIVITYPLAN

*DIM FCIC:ACCOUNT= "FULLCOST"

*DIM FCIC:PARTNER="I_NONE"

*DIM FCIC:COMPANY=PARTNER.ENTITY

*DIM FCIC:SALESORG=PARTNER.ENTITY

*DIM FCIC:PRODUCT=PRODUCT.PRODREF

*DIM FCIC:TRANSCURRENCY=PARTNER.CURRENCY

*DIM COUNTRY = "CO_NONE"

*DIM DATASOURCE = "INPUT"

*DIM PROFITCENTER = "YB99"

*DIM RPTCURRENCY = "LC"

*ENDLOOKUP

Regards,

Lars

Edited by: Lars Johansen on Nov 4, 2011 10:41 AM

Edited by: Lars Johansen on Nov 4, 2011 10:41 AM