Skip to Content
Author's profile photo Former Member

To get correct values in Summary BOBJ WEBI reports by using Bex query

This blog will help to understand logic involved to get correct values in BOBJ WEBI reports.

Step1) Bex query at detail level has two KF’s ie. Sales qty, Basic price

Material, Customer ID and Sales Representative ID as characteristics in Row.

Ex Bex Query

/wp-content/uploads/2013/11/p1_330936.jpg

2) Expected out put from the above query in BOBJ WEBI report by multiplying Sales Qty X Basic material Price is given below

  

Sales Reprensentative. ID

Sales Revenue

SREP08

4

SREP09

  1. 7.5

SREP10

65

SREP11

2

Grand Total

  1. 78.5

3) WEBI report Out put:

Webi report has been created by using above Bex query and out put for the same is given below & which is not matching to our requirement as shown above.

/wp-content/uploads/2013/11/p2_330937.jpg

 

4)To get correct result, please create one CKF in Bex query

  1. i.e. Sales Qty * Basic Price as shown in below

/wp-content/uploads/2013/11/p3_330944.jpg

5) Refresh Universe.

6) Modify Webi report for addition of new CKF field.

/wp-content/uploads/2013/11/p4_330945.jpg

Now check the WEBI result with respect to expected result in step 2. both are matching.

Note:  In this step , care has to be taken to add all the Bex query characteristic in Webi Query area  otherwise report will give wrong results again.

/wp-content/uploads/2013/11/p5_330946.jpg

Thanks & Regards,

Puja Yerunkar

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good One!

      Author's profile photo Former Member
      Former Member

      Nice!

      Author's profile photo Former Member
      Former Member

      Very Helpful Topic