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