SAP Knowledge Base Article - Public

3847816 - Data Analyzer exports blank cells instead of member IDs when descriptions are missing in Datasphere Live Connection— SAP Analytics Cloud Data Analyzer

Symptom

When exporting a Data Analyzer table using an SAP Datasphere live connection to Excel (XLSX/CSV), members without a text attribute are exported as blank cells, although their IDs are displayed in the browser.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Open a Data Analyzer table.
  2. Set the dimension display to Description (Text).
  3. Ensure some members have IDs but no descriptions.
  4. Export the table to Excel.
  5. Observe that the corresponding cells are blank.

Cause

  • The previous behavior of exporting member IDs when text attributes were missing was incorrect and caused by a defect in Data Analyzer's value exception handling.
  • The defect was fixed in early July 2025, likely delivered in QRC4 2025. After the fix, NullValue exceptions are correctly handled, and CSV/XLSX exports produce blank cells instead of falling back to member IDs, as designed.

Resolution

The behavior is working as designed. CSV/XLSX exports do not support falling back to member IDs when text attributes are missing.

If you would like this feature, please vote for the following enhancement request:

Add a missing-text fallback option for CSV/XLSX exports (CIS884-I-9755)

Keywords

Data Analyzer, Excel export blank, CSV export blank, Description empty, missing text attribute, ID fallback, key vs text, live connection, SAP Datasphere, member text, row header, column header, export behavior, Null value, QRC4 2025 change , KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem

Product

SAP Analytics Cloud all versions