2794368 - Historical Matrix Grid Placement Portlet (Mini 9-box) showing blank end date for rating

Symptom

The Historical Matrix Grid Placement Portlet (Mini 9-box) is showing a blank/empty end date for the users' last rating in Employee Profile.

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 SuccessFactors Succession Management
SAP SuccessFactors Employee Profile

Reproducing the Issue

Go to Employee Profile > Search for the Historical Matrix Grid Placement Portlet;
The current rating is showing for users (with a mini 9-box representation) with blank/empty value for the end date:

Cause

The start and end date for each record calculated for the Matrix Grid Placement History portlet are the placement effective dates and, therefore, they are not the same as the rating dates.

Resolution

The start date of the Placement record is equal to the end date of the latest rating that makes up this placement. The end date of the Placement record is equal to the start date of the next placement record, as one placement is effective until a new placement takes place, or blank if the given placement record is the latest placement record.

Therefore, if you have the following ratings:

Rating Type	Start Date	End Date	Rating
Performance	01/01/2016	31/12/2016	3 - High
Potential	01/01/2016	31/12/2016	2 - Solid

You will have the following placement record:

Start Date	End Date	Placement Label
31/12/2016		Top Performer

Based on the rule mentioned above, we determine the effectiveness for a given period of time by the "End Date" of a rating. Suppose we have a performance rating with End Date 31/12/2012 and a potential rating with End Date 31/06/2013. To make both of the ratings effective (so that the matrix placement can be calculated), the placement's start date should be after the bigger date (31/06/2013). Following this logic, we get the start date of this historical matrix placement boundary. The placement's end date, in its turn, will be the next placement's start date, as the placement is effective until a new placement is calculated.

The last historical matrix placement is the most recent placement. Therefore, the end date for this record is empty, which means that the Matrix Grid Placement is still effective to this date.

Keywords

mini 9 box, matrix grid, historical matrix grid placement, matrix grid placement, matrix grid placement history, matrix1placement, matrix2placement, 9-box, nine box, portlet, EP, SCM, MXG , KBA , LOD-SF-SCM-MXG , Matrix Grid Reports (9 Box) , How To

Product

SAP SuccessFactors Succession & Development all versions