SAP Knowledge Base Article - Public

2686340 - How to create calculated column for "Annualized Salary" field in Advance Reporting (Realms)

Symptom

  • How to report on Annualized Salary field's data in Advance Reporting?
  • The Annualized Salary does not fetch the correct data in Ad Hoc (Report Table) and Detailed Reporting (Report Canvas) reports.
  • Is it possible to report on Annualized Salary field's data in Advance Reporting (Realms)?

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP SucessFactors Workforce Analytics
  • Advance Reporting (Realms)

Cause

  • Annualized Salary field calculates the data in UI in Employee Central in Compensation Information Portlet.
  • Data of Calculated (transient) fields are not stored in the database. 
  • They are calculated on the fly and displayed in the user interface.
  • Therefore, these fields are not available for reporting directly in Ad hoc, Detail Reporting/ Live Data/ Advance Reporting. 
  • As a workaround we can create calculated column in Advance Reporting(Realms).

Resolution

Step1: Understanding the Pay Component Code for each Pay Component Label:

  1. Go To Advance Reporting > Select Compensation > Compensation 
  2. Select Pay Component and Pay Component(Name) field
  3. Export the Data into Excel.

1_Fetching Pay Component Code.png

Step 2: Remove Duplicates from Excel File

  1. Open the Excel file
  2. Select both the columns 
  3. Click on Data > Remove Duplicates

NOTE - Now, we have a unique list of Pay Component Codes because we need these codes to apply filter in the object level while creating the original query.

2_Remove Duplicates in Excel.png

Step 3: Now Creating Original Query

  1. Advance Reporting > Employment > Global Job Information > Select "User Sys ID" field
  2. Expand Global Job Information table on the right-hand Panel > Compensation > Compensation > Select "Pay Component (Name)" and "Amount" fields

3_Adding Fisrt Comp Table.png

Step 4: Applying Filter on 1st Compensation Table

  1. Click on "Edit Table" (small blue color square icon) of Compensation Table > Click on Filter Icon > Select "Pay Component" > Select from Available Values > Refer the previous Excel > Select the Pay Component Code > Ok
  2. Example: As per the screenshot, I have filtered on Code 1 which indicates to "Base Salary" pay component.

4_Applying Filter on First Table.png5_Filter on Pay Comonent Code.png

Step 5: Rename the Fields in 1st Compensation Table

  1. Click on "Edit Table" (small blue color square icon) of Compensation Table > Next to the field "Pay Component (Name)" there is button called "A" > This button Indicates as "Set Column Override Name) > Click on this and Rename the Field as "Base Salary"
  2. Example: Similar way I have renamed the Amount field in this 1st Compensation Table as "Base Salary Amount"

6_Renaming the Field.png

Step 6: Duplicating Compensation Table

  1. Click on "Edit Table" (small blue color square icon) of Pay Component Table > At the Top there is "+" button > This Indicates to Duplicate the Table > Click on the "+" button
  2. It will add another Compensation Table which will appear as "Compensation 2"

9_Duplicate Table.png

Step 7:Applying Filter on 2nd Compensation Table

  1. Click on "Edit Table" (small blue color square icon) of "Compensation 2" Table > Click on Filter Icon > Select "Pay Component" > Select from Available Values > Refer the previous Excel > Select the Pay Component Code > Ok 
  2. Example: As per the screenshot, I have filtered on Code 41 which indicates to Monthly Car pay component.

Step 8: Rename the Fields in 2nd Pay Component Table

  1. Click on "Edit Table" (small blue color square icon) of "Compensation 2" Table > Next to the field "Pay Component (Name)" there is button called "A" > This button Indicates as "Set Column Override Name) > Click on this and Rename the Field as "Monthly Car Allowance"
  2. Example: Similar way I have renamed the Amount field in this 2nd Compensation Table as "Monthly Car Allowance Amount"

Step 9: Add Multiple Compensation Table:

  1. In this way, we can add multiple Compensation table and apply filter on Pay Component Codes according to business requirement.
  2. Example: As per screenshot, I have added another Compensation Table and filtered on Bonus Pay Component Code.

13_Multiple Comp Table Added.png

Step 10: Creating Calculated Column:

  1. Click on Calculated Column Icon in Advance Reporting > Click on "+"
  2. Provide a Name to the Calculated Column
  3. Data Type must be selected as "Number"
  4. There are three different bullets. We will Consider Number Bullet because we are calculating the Addition operation on Amount Value which will return a Numeric value. Under Number bullets:
    • Expand the 1st Compensation Table > Drag the "Base Salary Amount" field in the right-hand panel under Values 
    • Then click on the Addition Icon "+"
    • Expand the 2nd Compensation Table > Drag the "Monthly Car Allowance Amount" field in the right-hand panel under Values 
    • Then click on the Addition Icon "+"
    • Expand the 3rd Compensation Table > Drag the "Bonus Amount" field in the right-hand panel under Values 
    • Click on OK > Click on Done
    • Save the Query 
    • Click on Return
    • Calculated column will display the value of Annualized Salary field which appears in Compensation Portlet in Employee Central

17_Data in Report.png

Keywords

Annualized Salary, Compensation, Calculated Column, Advance Reporting, Report, Realms, Reporting, Transient , KBA , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors Workforce Analytics all versions