Skip to Content
0
May 26, 2018 at 01:55 PM

Approach/Logic to achieve below requirement in SAP BO Webi report

106 Views Last edit May 27, 2018 at 01:16 PM 2 rev

Hi,

Below are the city names with their codes in a table like below

City Code

Sydney B

Sydney A

Perth D

Perth C

Melbourne E

Melbourne F

Adelaide B

Adelaide C

Like there are more no of city names available in table with its codes.

The requirement is: Need to display the cities having code 'B' and take flag as YES for the same. If the B code is not available against a city then display Code B against those cities and take flag as NO. Besides, required to display distinct city names though multiple entries and display Code and its respective flag.

the final required output should looks like below.

City Code Flag

Sydney B Yes

Perth B No

Melbourne B No

Adelaide B Yes

Please suggest how to achieve the above requirement in SAP BO WebI. We are using BO 4.1 SP5 version.

Thanks in Advance.