Custom Sort of Duplicated row walues in Webi based on SAP BW Universe

[Former Member]

It is a duplicate thread i have already posted in Integration kits - SAP section.

This is regarding custom sorting of row value which are duplicated in Webi which is based on SAP BW Universe.

I have created Webi Report based on Characteristic structure. Using Alerter I provide some space for child node to notify it as child node below a parent node.

Please see a sample table below:

AAAA

onpeak

midpeak

offpeak

BBBB

onpeak

midpeak

offpeak.

If I enable Avoid duplicate row aggregation, i will be able to see duplicate rows for "onpeak" etc. Since Webi does a default sorting, I have to make a custom sort to replicate the structure followed. And in custom sort i dont see duplicated rows, and i see only one "onpeak". Accordingly if I try to sort using custom sort, then the result will be

AAAA

onpeak

onpeak

midpeak

midpeak

offpeak

offpeak

BBBB.

Please let me know if anyone has any solution for this.

I have already created report with modifying the row names in backend by adding letter before its value for example "1offpeak" for the duplicated row and then removing the letter "1" in webi using substring. But i know this is the crude way of doing it.

[Former Member]

I have changed the naming convention in BI structure by introducing a white space before the name to avoid duplication and used it in report. Not a good solution anyway.