[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