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
- Create a Connection to SAP SuccessFactors.
- 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.
- 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.
- 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
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
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