Hi,

Lets say I have a company dimension , a product dimension (with a hierarchy
Group -> Subgroup -> Segment-> Product) and a sales measure containing
product sales.

How can I hide products from other companies? Say a user from company A
checks the product sales from a product segment's products. The user sees
only company A's products sales (product by product) and other companies
product sales are summed up in a product entry named in example 'Unknown
products'. And of course if the user only checks sales for a segment (not
it's products) all companies product sales are summed up.

Another problem is how to hide sales figures if a hierarchy contains less
than 5 products. In example if a segment contains 3 products, then no sales
figures are shown for the segment. The same applies to subgroups and whole
groups.

I'm not expecting any complete answers, just pointers on where to get more
information on how to solve the problems.