Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on 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 a 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.