SAP Knowledge Base Article - Public

3631165 - Unexpected filtering issue in analysis for office

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

  1. Open Analysis for Office.
  2. Select the model PP_Modelo_de_datos_PL.
  3. Select input parameters from period 2023001 to 2025012.
  4. Select the fields 'field1' and 'field2' and place them on the lines.
  5. Apply a filter on the fiscal year field.
  6. Observe that several sources disappear.

Cause

The cause of this issue is XSUAA problems in the applications.

Resolution

2783707 - XS Advanced: Troubleshooting Guide XSUAA

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

Refer to: How to access Customer Remote Logon Depot to maintain system logon credentials - SAP for Me | SAP Knowledge Base Article

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