Database Reference
In-Depth Information
Let's now take a look at Read Contingent permissions, and see how they are different
from Read permissions. If we want our users to be able to see the Sales Amount for
all Countries but Total Product Cost only for Canada, we could use the following
expression in the
Enable read permissions
MDX box:
[Measures].CurrentMember IS [Measures].[Sales Amount]
OR (
[Measures].CurrentMember IS [Measures].[Total Product Cost]
AND
[Sales Territory].[Sales Territory Country].CurrentMember
IS [Sales Territory].[Sales Territory Country].&[Canada]
) OR
[Measures].CurrentMember IS [Measures].[Gross Profit]
Notice that we added the
Gross Profit,
measure too, since we want our users to
be able to see the
Gross Profit,
for wherever he can access the
Total Product Cost
.
Remember that
Gross Profit,
is a calculated measure equal to
Sales Amount
minus
Total Product Cost
.
However, querying the cube, we get this result:
We can see that the Read expression worked correctly, but the users can see
Sales
Amount
and
Gross Profit,
in places where they cannot see the
Total Product Cost
.
Clearly, by subtracting
Sales Amount
from
Gross Profit,
, they will be able to
determine the
Total Product Cost
.
Search WWH ::
Custom Search