SAP BPC LOOKUP ISSUE with more than one variable

[former_member325373]

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

[Former Member]

Hi Raj,

I don't think upgrade is required in your case. This correction comes in SP18, but since your SP16 is higher than SP14 you can just apply OSS Note Vadim recommended.

It's definitely less effort than writing a BADI.

Regards,

Gersh

[former_member325373]

Thanks Vadim for your immediate response, Due to multiple implementation on to the same server and timelines we are not upgrading the current system, but come up with an alternative solution to use Customize BADI implementation

Thank You, Raj

[former_member186338]

"but come up with an alternative solution to use Customize BADI implementation" instead of SP upgrade - unbelievable!!! Do you really think it's a professional approach?

[former_member186338]

The issue is described here: https://launchpad.support.sap.com/#/notes/2136166/E

Upgrade required to 800 SP18