SAP Knowledge Base Article - Public

3562950 - Newly created picklist value cannot be displayed in story report

Symptom

  • Add a new picklist value A000 for field A, but cannot find it when adding members of field A in story report.
  • Other changes on the picklist values, such as rename member take effect in story.
  • The member A000 is not visible in query designer-preview, in widget or in filters' member selector of story. Cannot find A000 in har file either.
  • If use advanced filter/simple filter in query designer and use the member selector, we can see A000, and also find it in har file getresponse call.

    Environment

    • SAP SuccessFactors HCM Core
    • SAP SuccessFactors People Analytics
    • SAP Analytics Cloud (SAC) embedded version

    Reproducing the Issue

    1. In query designer, select field A.
    2. Preview the query, but not see A000 in the previewed list.
    3. Save the query and create a table in the story.
    4. Add A as column, but not see A000 in the table.

     

     

    Cause

    There is a time filter for the query, which set field B = Y. For member A000, the value of filed B = N.

    Resolution

    Change the time filter settings.

    See Also

    Keywords

    sf, people analytics, sac, esac, metadata, object, field, change, picklist , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-SF-ANA-SAC , Stories in People Analytics , Problem

    Product

    SAP Analytics Cloud 1.0 ; SAP SuccessFactors HCM Core 2411