[Mondrian] Suggestion: <HierarchyGrant access="custom"> add defaultmember access

Julian Hyde jhyde at pentaho.com
Mon Jun 22 13:16:18 EDT 2009


Usually the access to a member is inherited from its parent. For instance,
if you deny access to [USA].[CA], then all of its children are by default
denied. Then you can explicitly grant access to [USA].[CA].[San Francisco],
and the children of San Francisco are by default granted.
 
You know all that. The problem in this case is that there is single root
member - there are a lot of members of the first level.
 
I agree with your solution. Please log a feature request.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Alexander Korsukov
Sent: Sunday, June 21, 2009 8:34 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Suggestion: <HierarchyGrant access="custom"> add
defaultmember access


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
<mailto:xmpp%3Ashko at jabber.ru> 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090622/8fee9ce9/attachment.html 


More information about the Mondrian mailing list