Issues with undo functionality in bpc10.1

[Former Member]

Hi Experts,

I use cell refrences in the Olapmmember formula of the pageaxis members so that I can update based on user selection.for example this is how I used the formula   = EPMOlapMemberO($A$19,"[PARTNER].[PARENTH1].[ALL_PARTNER]","All Partners","","000"). Here I have partner dimension as page axis member and I am refering to cell A19 to get the latest value for partner. While the user is navigating in the report and hit undo on the epm ribbon to go back to previous screen, the cell refrence to A19 is wiped out and the formula changes to = EPMOlapMemberO("[PARTNER].[PARENTH1].[ALL_PARTNER]","","All Partners","","000").

How to restore the cell references in the epmolapmember formulas.This happens only if we hit undo. I tried to check both  sheet options  "Keep formulas on data" and  "keep formulas static that reference report cells" but didn't work.

Any help is appreciated.

Best Regards,

Saila

[former_member186338]

Yes, it's a bug with "Back" button in EPM ribbon! Same effect in SP24... Contact SAP.

Vadim

[Former Member]

Hi Sailu,

Which EPM add in version are you using?

Try the latest version if you can.

SP 24 patch 1.

Andy

[Former Member]

Andy, thanks for getting back.

I am using SP19 patch 1. Will try to get the new version and check. Has anyone got this issue before and resolved it with latest client SP.

Best Regards,

Sailaja