mpandui
Technical User
- Nov 30, 2003
- 7
Does anyone know how to do a value lookup in business objects?
Example user Runs Report for Customer and gets back following sales data:
Customer A, Product X sales = $12,000
Customer B, Product X sales = $8,000
Rebate Table Stored in the Universe:
Customer Name Product Sales Level Rebate %
-------------- -------- ----------- ---------
Customer A X $2,000 0%
Customer A X $5,000 1%
Customer A X $10,000 2%
Customer A X $25,000 3%
Customer B X $4,000 1%
Customer B X $12,000 2%
I want business objects to do the lookup the appropriate rebate and put the resulting Rebate % in the report:
Customer A, Product X Rebate = 2%
Customer B, Product X Rebate = 1%
Example user Runs Report for Customer and gets back following sales data:
Customer A, Product X sales = $12,000
Customer B, Product X sales = $8,000
Rebate Table Stored in the Universe:
Customer Name Product Sales Level Rebate %
-------------- -------- ----------- ---------
Customer A X $2,000 0%
Customer A X $5,000 1%
Customer A X $10,000 2%
Customer A X $25,000 3%
Customer B X $4,000 1%
Customer B X $12,000 2%
I want business objects to do the lookup the appropriate rebate and put the resulting Rebate % in the report:
Customer A, Product X Rebate = 2%
Customer B, Product X Rebate = 1%