SAP Knowledge Base Article - Public

3774641 - SAC variable prompt clipboard does not handle leading zeros automatically in SAP Analytics Cloud story

Symptom

  • SAC variable prompt clipboard does not handle leading zeros automatically.
  • When setting a value for variable in the clipoard, the zeroes are not filled automatically and the following warning is displayed "Some values could not be found and were not applied to the variable."

Environment

  • SAP Analytics Cloud.
  • SAP BW.

Reproducing the Issue

    1. Login to SAC.
    2. Open a story based on live BW data model.
    3. The variable prompt is displayed. For a variable click on the clipboard and enter a number value.
    4. Click on OK.
    5. Notice that the value is not filled automatically with missing zeroes and the following warning is displayed "Some values could not be found and were not applied to the variable.", as if the value does not exist.

    Cause

    This is a by design behavior.

    Resolution

    This is actually a by design behavior.

    The clipboard works as an exact match. Its goal is to set values when users know the exact IDs to efficiently validate large lists without performing costly backend searches for each value.

    Keywords

    clipboard, variable, value, number, bw, live , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

    Product

    SAP Analytics Cloud 1.0