Symptom
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".
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Try to save a variant (in Data Source mode) for a HANA data source in Analysis for Office;
- Confirm that the variant input is disabled.
Resolution
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
Keywords
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