Symptom
The report hierarchy is not shown when a report is sent as an Excel file via broadcast.
Environment
- SAP Business byDesign
- SAP Cloud for Customer
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to Broadcasts.
- Enter the selection and view of the report with a hierarchy.
- Send the Broadcast as any Excel file: .csv, .xml or .xslx.
- When you open the e-mail attachment you will not see the hierarchy.
Cause
.csv and .xslx are not supported for hierarchies. .xml is supported but only as a snapshot.
Resolution
To see the hierarchy in a broadcasted file, please use .xml as it works more like snapshot of the report view. The hierarchy must be fully expanded in the view of the report otherwise it will only show the levels expanded.
Keywords
.xml, .csv, .xslx, broadcast, excel, C4C, ByD, hierarchy, hierachy, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement
Product
SAP Business ByDesign all versions