Skip to Content
0

SAP BPC LOOKUP ISSUE with more than one variable

Dec 15, 2016 at 04:12 PM

66

avatar image

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

10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raj Shekar 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

Show 1 Share
10 |10000 characters needed characters left 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?

0
Vadim Kalinin Dec 15, 2016 at 04:28 PM
0

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

Upgrade required to 800 SP18

Share
10 |10000 characters needed characters left characters exceeded