Hello.<br><br>I have cube <span style="font-family: courier new,monospace;">[CubeA]</span> and <span style="font-family: courier new,monospace;">N</span> measures <span style="font-family: courier new,monospace;">[Measures].[M1]</span>, <span style="font-family: courier new,monospace;">[Measures].[M2]</span>, ... <span style="font-family: courier new,monospace;">[Measures].[Mn]</span>. It is easy to define a role that allow access to some members of hierarchy:<br>
<br><span style="font-family: courier new,monospace;"><Role name="Allow only M1"></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> <SchemaGrant access="none"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <CubeGrant cube="CubeA" access="all"></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> <HierarchyGrant hierarchy="[Measures]" access="custom"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[M1]" access="all"/></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> </HierarchyGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </CubeGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </SchemaGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></Role><br><font face="arial,helvetica,sans-serif"><br>because </font></span><span style="font-family: courier new,monospace;"><HierarchyGrant</span>><font face="arial,helvetica,sans-serif"> by default deny</font> access to members for which access is not defined explicitly. But it is not so easy to deny access to certain members of hierarchy:<br>
<span style="font-family: courier new,monospace;"><br><Role name="Deny M1"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <SchemaGrant access="none"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <CubeGrant cube="CubeA" access="all"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <HierarchyGrant hierarchy="[Measures]" access="custom"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[M2]" access="all"/></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[M3]" access="all"/></span><br>
<span style="font-family: courier new,monospace;"> <!-- ... --></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[Mn]" access="all"/></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;"> </HierarchyGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </CubeGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </SchemaGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></Role><br><br></span>It would be perfect to have possibility to define default access to members of hierarchy for <span style="font-family: courier new,monospace;">custom <font face="arial,helvetica,sans-serif">access of </font></span><span style="font-family: courier new,monospace;"><HierarchyGrant/></span>:<br>
<br><span style="font-family: courier new,monospace;">
<Role name="Deny M1"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <SchemaGrant access="none"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <CubeGrant cube="CubeA" access="all"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <HierarchyGrant hierarchy="[Measures]" access="custom" memberAccess="all"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[M1]" access="none"/></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;"> </HierarchyGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </CubeGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </SchemaGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></Role><br><br></span><span style="font-family: courier new,monospace;">
<Role name="Allow only M1"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <SchemaGrant access="none"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <CubeGrant cube="CubeA" access="all"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <!-- </span><span style="font-family: courier new,monospace;">memberAccess="none" is default behavior as now </span><span style="font-family: courier new,monospace;">--></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <HierarchyGrant hierarchy="[Measures]" access="custom" memberAccess="none"></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> <MemberGrant member="[Measures].[M1]" access="all"/></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;"> </HierarchyGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </CubeGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </SchemaGrant></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"></Role><br>
</span><br>
<br>-- <br>Alexander.<br>_____________________________________________________<br>mailto:<a href="mailto:akorsukov@gmail.com">akorsukov@gmail.com</a> icq:8572488<br>(2E0A2052) <a href="mailto:xmpp%3Ashko@jabber.ru">xmpp:shko@jabber.ru</a><br>
<br>