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
- Login to SAC Tenant
- Select Model
- Select: Data Management
- Create Export job (Click Export Data", create Export to SAP S/4HANA)
- Select the S4Hana Connection, click Next
- Select objects for Export
- Map the objects to the destination
- Add Filters
- Click NEXT
- Then Finish
- Wait and get an Error
- Download the CSV file
- 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