SAP Knowledge Base Article - Public

2900751 - Use the BEx variants in AO

Symptom

You have created some variants in Bex. Now, you want to use AO run the queries and converted workbooks and use the BEx variants in AO.

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

Run queries and workbooks in AO.

Cause

This is a system design.

Resolution

There are two different types of variants - query variants and workbook variants in BEx. Note 1726090 contains more information about this. It is the same in AO, the variants can be called in DATA SOURCE MODE and DOCUMENT MODE. Note 2481435 contains more information about this.

  1. For query variants created in BEx, they can be used directly in AO in DATA SOURCE MODE.
  2. For workbook variants created in BEx, they can not be used in AO, and no way to convert them to AO's variants. Please create AO workbook variants manually after save the workbooks.

Keywords

A4O, Analysis for Excel, convert, variant, Bex analyzer, RSRPARAMETRIZA , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WB-7X , 7.x Analyzer Frontend , How To

Product

SAP Analysis for Microsoft Office 2.8