3737187 - [RESOLVED] Datasphere Analytic Model range variables default to "(no value)" after Hana Cloud upgrade

• After a database upgrade, analytic model preview shows “(no value)” as a default selection for restriction/filter variables with selection type “range”.
• The SAC Excel add‑in does not display the “(no value)” option in prompts; running the model returns blank output.

• SAP Datasphere
• SAP Analytics Cloud
• SAP HANA Cloud

1. Open an analytic model in preview or a SAC report.
2. In the variable prompt, observe that restriction/filter variables with selection type “range” include a preselected “(no value)” entry.
3. Run the preview and observe that no data is returned unless “(no value)” is removed from the selection.
4. In the SAC Excel add‑in, open the same model: the “(no value)” entry is not shown in the prompt, and running the query returns a blank result.

The issue has occurred after the HANA Cloud upgrade to version 2026.2.6. HANA Development team is working on the root cause analysis.

1. Note that a permanent fix is under investigation by the HANA Database team. Please follow this KBA for updates.
2. Workaround (analytic model CSN/JSON edit):
   1. Export/download the analytic model definition (CSN/JSON).
   2. Identify variables with selectionType = AnalyticModelVariableSelectionType.RANGE that are impacted.
   3. In each affected variable, locate the defaultValue array.
   4. Remove any default range object whose lowValue is an empty string ("").
   5. Save the file and upload/replace the analytic model with the edited CSN/JSON.
   6. Deploy the model from Analytic Model editor and validate in preview and in the SAC Excel add‑in.
   7. This workaround restores expected behavior; no revert is required after the product fix.
      
      
3. Workaround for SAC Excel Add-in:

   On the variable dialog:
   1. For each affected variable, select any value using the value help
   2. Unselect the selected value
   3. Click OK

   Data will be shown normally. This workaround does not require any change on the existing models.

Update on April 8, 2026 13:30 UTC: 

Our development team is working on a solution with high priority.  KBA will be updated when there is a further progress.

Update on April 9, 2026 20:30 UTC: 

Our development team is working as a top priority to resolve the issue. KBA will be updated with an expected delivery date as soon as we have more information.

Update on April 13, 2026 14:00 UTC:

Our development team has made further progress on the fix. We will notify you as soon as the implementation date is set.

Update on April 14, 2026 14:30 UTC:

The fix deployment is in progress. KBA will be updated when the deployment is finished.

Update on April 15, 2026 10 UTC:

Fix has been applied to all production tenants. The issue will be solved after redeploying the Analytic Models.

Our recommendation is to deploy the model from Analytic Model editor.

datasphere, analytic model, range variable, restriction variable, default value, no value, preview no data, sac excel add-in, data analyzer, ina, mds, hana, empty string filter, getresponse, csn json , KBA , DS-MD-AM , Analytic Model , LOD-ANA-AD , Analytics Designer , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , Problem

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions ; SAP Datasphere all versions