SAP BPC LOOKUP ISSUE with more than one variable

249 Views

Hi Experts,

The look up is working(giving result value) for only one variable that to the last assigned variable only.

Tested for the following scenarios -

scenario 1)

*LOOKUP RATE

*DIM USD:INPUTCURRENCY="USD"

*DIM EUR:INPUTCURRENCY="EUR"

*DIM R_ACCT="AVG"

*DIM RATEENTITY="GLOBAL"

*DIM TIME="2017.12"

*ENDLOOKUP

*REC(EXPRESSION=LOOKUP(USD), ..... Giving zero value as a result

*REC(EXPRESSION=LOOKUP(EUR), ..... value based on exchange rates coming

If I swipe the variable(like in scenario 2) EUR first and second USD

Scenario 2 -

*LOOKUP RATE

*DIM EUR:BINPUTCURRENCY="EUR"

*DIM USD:BINPUTCURRENCY="USD"

*DIM R_ACCT="AVG"

*DIM RATEENTITY="GLOBAL"

*DIM TIME="2017.12"

*ENDLOOKUP

*REC(EXPRESSION=LOOKUP(USD), .....value based on exchange rates coming

*REC(EXPRESSION=LOOKUP(EUR), .....Giving zero value as a result

The same behavior for other models too with using lookup

The system is upgraded from BPC 7.5 NW to BPC 10 NW

Server details are -

Component Release SP-Level support package desc. Of Component SAP_BW 730 12 SAPKW73012 SAP Business Warehouse CPMBPC 800 16 SAPK-80016INCPMBPC CPM Business Planning and Consolidation

Thank You,

Raj