SAP Knowledge Base Article - Public

2771912 - "Store Prompts with Workbook" is unchecked but previous variable values are used

Symptom

The setting "Store Prompts with Workbook" is unchecked in the Components tab of Analysis Office Design Panel.

When opening the workbook, the variable screen will show the previous variable values used to run the report.

Environment

SAP Analysis for Microsoft Office

Cause

This is not a bug but the intended behavior, if the refresh behavior of the variable is set to "Refresh Dynamically" in the query definition.

Resolution

Check the refresh behavior of the variable in the query definition, in Query Designer/Modelling Tools.

If the refresh behavior is set to "Dynamically", the setting "Store Prompts with Workbook" will not be used in Analysis Office. Instead, the values from the persisted state of the workbook will be used.

In case it is required to use the setting "Store Prompts with Workbook" unchecked so the default variables of the query are used, it is necessary to change the refresh behavior of the variables to "As Designed".

This is also explained in chapter "To select workbook properties for prompting" in the User Guide of Analysis Office.

See Also

1852783 - Processing of Variables on Refresh

Keywords

not selected, unchecked, store prompts with workbook, variables, mandatory, stored, prompt, unselected, variable screen, save prompts, save prompts value, Unintended value, Unintended prompts value, initial value, specified, entered, blank , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-OLAP-VAR , Using Variables , Problem

Product

SAP Analysis for Microsoft Office all versions