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