Skip to Content
0
Former Member
Jun 29, 2009 at 10:22 AM

Help on Lookup command

12 Views

Hello,

I'm trying to use the lookup to copy a value from an application to another.

The source application has a dimension more than the destination application, the "Client" dimension.

Can someone explain me how it works exactly? I have tried several things but I can't manage to copy the value in the destination application.

The code I have written is:

*LOOKUP SALES

*DIM Category = "BUDGET"

*DIM LACC:Account = "SalesUnits"

*DIM MEASURES= "Periodic"

*DIM Client= "ALL"

*DIM Product = %SET%

*DIM Entity = %SET%

*ENDLOOKUP

*WHEN CATEGORY

*IS BUDGET

*REC(EXPRESSION = LOOKUP(LACC), Account = "SalesUnits" )

*ENDWHEN

*COMMIT

One additional question, can I skip the when/endwhen command and use only the REC command?

Thanks in advance and best regards,

Ana