Start a new topic

EPM Add-In: "Restore dynamic selection on refresh after navigation" and "Perform worksheet refresh on Expand/Collapse"

Symptom:

If the sheet options "Restore dynamic selection on refresh after navigation" and "Perform worksheet refresh on Expand/Collapse" are both checked, expanding a member does nothing.


Reproducing the Issue:

- Build an EPM report
- Open Sheet Options
- Tick both "Restore dynamic selection on refresh after navigation" and "Perform worksheet refresh on Expand/Collapse"
- Expand a member and notice that nothing happens.


Cause:

This is a normal behavior.


Resolution:

For example you have in row : 2005.TOTAL (member and children) : you have 2005.TOTAL + 2005.Q1 +2005.Q2 + 2005.Q3 + 2005.Q4 in row. You doucble click on 2005.Q1 to expand this member :

A refresh is launched with the option "perform worksheet refresh on Expand/Collapse"Consequently as a refresh is launched the dynamic selection is restored with the option "Restore dynamic selection on refresh after navigation"

So you get again 2005.TOTAL (member and children) for TIME in the selection, which means : 2005.TOTAL + 2005.Q1 +2005.Q2 + 2005.Q3 + 2005.Q4.

 
Login or Signup to post a comment