Skip to Content
avatar image
Former Member

SAP BPC LOOKUP ISSUE with more than one variable

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

Add comment
10|10000 characters needed characters exceeded

  • 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

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 23, 2016 at 07:25 AM
    -1

    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

    Add comment
    10|10000 characters needed characters exceeded

    • "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?

  • Dec 15, 2016 at 04:28 PM

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

    Upgrade required to 800 SP18

    Add comment
    10|10000 characters needed characters exceeded