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:

NOTE:
----------------------------------
When entering date interval, it is necessary to use spaces between the dates, otherwise the value is considered as Single member.
E.g.
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.

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