BW Business Explorer (SAP BEx)
How to change order of Keyfigures in reports
Purpose:
Sometimes in reports it is required to change the order of keyfigures during runtime.
Overview:
You execute the report and want to compare or view the data based on a particular order of keyfigure during runtime.
You don’t want to change the order of keyfigure in Query Designer but only want to change during runtime for that execution
Steps to follow to change the order of Keyfigure
- Execute Query in Java web
- Do right click on Keyfigure
- From keyfigure context menu
- Select Filter -> Select filter value
- Change the order or keyfigure as per your requirement
- Click ‘Ok’.
Now you need to follow the below steps to get the order of keyfigures correctly displayed as per changed order.
- Do right click on Keyfigure
- From key figure context menu
- Goto Properties
- Select Characteristic
Key figure property window opens up.
In the Properties of Key figures
- Goto ‘Sorting’ tab
- Select Sort by -> Selection
This will sort the the order of keyfigures during runtime.