Pageaxis Override usage
Environment: EPM10 NW SP15
I need company code to be derived from cost center user selection in my report. I created pageaxis override cell with excel cell reference to another cell where i construct the value based on cost center selection.
Expected Behavior: When user makes a cost center selection (EPMCONTEXTMEMBER cell) , COMPANY CODE page axis override reference cell ( in attached screen it is B10) will automatically reflect the new Company Code Hence report use the new value during expansion.
Observed Behavior: Even after the new cost center selection is made, page axis over ride is still using the old value
Query: What am i doing wrong. How to achieve the dynamic page axis over ride based on user selection of a different dimension member.
Attaching a sample case for clarity. Appreciate suggestions.
Section 1 in attachment shows when the report is built
Section 2 in attachment shows when a different cost center selection is made