We need to sort account hierarchy nodes in a specific sequence to display hierarchical data in the desired order on the income statement and balance sheet reports. We are seeking a feature within the semantic layer to sort the descriptive column values according to a designated code (sort order) column. This will enable us to define the sorting sequence according to our needs and utilize the sort order column to display the hierarchy nodes accordingly.

 In on-premise version of OBIEE RPD we have an option to set the 'Sort Order' for logical column based on another column which is missing in FAW as shown in below