SAP Knowledge Base Article - Public

2781374 - The table EmpCompensationGroupSumCalculatedQuery cannot be used in SAP Analytics Cloud (SAC)

Symptom

  • The table EmpCompensationGroupSumCalculatedQuery cannot be used in SAP Analytics Cloud (SAC).
  • When adding the table into SAC directly, it throws the error "[COE0018]EmpCompensationGroupSumCalculated can only be queried as Expand of EmpCompensation".
  • However it cannot be found in EmpCompensation as well.

Environment

  • SAP Analytics Cloud 2019.8.0

Reproducing the Issue

  1. Create a Connection to SAP SuccessFactors.
  2. Create a Model > Get data from a datasource > SAP SuccessFactors > Select Connection > Next Search for table EmpCompensationGroupSumCalculated (located in EC - Compensation Information) > Next Select Amount, userID.
  3. It returns an error that says "EmpCompensationGroupSumCalculatedQuery has failed to upload because of an error in the plugin service" and "The following error message comes from the external data service: status:400 body:{ "error" : { "code" : "COE_GENERAL_BAD_REQUEST", "message" : { "lang" : "en-US", "value" : "[COE0018]EmpCompensationGroupSumCalculated can only be queried as Expand of EmpCompensation" } } }" See note 2443143 on this error message.  
  4. When Expanding EmpCompensation however, EmpCompensationGroupSumCalculated cannot be found.

Cause

EmpCompensation and EmpCompensationGroupSumCalculated has a 1:n relationship so it is not supported by SAC for now.

Resolution

Please use the table EmpPayCompRecurring(Compensation) and the fields Amount, Annualization Factor, Pay Component and User ID to get the same data.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, SF , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0