[Mondrian] Role and Cube

kevin melo kevinmelo92 at gmail.com
Thu Mar 3 11:18:18 EST 2016


Thanks.

2016-03-02 18:43 GMT-03:00 Matt Campbell <mcampbell at pentaho.com>:

> You wouldn’t refer to Group 2 in your Role definition, you’d have a
> MemberGrant that gives access=“none” to [Measures].[Measure 2].
>
> From: <mondrian-bounces at pentaho.org> on behalf of kevin melo <
> kevinmelo92 at gmail.com>
> Reply-To: Mondrian list <mondrian at pentaho.org>
> Date: Wednesday, March 2, 2016 at 10:43 AM
>
> To: Mondrian list <mondrian at pentaho.org>
> Subject: Re: [Mondrian] Role and Cube
>
> I'm getting some problems with role in mondrian 4... In Mondrian 3 use and
> test and works, but i'm not getting nay result in mondrian 4.
> Can you help me?
>
> A example of my Schema:
> <*Schema* name="My Schema">
>     <*Dimension* name="My Dimension">
>         <*Attribute* name="address"/>
>     </*Dimension*>
>     <*Cube* name="My Cube">
>         <*Dimension* source="My Dimension"/>
>         <*MeasureGroups*>
>             <*MeasureGroup* name="Group 1" type="fact">
>                 <*Measures*>
>                     <*Measure* name="Measure 1">
>                 </*Measures*>
>             </*MeasureGroup*>
>             <*MeasureGroup* name="Group 2" type="fact">
>                 <*Measures*>
>                     <*Measure* name="Measure 2">
>                 </*Measures*>
>             </*MeasureGroup*>
>         <*MeasureGroups*>
>     </*Cube*>
> </*Schema*>
>
> How will be the Role, if i want to deny the access to the *MeasureGroup *
> name="Group 2"?
>
> 2016-03-02 11:28 GMT-03:00 Matt Campbell <mcampbell at pentaho.com>:
>
>>
>> You need to individually specify the measure members you want to grant or
>> deny access to, not the whole measure group.  Another thing to keep in
>> mind— I believe if you specify any measures as access=‘all’ or ‘none’, then
>> any measures that aren’t explicitly referenced are assumed to be ‘none’.
>> So any measures you want to be accessible within a role need to have
>> access=‘all’.
>>
>> From: <mondrian-bounces at pentaho.org> on behalf of kevin melo <
>> kevinmelo92 at gmail.com>
>> Reply-To: Mondrian list <mondrian at pentaho.org>
>> Date: Wednesday, March 2, 2016 at 8:55 AM
>> To: Mondrian list <mondrian at pentaho.org>
>> Subject: Re: [Mondrian] Role and Cube
>>
>> Ok, but in mondrian 3 i have 3 cube with one virtual cube.
>> Now in mondrian 4 i have 1 cube with 3 facts MeasureGroup. And inside my
>> measuregroup i didt' have hierarchy only inside my dimensions
>>
>> i want to restrict access to a specific measuregroup.
>> <Role name="TEST">
>> <SchemaGrant access="none">
>> <CubeGrant access="all" cube="MyCube">
>> <MemberGrant access="none" member="MyMeasureGroup"/>
>> </CubeGrant>
>> </SchemaGrant>
>> </Role>
>>
>> 2016-03-02 10:41 GMT-03:00 Matt Campbell <mcampbell at pentaho.com>:
>>
>>>
>>> The definition of a <Role> in Mondrian 4 is consistent with Mondrian 3.
>>> And yes, you should be able to restrict access to a measure by specifying
>>>  a MemberGrant with access=‘none’.
>>>
>>>
>>>
>>> From: <mondrian-bounces at pentaho.org> on behalf of kevin melo <
>>> kevinmelo92 at gmail.com>
>>> Reply-To: Mondrian list <mondrian at pentaho.org>
>>> Date: Wednesday, March 2, 2016 at 6:45 AM
>>> To: Mondrian list <mondrian at pentaho.org>
>>> Subject: [Mondrian] Role and Cube
>>>
>>> In mondrian-4 Role have any syntax difference in create a role?
>>>
>>> And i can restrict the access to some measure inside my cube?
>>>
>>> Ex: I have 3 Measure: *amount, price, discount*. And i want to block
>>> the access to the amount measure.
>>>
>>> _______________________________________________
>>> Mondrian mailing list
>>> Mondrian at pentaho.org
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>
>>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160303/1c3939be/attachment-0001.html 


More information about the Mondrian mailing list