Symptom
When a hierarchy is enabled for a report field, the value help in the Excel report is empty.
It works in the browser report.
Environment
- SAP Cloud for Customer
- SAP Business byDesign
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Reports.
- Find your report and open it in Excel.
- 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.
Cause
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.
Resolution
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.
Keywords
report, hierarchy, variable, empty, does not open, reporting, business analytics, excel , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement