Variables are parameters of an SAP data source and serve as placeholders for members, currencies, hierarchies, formula elements, and texts. They often render as prompts in the SAP Analytics Cloud, add-in for Microsoft Excel when you insert a model based on such a data source. After providing the variable values, the table is displayed according to the selected values.
To change variable values, open the Prompt dialog from the ribbon.
You can insert multiple models in your workbook and even on the same worksheet. It is possible that each data source will have variables defined. Because of this possibility, the prompt icon has two options available in the drop-down: Prompts for Workbook and Prompts for Table. If you choose Prompts for Workbook, the prompt dialog will display all the prompts for all the data sources used in the workbook.
Working with Variables in the SAP Analytics Cloud, Add-in for Microsoft Excel
Watch this short demonstration to see an example of working with variables in the add-in.