I have quite a bit of a challenge. We run a report of 8000 customers in
the sales cube and we want to exclude the list of about 400 customers
from this list.

I am not sure how to exclude these 400 customers it is painful choosing
each of them and excluding them in the pivot report is there a smart
way of doing this.

Thanks
Karen

you want to exclude these customers based on which criteria?
does it always the same customers?
does it for the entire cube or only in a report?
does this list is different from 1 user to another? (dynamic security)

You can add a member property in the customers dimnsion which contain a 0 /
1 value and use thios property as a virtual dimension. In 1 click you filter
the customers.

or you can apply some security in the cube
or you can simply filter the fact table and don't load anything about these
customers.


<karenmiddleol (AT) yahoo (DOT) com> wrote

Hi Jeje

Please see my answers:

you want to exclude these customers based on which criteria?
- Just not equal to the set of customer #

does it always the same customers?
- Sometimes the list of customers might change not frequent

does it for the entire cube or only in a report?
- only for a few reports
does this list is different from 1 user to another? (dynamic security)
- this list if same for all users

You can add a member property in the customers dimnsion which contain a
0 /
1 value and use thios property as a virtual dimension. In 1 click you
filter
the customers.
exclude them in the report

Thanks
Karen

a virtual dimension based on a property can change at anytime with a simple
incremental update of the customer dimension
so you can replace the "0/1" value by a "Important cusomers/Non important
customers" or anything like this.
the end user can then view all customers or only the selected group.

if this filter must be always then just disallow "all members" for this
virtual dimension and setup the default member for the dimension to the
targeted value.

also you can inforce this by applying a security in the cube to insure that
the user can't change and can't see the dimension.


<karenmiddleol (AT) yahoo (DOT) com> wrote