Sorting in BPS Layouts

In BPS manual layouts, data is displyed in a sorted format which is always in ascending order based on lead column characteristics.

Sometimes business scenario demands to  display the data in a different order or based on a different characteristics. These particular scenarios are not handled by BPS layouts.

This blog will provide a simple solution for these kind of scenarios.

Step by Step Procedure

• Create a hierarchy on the characteristics which is present in lead column. Make sure the nodes should be in the order you want data to be displayed/sorted.

• Create two different packages where one planning package will show default sorting order while second planning package will display data is an order required

•  Restrict the first planning package with the hierarcy that was created.

• Check the output for two different planning package selections
• Sort order with hierarchy restriction

• Sort oder with default restriction

This shows that we can sort the Manual Layout display in an order required by business by creating a hierarchy variable.