Symptom
- Unexpected filtering happening
- AO report is based on Datasphere entity - filtering issue
- When filtering the model by the field 'Exercise' several sources disappear, however, when placing the field 'Exercise' as a line it keeps it.
- The issue does not occur when previewing the data in SAP Datasphere perspective.
Environment
Excel
SAP Analysis for Microsoft Office
Reproducing the Issue
- Open Analysis for Office.
- Select the model PP_Modelo_de_datos_PL.
- Select input parameters from period 2023001 to 2025012.
- Select the fields 'field1' and 'field2' and place them on the lines.
- Apply a filter on the fiscal year field.
- Observe that several sources disappear.
Cause
The cause of this issue is XSUAA problems in the applications.
Resolution
See Also
Refer to: Analysis 2.x log / Trace Files
Refer to: Remote connections used by SAP to investigate issues in Analysis for Office
Refer to: How to Close a Support Case - SAP for Me
Refer to: Troubleshooting guide for the SAP Analytics Cloud, add-in for Microsoft Office
Keywords
unexpected filtering, analysis for office, PP_Modelo_de_datos_PL, fiscal year filter, data sources disappear, SAP Datasphere, Excel Addin , KBA , BI-RA-AO-XLA , Excel Addin , Problem
Product
SAP Analysis for Microsoft Office 2.8
SAP Knowledge Base Article - Public