Start a new topic

EPM Add-In: Local Members Attached to Shared / Multiple Reports

Symptom:

When you create a local member across a shared report (Row Axis shared or Column Axis Shared), the local member formula's Excel cell references do not get updated / populated if the "Use Excel Cell References" option is checked off in the local member properties definition. (Note the local member is attached to the row axis if the row axis is shared or attached to the column axis if the column axis is shared).


EPMLocalMember.JPG



Reproducing the Issue:

- Create more than one EPM Add-in reports in the same Excel sheet and share the Row or Column axis
- Create a Local Member with the "Use Excel Cell References" checked off and reference cells in reports 1 and 2
- Only the local member formula cell referring to report 1 will be correctly calculated

OR

- Create more than one EPM Add-in reports in the same excel sheet and share the Row or Column axis
- Create a local member with the "Use - Excel Cell References" checked off
- Only the local member formula cell referring to report 1 will be correctly calculated

 

Cause:

Shared reports (row or column axis shared) do not support Local Member formulas based on cell references.



Resolution:

- Uncheck the "Use Excel Cell References" 

- Check the "Attached to Member" option with this type of formula:

=EPMMEMBER([P_ACCT].[PARENTH1].[ACCOUNT123]) - EPMMEMBER([P_ACCT].[PARENTH1].[ACCOUNT123])



EPMLocalMember3.JPG


 
Login or Signup to post a comment