· 

Analysis for Office Workbook vs. DataSource Variants

Analysis for 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 for Office Save Variant
Analysis for 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 for Office Variant Settings
Analysis for 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 for Office Global Variant
Analysis for Office Global Variant

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

Analysis for Office Global vs. User Variant
Analysis for 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 for Office Select DataSource Variants
Analysis for 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 for Office Variant no longer available
Analysis for 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 for Office Variants needs SAP NetWeaver
Analysis for Office Variants needs SAP NetWeaver

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €

Write a comment

Comments: 0