SAP Knowledge Base Article - Public

3055424 - Sorting with Hierarchy Enabled in Report

Symptom

You notice that sorting is not working as expected when hierarchy is enabled for any field in report view

Environment

SAP Cloud For Customer

SAP Business By Design

Reproducing the Issue

-> Go to business Analytics work center

-> Go to Design Reports

-> Search for any report and open it

-> Run the report

-> Enable the hierarchy for any of the characteristic/field in report view

-> Now if we click on sort on any field(either on characteristic or key figure), it wont sort data accordingly

Cause

This is known behavior. When hierarchy is enabled in the report, the sorting will not work

Resolution

Feature is working as expected

Keywords

Hierarchy, Report, Field, Characteristic, Key Figure, Sort, Not Working , KBA , report , hierarchy , field , key figure , not working , sort , characteristic , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions