2503415 - Pay Grade and Event Reason Icode from Compensation are greyed out in Advanced Reporting / REALMS

SAP Knowledge Base Article - Public

2503415 - Pay Grade and Event Reason Icode from Compensation are greyed out in Advanced Reporting / REALMS

Symptom

  • 'Pay Grade' and 'Event Reason Icode' fields from Compensation are grayed out in Advanced Reporting / REALMS. You can see the message "For data security reasons this field is not selectable".

pay grade.jpg ORD_Adv_Reporting_Auth_Error.jpg

  • Both fields are available if you select them from the Employment table.

event reason.jpgpay grade2.jpg

 

Environment

SAP SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Go to ORD and click on Advanced Reporting
  2. On 'What would you like to report on?' select the category Compensation
  3. Expand the table 'Compensation Information'
  4. Check that the fields 'Pay Grade' and 'Event Reason Icode' are grayed out
  5. If you move the mouse over the fields you will see the message "For data security reasons this field is not selectable".

Cause

  • By default, Advanced Reporting does not utilize the auto-join between the 'Compensation Information' and 'Event Reason' tables, instead, it uses the 'Event Reason' table from 'Foundation Objects' or from 'Employment'.
  • The Pay Grade is a mandatory field defined in the data model by default. The instance has it configured in the compensation info portlet, but the RBP permission is not checked.

Resolution

  • You can create a query in Advanced Reporting and select the table Employment or Foundation Objects instead of the Compensation.
  • If your instance has these fields configured in EC Compensation portlet, you have to check them in RBP permission > Employee Central Effective Dated Entities > Compensation Information:

compinfo_pay_event.png

  • The Target Population for the permission role may also restrict access, so it should also be checked.

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors Workforce Analytics all versions