Skip to Content
0
Former Member
Feb 18, 2009 at 09:02 AM

Two Lookup on One Query

25 Views

Can we use Lookup function twice in one query ??

Cause in the Log file, I only see the last lookup query.

Or Any Suggesion for this case ?

Here's the sample :

*SELECT(%PRMFGList%,"[ID]","PROCESS","SFG_Pos='P'")

*XDIM_MEMBERSET PROCESS = %PRMFGList%

*LOOKUP FINANCE

*DIM SalesQty:OTHERS = PROCESS.SFG

*DIM SalesQty:TPDTLS = TPDTLS.ID

*DIM SalesQty:TPYEARS = TPYEARS.ID

*DIM SalesQty:CATEGORY = CATEGORY.ID

*DIM SalesQty:TIME = TIME.ID

*ENDLOOKUP

*LOOKUP FINANCE

*DIM LotSize:OTHERS = PROCESS.SFG

*DIM LotSize:TPDTLS = TPDTLS.ID

*DIM LotSize:TPYEARS = TPYEARS.ID

*DIM LotSize:CATEGORY = CATEGORY.ID

*DIM LotSize:TIME = TIME.ID

*ENDLOOKUP

*WHEN Account.ID

*IS "Qty"

*REC(FACTOR=-(LOOKUP(SalesQty)/LOOKUP(LotSize)),ACCOUNT=QtyRMUsage)

*ENDWHEN

*COMMIT