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

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