3345623 - Data export service API MasterData does not work with the parent member in SAP Analytics Cloud for Planning (SAC)

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

• The Data Export Service (DES) API endpoint /providers/{NamespaceID}/{ProviderID}/MasterData works if you set a base member in $filter.
• It does not work if you set a parent base member in $filter. Zero entity is returned.
• You expect the master data of this parent member and all its children to be returned.

• SAP Analytics Cloud (Enterprise) 2023 and higher

1. Call the Data Export Service (DES) API endpoint /providers/{NamespaceID}/{ProviderID}/MasterData with a parent member in $filter, for example: https://your-sac-tenant-url.cloud/api/v1/dataexport/providers/sac/QWERTY123456/MasterData?$filter=SAP_CEP_SALES_ORG___ID%20eq%20%27TOTAL%27&pagesize=10.
2. 0 entity is returned.
3. Call the Data Export Service (DES) API endpoint /providers/{NamespaceID}/{ProviderID}/MasterData with a parent member in $filter, for example: https://your-sac-tenant-url.cloud/api/v1/dataexport/providers/sac/QWERTY123456/MasterData?$filter=SAP_CEP_SALES_ORG___ID%20eq%20%27BASE1%27&pagesize=10.
4. the master data is returned as expected.

This the current design.

The data export service does not support hierarchies for masterdata, or filtering based upon them.

This the current design.

If you want this feature, please vote for enhancement request: Filtering parent members in Data Export API.

• api/v1/dataexport | SAP Help Portal
• Data Export Service API Reference

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, hierarchy loading , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem