SAP Knowledge Base Article - Public

3115460 - Category column shows no data in Story Report


When customer try to create a Story Report and add Category field it shows no data.


SAP SuccessFactors Career Development Plan

Reproducing the Issue

1. Login and go to Reporting
2. In Report Center click New > Story
3. Select the Development Objectives schema - either add the Development Objectives table from All CDP  templates or from the template (Select your specific template). Issue happens whichever the selection is.
4. Select any field from the first table
5. Add a join to Primary Objective fields
6. Select or add the Category field, and any other field
7. Preview the query
Result: Category column shows no data
8. Go back to the query and add a simple filter on Category field.  Select any of the available values
9. Preview the query again
Result:  Even if there are rows returned, the Category field still shows no data.


Field "category" is not configured in the template.


For SAC report, field "category" is a special field, because most company uses it as "enum" field and provide enum values as well. To support internationalization, we apply table function to this field to translate value to label under user logon locale. However, if field "category" is not configured, table function can't get enum value and label, so the translation can't work, and blank data shows then. 

In summary, if you want to see "category" label in SAC front-end, "enum" field "category" configured in template is required. This is the current system limitation.

For example:

<field-definition id="category" type="enum" required="true" detail="false" viewdefault="on" showlabel="false" default-calc-type="step" field-show-coaching-advisor="false" cascade-update="push-down">
<field-label lang="es_ES">Estado</field-label>
<enum-value value="On Track" style="background:#FFA500;color:#000000">
<enum-label>In Progress</enum-label>
<enum-label lang="de_DE">Auf dem Weg</enum-label>
<enum-label lang="es_ES">En curso</enum-label>
<enum-label lang="es_MX">En curso</enum-label>
<enum-label lang="fr_FR">En cours</enum-label>
<enum-label lang="pl_PL">W trakcie</enum-label>
<enum-label lang="pt_BR">Em Andamento</enum-label>
<enum-label lang="sk_SK">Prebieha</enum-label>
<enum-label lang="zh_CN">进行中</enum-label>


Category does not show data on Stories report. , KBA , LOD-SF-CDP-REP , Analytics & Reporting , Problem


SAP SuccessFactors HXM Core 2105