String aggregation on WEBI report level.
SAP BO V 4.1 SP2
Universe : eFashion.
I have shown the way we can aggregate the values on report level.
I have dragged State & City objects
My initial report looks like below:
Now I want to aggregate city names as per state.
So I want result as shown below:
To achieve the result follow the steps:
1) First drag State & City objects on report and sort result by State and City in ascending order.
2) Create dimension like
3)Create measure like
4) Create another measure to calculate rank
5) Apply report level filter using newly created measure Ranking
where Ranking = 1
6) Create another dimension
7) Drag this Final_Cities to report & then hide the column City.
Check your report you got your desired result.
I hope this will help while developing reports.