Create a Standard Variable

Add a standard variable to your analytic model.

Context

A standard variable is used in a fact source to map it to input parameters of the fact.

Procedure

  1. You are in the editor of your analytic model. You can create a new standard variable by clicking the background of the canvas and choosing Add Variable in the properties panel. Choose Standard Variable.
  2. Edit the following properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

    To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
  3. Define the properties of your standard variable:

    Property

    Description

    Data Type

    Select the data type.

    Variable filled by
    Choose how the variable should be filled:

    • Manual Input

    • Derive Value: Derived variables are hidden in the data preview or in an SAP Analytics Cloud story. See Derived Variables.

    • Dynamic Default: You get a derived value in the parameter dialog list when opening the analytic preview, and in the variable prompt for an SAP Analytics Cloud story. See Dynamic Default.

    Properties for derive value
    If you want to derive the value, you need to

    1. Define a lookup entity (a view).

    2. Select the column from which the value is to be derived.

    3. Map the parameter of the lookup entity. If it has no input parameter, you can set a constant value or create a standard variable.

    For more information, see Derived Variables.