SAP Knowledge Base Article - Public

2465780 - Variants are disabled when working with HANA data sources


When working with HANA data sources in Analysis for Office, the variant input is disabled with the message "This variant mode is not supported by the back end".

variant disabled.png


SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Try to save a variant (in Data Source mode) for a HANA data source in Analysis for Office;
  2. Confirm that the variant input is disabled.


It is not possible to save variant in Data source mode for HANA data sources. Variants in Data source mode are only supported for BW data sources.

There are two modes when working with variants:

  • Data source mode
  • Document mode

More information about these modes can be found in chapter "Using Variants" in the User Guide of Analysis Office.

Starting from Analysis Office 2.4 and BI platform 4.2 SP4, it is possible to save the variant in Document mode in BI platform for HANA and BW data sources. See all the prerequisites also in User Guide. 
If option "merge variables" is not selected in the workbook, see also note 2478227.

More information about all the possible functionalities when working with HANA data sources can be found in chapter "Analyzing SAP HANA data sources" in the same User Guide.

See Also

User Guide of Analysis for Office

2478227 - BIP Variant for unmerged document does not work with HANA data sources


variant, variants, not possible, unable, disabled, impossible, grey, greyed out, gray out, grayed out, saving, save, select, prompt, model, HANA , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions