Excluded Members - Dimension used in Page Axis

[Former Member]

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,

[former_member186338 · Accepted solution]

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

[former_member186338 · Accepted solution]

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