3705426 - Hierarchy folder descriptions appear as boxes (□□□) in analytical model

In SAP Datasphere, when using hierarchies in an analytical model, hierarchy folder descriptions appear as unreadable boxes (□□□) instead of meaningful text during data preview or consumption. The hierarchy structure and nodes are visible, but the textual descriptions are not rendered correctly.

SAP Datasphere

1. Open an analytical model in SAP Datasphere.
2. Open data preview.
3. Drag a characteristic  to the rows section.
4. Enable a hierarchy.
5. Observe that hierarchy folder descriptions are displayed as boxes (□□□).

• The issue occurs when hierarchy configuration columns (such as NODEID) contain binary or non-character data types in SAP HANA.
• Hierarchy member identifiers and descriptions are expected to be stored in character-based formats.
  If binary data is used, the hierarchy structure may still load, but text rendering fails in the analytical model UI.

Ensure that all columns used in hierarchy configuration (for example, NODEID, parent node ID, or description fields):

• Are character-based data types.
• Do not contain binary or encoded values

After correcting the data type and content:

1. 1. Activate the hierarchy again.
   2. Reopen the analytical model.
   3. Re-run the data preview.

The hierarchy descriptions should now display correctly.

Hierarchy, analytical model , folder description , boxes , NODEID, binary data  , KBA , DS-MD-AM , Analytic Model , Known Error