Use of two LOOKUPs in same script

[former_member542777]

We have situation, where we want to pull data from Ownership model in consolidation model script.

While using LOOKUP we are facing issue as we would like to pull the Ownership data with condition as when the account is OwnAcc1 then the entity should be Entity1 else for all other accounts entity should be user input.

for example,

*LOOKUP Ownership
*DIM INTERCO = I.NA
*DIM CONSOLGROUP = MG_GROUP
*DIM CATEGORY = ACTUAL
*DIM MEASURES= YTD
*DIM M01:OWNACCOUNT = TR_PF_111
*DIM M02:OWNACCOUNT = TR_PF_222
*DIM M03:OWNACCOUNT = TR_PF_333
*ENDLOOKUP

and secondly we need

*LOOKUP Ownership
*DIM INTERCO = I.NA
*DIM CONSOLGROUP = MG_GROUP
*DIM CATEGORY = ACTUAL
*DIM MEASURES= YTD

*DIM ENTITY = ENTITY1
*DIM M04:OWNACCOUNT = DBD_MTD
*ENDLOOKUP

We need to use these two LOOKUP conditions in same script in consolidations model.

*WHEN ACCOUNT

*IS %VERIABLE1%

*REC(FACTOR=LOOKUP(M01)*1/(100),TIME=%TIME_SET% ,ACCOUNT=PF_1111)

*REC(FACTOR=1/LOOKUP(M04),TIME=%TIME_SET% ,BPCGACCOUNT=PF_2222_PS)

*ENDWHEN

while executing this script we are getting error - Multiple LOOKUPs not allowed in same cube.

BPC 810 SP08

BW 740 SP13

[former_member186338 · Accepted solution]

Try to add line in the first lookup

*DIM MO4:ENTITY=ENTITY1

and

*DIM M04:OWNACCOUNT = DBD_MTD

You will have single lookup.

[former_member542777 · Accepted solution]

Its working.

Thanks for your help