Symptom
You have saved a hierarchy to your report to show expanded results but after saving your view the hierarchy is not expanded.
Environment
-
SAP Cloud For Customer
-
SAP Business ByDesign
Reproducing the Issue
-
Go to any report and open it.
- Click on the cog wheel icon and then click on Table Settings.
-
You set the hierarchy settings at the table level.
-
Save the view.
-
You notice that the hierarchy is not saved.
Cause
You have set the hierarchy settings at the table level and not on the characteristic.
Resolution
To show expanded hierarchy, you need to set the hierarchy on the actual characteristic and not on the table. To do this follow the below steps:
For Business ByDesign
-
Open any report and run it.
-
Click on the View button.
- Click on the 3 dots ... next to the characteristic.
- Click on characteristic Settings.
- Set the hierarchy to what you want.
- Save the view.
In Cloud For Customer
-
Open any report and run it.
-
Click on the Rows and Columns tab.
- Click on the 3 dots ... next to the characteristic.
- Click on Characteristic Settings.
- Set the hierarchy to what you want.
- Save the view.
Keywords
Hierarchy, table, rows, columns, report, characteristic, characteristic settings , KBA , 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 ; SAP Cloud for Customer core applications all versions