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