Skip to Content
Author's profile photo Former Member

Removing Compounded objects from Web Intelligence report


When we are creating Web Intelligence report on top of SAP Business Explorer Query, we will come across many objects which has compounded with other objects like:


Controlling Area / Cost Center

Chart of Accounts / G/L Account


Compounded objects are taken care in SAP Business Explorer query when we have all the required objects either in Rows or in Free Characteristics.


When we use the same in Web Intelligence report, it shows the data with the compounded objects. 



















We can use the basic functions which is available in the Formula editor to achieve in Web Intelligence report.








1) Find the length of the data say FO00/# = 6

2) Position the “/” in the data say FO00/# = 5

3) Subtract step 1 and step 2 say 6 – 5 = 1

4) Apply right function with the output of step 3 on data



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.