SAP Knowledge Base Article - Public

2979389 - How to enter the variable values when scheduling Analysis Workbooks in BI platform


This document describes the syntax and how to enter the variable values in prompts when scheduling Analysis Workbooks in BI platform.


SAP BusinessObjects Analysis, edition for Microsoft Office


It is possible to enter variables values when scheduling Analysis workbooks. Below is the screenshot of the prompt in BI platform:


When scheduling Analysis Workbooks with variables, it is important to enter the values correctly. The following consequences may occur when these fields are not filled correctly:

  • The workbook will not be scheduled and it will fail (e.g. there are mandatory variables in prompt);
  • The workbook will be scheduled but contain unexpected results (e.g. it will not use the value entered).

In order to fill the fields correctly, the values must be entered according to the following:

Data Source Alias of the Data Source

Technical name of the variable

Value Value of the member to be filtered

The alias of the data source must be the same as shown in workbook. This information can be found in the Display Panel, as shown on the screenshot below:


Make sure to enter the values according to the User Guide, chapter "Syntax for Entering Values". Click here to see the documentation.

When entering date interval, it is necessary to use spaces between the dates, otherwise the value is considered as Single member.
CORRECT: "01.10.2020 - 30.10.2020"
INCORRECT: "01.10.2020-30.10.2020"

Also refer to SAP note 2845593 for the correct syntax when entering the variable values in prompts.

See Also

2134836 - Checklist for Scheduling of Analysis for Office Workbooks
3430513 - Dynamic variable values when scheduling Analysis Office workbooks in BI Platform


variable screen, variables, prompts, var, dialog, rules, syntax, schedule, scheduling , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions