SAP Knowledge Base Article - Public

3455498 - Filter in export data is not working as expected

Symptom

Filter in Model data exporting does not work as expected.

Export fails and data are not getting filtered. 

Filtering works for some values if Master data already exists

Environment

SAP ANALYTICS CLOUD

Reproducing the Issue

  1. Login to SAC Tenant
  2. Select Model
  3. Select: Data Management
  4. Create Export job (Click Export Data", create Export to SAP S/4HANA)
  5. Select the S4Hana Connection, click Next
  6. Select objects for Export
  7. Map the objects to the destination
  8. Add Filters
  9. Click NEXT
  10. Then Finish
  11. Wait and get an Error
  12. Download the CSV file
  13. Observe the records in the CSV file are not filtered as per the value selected in step 8.

Cause

The issue has been resolved by Development. The reason is that getLeafMembers return empty set. There is no problem with Parent-Child hierarchy.
To fix the issue, SQL to retrieve Leaf members has been modified to work for both Parent-Child and Level-Based hierarchy. 

Resolution

Resolved in SAC update

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions