Symptom
Records are shown as "Cannot be shown" in Data Viewer in Datasphere's Data Builder.
Environment
- SAP Datasphere
Reproducing the Issue
- Select an object in Data Builder
- Check the Data Viewer
Cause
This behavior is documented in SAP Datasphere Help Portal:
Viewing Object Data :
"If a column has Binary, Large Binary, ST_Point, and ST_Geometry set as data type, the data viewer is unavailable, and records are shown as Cannot be shown. If no data can be found, the data viewer shows it as NULL."
Resolution
The column should still work when used in modelling, filtering and in reporting.
The data is actually being extracted even though not visible.
Keywords
Records, shown, "Cannot be shown", Data, viewer, Datasphere , KBA , DS-DI-VIW , View Persistency and Runtime , Problem