Skip to Content
avatar image
Former Member

Excluding Members ?

Hi All,

i am stuck with a problem.

1.     A new table is added in my universe which is named as exclusion table.

2.     i have a report which is also using a derived table. This report is not related to the above table.

Now what i have to perform is exclude all Members from the report which are equal to the Members in the exclusion table.

any idea how to do this ?

Thank You

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 08, 2013 at 02:19 PM

    moved to Semantic Layer

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2013 at 09:53 AM

    Hi Malik,

    1. Create a dimension object from the exclusion table (say ExcludeMembers).

    2. Create a filter for derived table class. Like.. derived_table.Members NOT IN exclusion_table.ExcludeMembers

    3. You can make this filter mandatory for the class OR you can include this filter in your report.

    Thanks

    -Nanda

    Add comment
    10|10000 characters needed characters exceeded