SAP Knowledge Base Article - Public

2647075 - Planning object not using the variable value entered for the query


When changing the variable value of a query in Analysis Office, the variable value of the planning object included in the report is not changing, even if the variables are the same (i.e. same technical name).


SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Open a workbook in Analysis Office, that contains a query and a planning object (e.g. Planning Function or Planning Sequence) that use the same variable;
  2. Open the variable screen and change the variable value of the query;
  3. Check the variables of the planning object in Design Panel and confirm that it is not being changed.


The variables of the query are independent from the variables of planning objects. This is not a bug in the tool.


If the business requirement is that the planning object uses the same variable value as the query, it is possible to achieve this by using cell reference and not members reference in the variable of the planning object.

In order to do that, make use of the SAPListOfVariables described in the User Guide of AO available in Alternatively, click on "Info Field" > Variables, in the Insert group of Analysis ribbon.

With the variable values in the report, make sure that the planning object uses cell reference as "Source" for the variable as shown in the screenshot below:



Now, whenever the variable of the query is changed, the variable value used by the planning object will also be changed.


planning information, design panel, components, variable, input, prompts, prompt , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions