on 01-08-2013 2:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
moved to Semantic Layer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.