Excluding Members ?

[Former Member]

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

[former_member262009]

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

[Henry_Banks]

moved to Semantic Layer

[Former Member]

i am sorry i didnt got you.

Thanks

[Henry_Banks]

you posted in the wrong forum, i moved it to 'semantic layer'

regards,

H