Symptom
You are trying to use a search condition between asterisks to filter on a 'TEXT' field but the report displays 'No Data Available To Display' message or you cannot see those expected values.
Environment
- SAP Cloud for Customer
- SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Reports work center view.
- Search for the concerned report ID or name.
- Open it.
- In the Report Selection, type in the data you are looking for between asterisk (e.g. *test*) for the concerned characteristic.
- Refresh it.
- You cannot see expected values but you can see the message 'No Report Data Available To Display'.
Cause
The system currently does not support to filter on fields of 'TEXT' type via the Report Selection.
Resolution
To check if the field which has been used is of 'TEXT' type, follow these steps below:
- Go to the Business Analytics work center.
- Go to the Design Data Source work center view.
- Search for the concerned data source ID or name.
- Select it.
- Click on the magnifying glass on the right.
- Search for the concerned characteristic.
- You can see the field type on the 'Characteristic Type' column.
Additionally, if you would like to have this functionality available in a future release, we would advise you to address it as a new suggestion in our SAP Customer Influence. The Customer Influence site allows customers to log Improvement Requests themselves and have the ability to work directly with our technology and development group. The SAP Customer Influence is available at: https://influence.sap.com.
Keywords
no report data available to display, text field filter, filter word asterisk, filter asterisk, filter text field, filter text, filter word, filter contains. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To