3672416 - Calculated Column not populating as expected in Canvas report

A calculated column containing the IF and ELSE conditions utilizes more than one column. The end user is not permitted to see one or more columns utilized in this calculated column. The calculated column does not populate any data, if the result should be logically visible to the end user based on the IF and ELSE conditions defined in the calculated column.

• SAP SuccessFactors HCM Suite
  • Advanced Reporting (ODS)

1. Create a calculated column with the IF and ELSE conditions. Make sure it returns two columns utilized in the report as a result, at least one of which the end user is not permitted to see.
2. Run the report with the end user and witness that the calculated column does not return any data, even if the end user is permitted to see the result column based on the IF and ELSE conditions.

The calculated column first checks all necessary permissions required for all columns utilized in the calculation, and will not return data if the end user is not permitted to see one or more of these columns.

Grant the end user with the necessary permissions to view all columns utilized in the calculated column.

gender field missing, canvas report issue, advanced reporting, EC employee data, HR user access, data retrieval issue, report field empty, gender data missing, canvas report troubleshooting, advanced reporting query tool , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem