Skip to Content
avatar image
Former Member

Multi LOOKUP on same cube not allowed

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 27, 2015 at 06:16 AM

    P.S. In case of:

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


    it's better to use push from Ownership model with DESTINATION_APP

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 06:02 AM

    "So I thought I will pass the variables one by one using the *FOR/*NEXT function." - incorrect idea! FOR/NEXT will simply copy text - as a result you will have multiple lookups!

    But the script in general is strange, what do you want to achieve? Please read: How To: Ask questions about Script Logic issues

    Vadim

    Add comment
    10|10000 characters needed characters exceeded