Dear experts,

Inside DEFAULT.LGF, I am using LOOKUP to get a value that is stored in the same member of COMPANY dimension as the current member of the record being treated. For other dimensions the value is stored on specific members, this part is not a problem.

I am stuck one the syntax on the DIM instruction for COMPANY as indicated below:

*LOOKUP PurchasePlan  
*DIM FOB:ACCOUNT = ACC_93   
*DIM FOB:TIME=Year.INP   
*DIM FOB:SUPPLIER=SUP_UNDEF   
*DIM FOB:COMPANY= ???  //what syntax to use?
*DIM FOB:PHASE=P_002
*ENDLOOKUP

Then my calling code will be

*WHEN ACCOUNT
*IS ACC_52
*REC(FACTOR=LOOKUP(FOB),ACCOUNT=ACC_162) //FOB
*ENDWHEN

I have tried the following with no success (no value retrieved by LOOKUP(FOB))

*DIM FOB:COMPANY=COMPANY.ID

*DIM FOB:COMPANY=COMPANY

One solution I found is working is to write it as follow:

*DIM FOB:COMPANY=%COMPANY_SET%

But it works only it my scope have only 1 COMPANY.

When I load a file that have data of 2 different COMPANY and that triggers the DEFAULT logic, the package fails and I have the following error:

(DI45 and DI75 are members of COMPANY dimension).

So it seems all company members are inside %COMPANY_SET% variable at the same time.

Any help would be very appreciated.

Thanks in advance

Alexandre