3483321 - "Key column(s) not selected in input [1402]" with the Data Export Service API FactData in SAP Analytics Cloud (SAC)

The Data Export Service (DES) API is used to export data from SAC to a different system. When only some columns are selected in the $select parameter, the error "Key column(s) not selected in input [1402]" is returned.

For example, the DES API is used to export data from SAC to BW via DTP. In the transformation, only some columns from the SAC source model are mapped so the URL called in the runtime only contains some of the columns of the SAC source model. In this case, you may see the following error in the BW system when you run the DTP:

• internal error: search table error: internal error: Remote execution error Error occurred when reading data from entitySet ...
  /FactData]: org.apache.olingo.client.api.communication.ODataCl ientErrorException: {"error":{"code":"XXXX
  XX":"Key column(s) not selected in input [1402]"}}null [HTTP/1.1 400 Bad Request] for query "SELECT XXXXXXXXXXXXX FROM "/sac/xxxxxxxx/FactData"
  Exception CX_RSDHA_MSG logged
  Exception CX_RSDHA_MSG logged
  Roll back executed for data package 000001

SAP Analytics Cloud (Enterprise)

Due to a technical requirement, all key columns (i.e. all dimensions, including version) need to be selected when using the $select query parameter in the FactData DES API.

Please make sure all key columns (i.e. all dimensions, including version) are selected when using the $select query parameter in the FactData DES API.
For exporting to the BW system, a workaround is described in the BW KBA 3474118 - The source side requires fields that are not mapped in the transformation rule.

• SAP Analytics Cloud REST API Help Portal
• Business Accelerator Hub -> Data Export Service

400 Bad Request, data transfer process, remote hana source, 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, dashboard , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem