OLAP Permissions not working

[darkmanta]

Hi everybody,

I'm trying to have a working role permission in JasperServer 3.7.0 with an OLAP schema with a dimension like this:

 

<Dimension type="StandardDimension" name="Provincia">
    <Hierarchy name="Provincia" hasAll="true" allMemberName="Tutte le Province">
        <Level name="Provincia" column="PROVINCIA" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
    </Hierarchy>
</Dimension>

 

and a role definition like this:

<Role name="ROLE_FR">
    <SchemaGrant access="none">
        <CubeGrant cube="Cubone" access="none">
            <DimensionGrant dimension="[Provincia]" access="none">
            </DimensionGrant>
            <HierarchyGrant hierarchy="[Provincia]" access="custom">
                <MemberGrant member="[Provincia].[RM]" access="none">

# I have used <MemberGrant member="[Provincia].[Tutte le Province].[RM]" access="none"> with the same result

                </MemberGrant>
            </HierarchyGrant>
        </CubeGrant>
    </SchemaGrant>
</Role>

<Role name="ROLE_USER">
    <SchemaGrant access="none">
        <CubeGrant cube="Cubone" access="none">
        </CubeGrant>
    </SchemaGrant>
</Role>

 

And I don't know why a user member of ROLE_FR and ROLE_USER can still see [RM] in the Mondrian view.

 

Some help, please!

Thanks

Post Edited by darkmanta at 06/23/2010 08:56