[Mondrian] Suggestion: <HierarchyGrant access="custom"> add default member access
Alexander Korsukov
akorsukov at gmail.com
Sun Jun 21 23:33:40 EDT 2009
Hello.
I have cube [CubeA] and N measures [Measures].[M1], [Measures].[M2], ...
[Measures].[Mn]. It is easy to define a role that allow access to some
members of hierarchy:
<Role name="Allow only M1">
<SchemaGrant access="none">
<CubeGrant cube="CubeA" access="all">
<HierarchyGrant hierarchy="[Measures]" access="custom">
<MemberGrant member="[Measures].[M1]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
because <HierarchyGrant> by default deny access to members for which access
is not defined explicitly. But it is not so easy to deny access to certain
members of hierarchy:
<Role name="Deny M1">
<SchemaGrant access="none">
<CubeGrant cube="CubeA" access="all">
<HierarchyGrant hierarchy="[Measures]" access="custom">
<MemberGrant member="[Measures].[M2]" access="all"/>
<MemberGrant member="[Measures].[M3]" access="all"/>
<!-- ... -->
<MemberGrant member="[Measures].[Mn]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
It would be perfect to have possibility to define default access to members
of hierarchy for custom access of <HierarchyGrant/>:
<Role name="Deny M1">
<SchemaGrant access="none">
<CubeGrant cube="CubeA" access="all">
<HierarchyGrant hierarchy="[Measures]" access="custom"
memberAccess="all">
<MemberGrant member="[Measures].[M1]" access="none"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="Allow only M1">
<SchemaGrant access="none">
<CubeGrant cube="CubeA" access="all">
<!-- memberAccess="none" is default behavior as now -->
<HierarchyGrant hierarchy="[Measures]" access="custom"
memberAccess="none">
<MemberGrant member="[Measures].[M1]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
--
Alexander.
_____________________________________________________
mailto:akorsukov at gmail.com icq:8572488
(2E0A2052) xmpp:shko at jabber.ru<xmpp%3Ashko at jabber.ru>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090622/518072cb/attachment.html
More information about the Mondrian
mailing list