SAP Knowledge Base Article - Public

3359210 - Not possible to create Global Variants in Analysis for Office workbook


It is not possible to create a Global Variant. Variants can only be used by the user who created it.

In Prompt Screen, when an user create a variant and click on "Show Variant Settings" > "Edit Variant Setting" the type is fixed to "User" and it cannot be changed.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 


  • SAP Analysis for Microsoft Office
  • SAP BusinessObjects Business Intelligence platform


Reproducing the Issue

  1. Create an AO workbook and save it to BI Platform
  2. Create a new variant and save it
  3. Launch the workbook with a different user and click on variant settings
  4. The list does not contain Global Variants created by other user


In the Central Management Console, properties of the Analysis Office Runtime, the "Variants Support" is not set to "User and Global".


Change the properties of the Analysis Office Runtime "Variants Support" to User and Global:

  1. Open Central Management Console
  2. On the drop down list on the top left select "Applications"
  3. Right click on "Analysis for Office Runtime"
  4. On "Variants Support" make sure "User and Global" option is selected
  5. Reopen Workbook > Click on "Prompts" and confirm you choose type "User" or "Global"

See Also

2538975 - Using variants when scheduling Analysis workbook

2481435 - How to use variants in Analysis for Office

To create a Global Variant - AO Documentation


variants, variants, scheduling, schedule, prompts, prompt, variable, variables, workbook, document, not able
, KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions