Skip to Content
0
Former Member
Oct 27, 2015 at 05:51 AM

Multi LOOKUP on same cube not allowed

177 Views

Hi Experts,

I am Trying to use *LOOKUP/*ENDLOOKUP but I am getting an error "Multi LOOKUP on same cube not allowed".

My understanding is you cannot provide more than one variable to the lookup function simultaneously.

So I thought I will pass the variables one by one using the *FOR/*NEXT function.

But I am still getting the same error. 😔

Is there any work around to this limitation of *LOOKUP/*ENDLOOKUP?

Please see below code.

*SELECT(%ENT%,"[ID]","ENTITY","[CALC]=N")

*FOR %E%=%ENT%

*WHEN AUDITTRAIL

*IS "XXXX"

*WHEN ACCOUNT

*IS "YYYY"

*LOOKUP Ownership

*DIM NCIFLASH:TIME=%TIME_SET%

*DIM NCIFLASH:CATEGORY="AAAA"

*DIM NCIFLASH:ENTITY=%E%

*DIM NCIFLASH:INTERCO="I_NONE"

*DIM NCIFLASH:SCOPE="G_ABCD"

*DIM NCIFLASH:O_ACCOUNT="POWN"

*DIM NCIFLASH:MEASURES="PERIODIC"

*ENDLOOKUP

*REC(FACTOR=1-LOOKUP(NCIFLASH), ACCOUNT="XYZ")

*ENDWHEN

*ENDWHEN

*NEXT

Thanks in anticipcation

Collin.