Skip to Content
avatar image
Former Member

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

~Dilkins

Company Code.png (47.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 09, 2015 at 04:12 PM

    Hi Andrew,

    I think what you're doing should work, but it does take a Refresh for the parameters in the Olap Member to change. Dimension Override unfortunately doesn't work with page axis.

    /Cecilia

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2015 at 02:59 PM

    Hello Andrew,

    Can you try through EPMDimensionoverride

    Regards

    Bhagyesh Ravange


    OVERRRIDE.PNG (25.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2015 at 03:02 PM

    Also is it that after refreshing again it is taking correct member? Means after changing the context you have to refresh again and then it is taking correct member.

    Add comment
    10|10000 characters needed characters exceeded