Database Reference
In-Depth Information
If you use the preceding expression to define read-contingent permission (as
shown in the preceding screenshot), the role members will see #N/A for the
calculated measure Average Sales Amount because you did not grant
them the permission to see the Order Count measure that is necessary for
calculating the average. On the other hand, if you enter the same expression
under the Enable read permissions checkbox, role members will see the
calculated measure even though they won't see the Order Count measure.
There's more...
In some cases, when you must use multiple fact tables, you have a choice of creating
multiple cubes or a single cube with multiple measure groups. If you use a Secur-
ity measure group, you should create a single cube with multiple measure groups
because you would only have to process the Security measure group once. This
is presuming that the same Security measure group can be used for securing di-
mension data for all other measure groups which may or may not always be the
case.
Search WWH ::




Custom Search