Skip to Content

Filtering OLAP members post applying Dimension override

Hi All,

I am looking for a functionality or a logic that will help me to display Cost Center (Member and Base Level) along with Category (To be planned) and Time (Member and Base Level) on Column axis, whilst having filtration on Cost Center.

The template is split in two reports where in the first report has Context selection (previous year planned & actuals) provides Time and overridden accordingly in the second report.

This is somewhat I am trying achieve, Please advise.. :)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 21, 2017 at 11:46 AM

    Hi Ishan,

    You need all those 3 dimensions in the column axis (Time, Category, and CC). In the edit report, select the CC and select the member and base level of context. On the selection section of the template, use EPMContextMember function to change the context of the CC dimension. Whenever you double click on this funtion to change the CC, refresh the report, and your template will get updated with the base of the selected CC.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 21, 2017 at 09:51 AM

    Hi Vadim, I am trying to achieve below. Filtration based on Cost Center property

    Add comment
    10|10000 characters needed characters exceeded