Database Reference
In-Depth Information
This last point raises another question: what will happen if a user queries the cube
through this role without selecting anything from the Sales Territory hierarchy?
We can see the answer in the left-hand side of the following screenshot—the
CurrentMember
on
Sales Territory
is the default member, which is the All Member,
which of course the role cannot access data for. It's only when the user specifically
selects
Canada
in the query, as shown in the right-hand side of the following
screenshot, that any data is visible:
Cell level security can be used to control access to
Measures
too. For example, using
this expression for the
Enable read permissions
MDX formula:
([Measures].CurrentMember IS [Measures].[Sales Amount])
OR
([Measures].CurrentMember IS [Measures].[Tax Amount])
We get this result:
Search WWH ::
Custom Search