Analysis Office Workbook vs. DataSource Variants

Analysis Office has different two kinds of variants. One is a workbook variant and the other is a DataSource variant. So what is exactly the difference?

 

If you have a workbook you can save your variants in the prompt dialog.

Analysis Office Save Variant
Analysis Office Save Variant

Enter your required values, a description for the variant and click the save button. This is now a user variant and only for your user available. When you want to use your variant as a global variant, you have to change the variant settings. In the variant settings you can also edit and delete a variant.

Analysis Office Variant Settings
Analysis Office Variant Settings

If you now change your user variant to a global variant, you have to choose a technical name and confirm the change.

Analysis Office Global Variant
Analysis Office Global Variant

In the prompt dialog you see at first the user variants and underneath the global variants.

Analysis Office Global vs. User Variant
Analysis Office Global vs. User Variant

If you have only one DataSource in a workbook you can also access the DataSource variant. To access the DataSource variants, you have to change the Ao_app.config and add the parameter <ShowDSVariantsForWorkbookWithOneDS>

 

If you set this parameter to true you can save variants or select a saved variant for this DataSource.

Analysis Office Select DataSource Variants
Analysis Office Select DataSource Variants

When you insert the DataSource into a new workbook you can select the variant, but if you add more than one DataSource to the workbook the DataSource variant is not any longer available.

Analysis Office Variant no longer available
Analysis Office Variant no longer available

The parameter ShowDSVariantsForWorkbookWithOneDS is nice if you use only one DataSource in a workbook and you want to use predefined variants.

 

Note: Workbook variants are only available, if you save the workbook on a NetWeaver. If you have only a local workbook, you can't use variants.

Analysis Office Variants needs SAP NetWeaver
Analysis Office Variants needs SAP NetWeaver
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0