Cell Referencing becomes #REF! after current context is changed in EPM reports

[Former Member]

Hi Experts,

I am facing an issue with cell referencing while developing an Input form in EPM.

The requirement is to send both the input keyed in by the user in the input form and the modified input data simultaneously, when user clicks on 'Save Data'. For example if for a particular intersection of dimension members, user keys in say 100 in the input report, then along with this value I am also required to send -100(=-1*100) for a different intersection of dimension members.

To cater this requirement, I created an input form using EPM report editor where user will key in the data (100) and used EPMSavedata formula to save the modified input(-100) for different intersection. EPMSavedata formula had a reference to the cell in EPM report.

My problem is that when current context changes and the report is refreshed, EPMSaveData formula looses reference to the cell in input form and it becomes #REF!

I also tried using INDIRECT() in EPMSaveData as was suggested in SAP note 1685498 - EPM BPC 10: Cell Referencing becomes #REF! after current context or dimension is changed. But in this case as well, INDIRECT() loses the cell reference and becomes #REF!

Any help on the same would be appreciated

Thanks,

Rupali

[former_member186338]

Hi Rupali,

For this purpose it's better to use simple script in the default.lgf for this cube:

*WHEN ACCOUNT

*IS MEMBER_ENTERED_BY_USER

*REC(FACTOR=-1, ACCOUNT="SECOND_ACCOUNT")

*ENDWHEN

Formulas in Excel are not very reliable, script will do the job automatically.

B.R. Vadim