SAP Knowledge Base Article - Public

3661399 - Variables selections are not saved in AO Workbook even when 'Store Prompts with Workbook' property is selected

Symptom

Variables selections are not saved in AO Workbook even when 'Store Prompts with Workbook' property is selected for the workbook.
In Bex query designer/BW modeling Tool, the variables are Processed by Manual Input/Default Value, variables' dimensions has set 'Refresh Behavior' as 'As Designed'.
Same issue can be reproduced in a RSRT bookmark.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. In AO, open the workbook.
  2. Input variables.
  3. Save the workbook, with workbook property 'Store Prompts with Workbook' selected.                                            
  4. Reopen the workbook, call Prompts. 
  5. Confirm some of the variables in step 2 are not saved successfully.

Cause

Program error

Resolution

Implement following Note in BW system with T-code SNOTE.
3368771 - Input value of space variable resetted

See Also

To select workbook properties for prompting

Keywords

Analysis Office, Analysis for Office, A4O, Analysis for Excel, A4O, variable values , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions