Skip to Content
avatar image
Former Member

Excluded Members - Dimension used in Page Axis

Hi,

I have a EPM 10 report which has the following setup:

Page Axis: Entity: Selection -> Entity A

Columns: Static -> Category, Month, Measure

Rows: Accounts

Entity A has the hierarchy:

Entity A

     Entity AB

     Entity AC

     Entity AD

If edit the report and try to exclude a member via the "Excluded Members tab" e.g. Entity AB is set to exclude. It does not exclude the member. Any ideas why this is not working?

Cheers,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 29, 2014 at 06:18 PM

    Hi Leo,

    You can use exclude member for column or row axis only. The Parent in Page member will not change it's value!

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • Solutions:

      1. Create second hierarchy with

      Anew (parent in the additional hierarchy)

      AC

      AD

      2.Create a member with dimension member formula:

      Anew (root base)

      =[ENTITY].[AC]+[ENTITY].[AD]

      3. Use multiple member selection for page axis and select AC and AD - the report will show sum of AC and AD.

      Vadim