Databases Reference
In-Depth Information
Figure 19-21
15. Open the MDX query editor in SQL Server Management Studio.
Select the Dimension Security database. If you send the following
MDX query by substituting for dimension, hierarchy, and cube name,
you should see the results for the default member you specified in
the role as shown in
Figure 19-22
.
If a user belongs to more than
one role, the default member for the first role in the roles collection is
chosen as the default member for the hierarchy.
Figure 19-22
SELECT <Dimension>.<Hierarchy>.Defaultmember on 0
From <CubeName>
Search WWH ::
Custom Search