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

• 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.

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

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.

Under investigation by Development

• This issue is currently under investigation by Development. Please follow this KBA for updates.
• As a temporary workaround, remove FixedFilter with a variable reference in the affected Datasphere models to display data in the SAC add-in reports. 

• 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

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

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