Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded