Start a new topic

EPM Add-In: Cell Referencing becomes #REF! after current context or dimension is changed

Symptom:

Cell Referencing becomes #REF! after current context or dimension  is changed.


Reproducing the Issue:

- Create a report with Entity on the rows and Time on the columns.
- Create Excel formula above the report. For example =EPMMemberDesc(C2).
- Edit the report to replace Time dimension with another dimension and refresh.
- The cell reference in the formula changes to #REF! i.e (=EPMMemberDesc(#REF!))


Cause:

After refreshing with a different context member or different dimension in column or row the report is written again and the cell reference is lost.


Resolution:

In order to have it working, user has to use the INDIRECT function:
for example =EPMMemberDesc(INDIRECT("C2"))

 


Login or Signup to post a comment