Show TOC

SAPListOfVariablesLocate this document in the navigation structure

This function returns a list of all variables of a data source or planning object.

The formula consists of 3 parameters and is made up of the following arguments:
  • Data Source

    Enter the formula alias of the data source or planning object. You can set the alias when configuring the data source or planning object on the Components tab in the design panel.

    You have to define this parameter if the variables in the workbook are not merged. If the variables in the workbook are merged, you can define this parameter but you do not have to define it.

  • Member Display

    You can enter TEXT, KEY or INPUT_STRING to define how the filtered members should be displayed in the workbook. This parameter is optional. The current display selected for members is the default setting. If two options exist, the first one is applied.

  • Display
    Enter one of the following values:
    • ALL to display all variables (filled and unfilled) including variables not visible on the prompts dialog.
    • PROMPTS to display all variables (filled and unfilled) visible on the prompts dialog.
    • ALL_FILLED to display all filled variables including variables not visible on the prompts dialog.
    • PROMPTS_FILLED to display all filled variables visible on the prompts dialog.
    • PLAN_PARAMETER to display all variables (filled and unfilled) of a planning object.

    This parameter is optional. The default value is PROMPTS_FILLED.

Example

Cell F20: =SAPListOfVariables("DS_2";"TEXT")

If you enter the formula in cell F20, all BW variables with values in data source DS_2 are listed with their values in the worksheet. The first variable name is displayed in cell F20, the next in cell F21 and so on. The corresponding values are listed in G20, G21 and so on.