I have a User who should have access to the following data:

Dimension Customer Group:
All Customers in Customer Group A

Dimension Products:
All Products X

When i create a Cube Role with Restricted Access Customer Group=A and
Product=X the result will show "all A-Customers who ordered the Product X".

The Result i want to see is (logial expressed): Customers A OR Product X

Mathematical: Not the Intersection, i want to see the aggregate.

Hi

With the role you have defined, you restrict the cube to the tuple
([Customer Group].[All Groups].[Group A], [Product].[All Products X])

It is behaviour of Analysis services by design.

With easy dimensions restriction you couldn't get your desired result.

Thanks,
Vladimir Chtepa



"Urs Troesch" <UrsTroesch (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:36E1046E-B3B1-4715-817E-A6FBF2772F84 (AT) microsoft (DOT) com...