2378505 - Planning buffer behavior when working with Analysis for Office workbook

The purpose of this Knowledge Base Article is to clarify the understanding of the system logic and requirements related to planning buffer engine when working with prompts.

In Analysis for Office, when you are working with a planning workbook and you have a prompt with variables, you may save initial set values for the second variable value. The buffering data is loaded with the initial value as well.

You are working with a workbook within a planning query that contains input-ready cells and the same query requests a variable value. As sample, we are using 0CALMONTH.

Variable: 0CALMONTH
Value: 04-April

Once you run the workbook the first time and set the input-ready cell to the value 10, you do not click to save the date, but you request the prompt to change the value. You add new variable value:

Variable: 0CALMONTH
Value: 08-August

For the month of August, you add a value 100 to another input-ready cell. Now you click to save the data.
It will send both values, 10 for April and 100 for August, to the planning buffer.

The described behavior is standard.

This behavior occurs because values entered in input-ready cells are implicitly written to the planning buffer at the next interaction with the software so your next interaction is launching the prompts.

As a solution, if you would like to prevent old values from being saved when explicitly saving the plan data, make use of the functionality called "Back - To Previous Saved State" (ribbon "Analysis", group "Planning") before entering the new values.

Analysis; Office; Planning; Buffer; Prompt; Save; Data; , KBA , BI-RA-AO-XLA , Excel Addin , How To