This function returns a list of all variables of a data source or planning object.
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.
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.
This parameter is optional. The default value is PROMPTS_FILLED.
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.