SAP Knowledge Base Article - Public

3227757 - Excel Report Variable is Empty


When a hierarchy is enabled for a report field, the value help in the Excel report is empty.

It works in the browser report.


  • SAP Cloud for Customer
  • SAP Business byDesign

Reproducing the Issue

  1. Go to the work center Business Analytics and the view Design Reports.
  2. Find your report and open it in Excel.
  3. In the selection, open the value help for the required field, for example Account.

You can see that no values are listed here.

If you open the report in the browser, you can see values.


There is a fixed hierarchy maintained on the respective field in the report wizard. This setting is currently not supported in the Excel value help.


Please raise a request on the Influence portal if you would like to request an enhancement of this feature.

In the meantime, you can remove the hierarchy setting by editing the report with the report wizard.


report, hierarchy, variable, empty, does not open, reporting, business analytics, excel , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement


SAP Cloud for Customer core applications all versions