3485414 - Current route step name (locale specific) does not aggregate in story report - Performance Management

Although "Current route step name (locale specific)" labels look the same, they do not aggregate in story report.

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

SAP SuccessFactors Performance Management

1. Create a story report with performance management domain.

2. Create a chart to aggregate "Current route step name (locale specific)".

3. In the below demo example, although these labels are the same "Rating Discussion", but they are not aggregated.

4. The issue does not occur if you use "Current route step name" column:

This is current expected behavior.

The "Current Route Step Name (locale specific)" has different ids to fetch localized label. So although their labels look the same, they will not aggregate like "Current Route Step Name".

Note: Logic of how the column "current route step name" retrieves value:

It retrieves the label of default language of the form template, whose default language is decided by the setting of company default language.

For example, the default language in provisioning > company setting > default language is set to English US, then the default language of form template will also be English US, so be default language of form route map. Then, when the column "current route step name" in story report is retrieving value, it retrieves the route map labels configured under English US.
If default language in provisioning is configured as Japanese, then the column "current route step name" retrieves route map labels configured under Japanese.

If you want to display localized labels in "current route step name" without changing default language of the instance in provisioning, say, a Japanese customer instance with English US as default language, please consider the following workarounds:

1. Change route map configuration.

First, navigate to "manage route maps" tool > open the route map > Configure the localized version (say, Japanese or Chinese) of step name under the language English US (which is the company default language of this example). Please refer to the attached demo image below:

Then, in the story report, when aggregating using "Current Route Step Name" (the one without locale specific), you will see the localized version of step name being aggregated, as shown in the attached demo image below:

2. You can also use IF function to replace the labels with localized version for the column "current route step name".

Nested IF Formula example to replace two English labels with Japanese version:

IF( [d/"route step data source":RD2_F75129C20D123DD77DEE2166F8629CD]='Self Assessment','自己評価' ,   IF( [d/"route step data source":RD2_F75129C20D123DD77DEE2166F8629CD]='Rating Discussion','評価討論' ,  [d/"route step data source":RD2_F75129C20D123DD77DEE2166F8629CD]) )

* Please do not copy paste the above code to your story calculation as the data source is different for different instances and configurations. Please contact your implementation partner to implement the calculations and test the effect.

Reference: Formula Functions in Calculated Columns for Stories in People Analytics

story report, Current Route Step Name (Locale Specific), Current Route Step Name, aggregate, count, dimension, measure, value, label, same label, report, localize, route step name, route step, form, performance , KBA , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-SAC , Stories in People Analytics , How To