Symptom
When previewing data of a Custom Analytical Query, it's showing "#" as a value in some columns.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Go to Custom Analytical Query app.
- Open and preview the Query.
- Some fields contains "#" as a value.
Cause
The "#" symbol in some fields of the Custom Analytical Query report is because those fields are not populated in the Custom CDS View.
Resolution
It could be found that there are empty fields in some columns, when opening Custom CDS Views application and previewing the underlying Custom CDS View of the query.
These empty fields are being reflected to the Custom Analytical Query.
Keywords
custom analytical query, #, preview data, empty , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem