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

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