SAP Knowledge Base Article - Public

3778076 - SAC add-in reports shows no data for datasphere models with FixedFilter with a variable reference, while data analyzer/stories return data – SAP analytics cloud add-in for Microsoft office

Symptom

  • In the SAP Analytics Cloud add-in for Microsoft Office, reports connected to SAP Datasphere analytic models with FixedFilter with a variable reference. 
  • The same models return data correctly in SAC Data Analyzer and SAC stories. 
  • No error is shown in the add-in; only empty results are returned.

Environment

  • SAP Analytics Cloud add-in for Microsoft Office
  • SAP Analytics Cloud
  • SAP Datasphere 

Reproducing the Issue

  1. Sign in to the SAC add-in for Microsoft Office.
  2. Open an SAC add-in workbook connected to a SAP Datasphere analytic model where FixedFilter with a variable reference.
  3. Refresh the workbook in the SAC add-in: no data is returned.
  4. Using SAC Data Analyzer or an SAC story on the same model, run the same query. Data is returned as expected.

Cause

Product issue

Resolution

  • SAC Excel Add-in release 2026.17 which is planned for the first week of August, 2026(August 3) will include the correction to resolve the issue. 
  • As a temporary workaround, remove FixedFilter with a variable reference in the affected Datasphere models to display data in the SAC add-in reports. 

See Also

  • 3652483 - SAP Analytics Cloud Add-in Preview Version
    3085993 - Troubleshooting guide for the SAP Analytics Cloud, add-in for Microsoft Office
  • 3200458 - Creating Support Users in SAP Analytics Cloud
  • 2891554 - How to create a Support User in SAP Datasphere

Keywords

sac add-in, excel add-in, datasphere, data access control, dac, no data, blank report, direct connection, data analyzer shows data, sac story works, refresh returns empty, har trace, console log, support user , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-FLY , Firefly used for HANA , Bug Filed

Product

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