SAP Knowledge Base Article - Public

2241116 - Unable to save variants in Analysis for Office


When trying to save or create a variant in Analysis for Office, there is a message saying that the variant was saved/created but actually it was not saved.
This is also generating the dump below in ST22 transaction:

Category               ABAP Programming Error
Runtime Errors         RAISE_EXCEPTION
ABAP Program           CL_RSR_PARA===================CP
Application Component  BW-BEX-ET


SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Run query in Analysis for Office
  2. Enter the variable values in prompt
  3. Try to save a variant of the variable values
  4. There is a message saying that the variant has been saved... but actually the variant is not saved.

Check the transaction ST22 and confirm that there is a dump generated when trying to save the variant in Analysis for Office.


The issue may be related to a conflict in the table RSPERSHEAD which is causing the problem when saving Variants in Analysis for Office.


In transaction RS_PERS_ACTIVATE, deactivate and then activate the "Variables Personalization" again.


Business Warehouse, BW, Analysis Office, Analysis, Office, Excel, AO, Variant, Variants, personalization, create variant, RSPERSHEAD, RS_PERS_ACTIVATE , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions