SAP Knowledge Base Article - Public

3195600 - Download of Hierarchy in Excel via Broadcast not shown

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

  1. Go to the Business Analytics work center.
  2. Go to Broadcasts.
  3. Enter the selection and view of the report with a hierarchy.
  4. Send the Broadcast as any Excel file: .csv, .xml or .xslx.
  5. 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