2089661 - Ratings: Rating Scales - Normalized Ratings used in List Views, Dashboards and Succession Org Chart - Reporting and Analytics

SAP Knowledge Base Article - Public

2089661 - Ratings: Rating Scales - Normalized Ratings used in List Views, Dashboards and Succession Org Chart - Reporting and Analytics

Symptom

  • What are normalized ratings and how do we use them?

Environment

  • Reporting and Analytics

Cause

  • You are using more than 1 rating scale that have different ranges (like 1-5 and 0-3) on the forms that are being displayed in the dashboard.
     
  • To view normalized ratings in Reports > List Views,

    1. Select the list view report you want to view
    2. Expand the Display Options so you can see the available Normalized Rating options
    3. Check the options you want to display.
     
  • The report columns will automatically update without the need to click any buttons.
     
  • The dashboard process must be set up with one scale.

    1. Admin Tools > Dashboards/Reports
    2. Select your dashboard
    3. Expand Rating Scale Settings and select your scale
     
  • The scale that is set up with the process will can only be a single scale. Therefore, if your forms are using any scale other than the one you have set for the dashboard, the other scale will be 'normalized' or adjusted to the 1 scale being used in reports. 
     
  • In Dashboards there are choices for the rounded and unrounded scores. The values here would be different if the form was rounding (XML set up in the meta section). If a 3.75 was rounded to a 4, then the rounded score would be shown after it was normalized against the scale or record.

    Considering the above, we recommend you do not use multiple scales and always use 1 standard scale throughout your processes whenever possible.
     

Succession Org Chart

  • Performance ratings in a Succession Org Chart are also normalized against the Performance Rating Scale set in admin tools > Matrix Grid Rating Scales > Performance.
     
  • If this rating scale is different to the values stored in Trend Data file then they are normalized.
     
     

Normalized Ratings

  • User-entered and calculated ratings from sources like annual reviews can use other rating scales. All ratings get normalized-plotted on a percentage scale from 0 to 100-and then converted to the appropriate system rating scales for output on the matrix grids. Here's what the process looks like if form-calculated ratings use a 1-to-5 scale but the matrix report uses a 1-to-3 scale:

 

  • From the original 5 point scale, the system stores the normalized rating, equally distributing the rating scale from 0% to 100%:

Original rating

Normalized (%) rating

1

0

2

0.25

3

0.50

4

0.75

5

1

 

  • Taking any normalized rating and showing it on a 3 point scale would use this conversion, dividing the range into 3 equal partitions:

Normalized rating range

Output rating

0.0 - .3333

1

.3334 - .6666

2

.6667 - 1.0

3

 

  • So, the original scores from the form translate into the 3 point scale like so:

Original rating

Normalized (%) rating

Output rating

1

0

1

2

0.25

1

3

0.50

2

4

0.75

3

5

1

3

 

Example:

  • There are two forms, one with a 0-5 scale, and one with a 1-5 scale. The process which includes both of these forms is using a 1-5 scale. As a result, this normalized all of the scores from the 0-5 form like this:

    0-5 scale… normalized to … on the 1 to 5 scale.

    0 --------------------------------------- 1

    1 --------------------------------------- 1.8

    2 --------------------------------------- 2.6

    3 --------------------------------------- 3.4

    4 --------------------------------------- 4.2

    5 --------------------------------------- 5

 

  • Note: Use the normalization calculator attached to view expected outcomes based on values input into rating scales.

Resolution

     Normalized Ratings are the result when for any reason two or more scales are part of the calcuated result. This can happen for many reasons for example

  • You have one scale for goals but another for competencies
  • Or two or more scales within a performance form
  • Or reporting on different templates that use different scales
  • Or running a report where the report scale differs to any scale used within any of the forms being reported on.

 

  • The ratings from ALL sources will be considered, and when any are different Normalization takes place automatically within the system. All ratings get normalized-plotted on a percentage scale from 0 to 100-and then converted to the appropriate system rating scales for output.
     
  • You CANNOT disable normalization if different scales exist, but some reports do have options to report on calculated values as well as normalized values so you can see both.

          For compensation you can prevent the normalized rating from PM from being used. See this article:

 

  • One of the choices available in "Display Options" in List Views is to show Normalized Ratings. Available options include; Normalized Rating (Rounded), Normalized Goal Rating, and Normalized Competency Rating. Attached to this case is a Normalization Calculator that you may download to test normalization against 2 rating scales.

Keywords

KBA , LOD-SF-ANA-DSH , Dashboard and YouCalc , How To

Product

SAP SuccessFactors HCM Core all versions

Attachments

NormalizationCalculator.xls