[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: Re: [Mondrian] Role and Cube
From: kevin melo <kevinmelo92 () gmail ! com>
Date: 2016-03-03 16:18:18
Message-ID: CAL6pzZCovZWwPnbrCBXWy0ef+OOn62jv8NpuHWp9oM8eexS_5A () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thanks.
2016-03-02 18:43 GMT-03:00 Matt Campbell <mcampbell@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@pentaho.org> on behalf of kevin melo <
> kevinmelo92@gmail.com>
> Reply-To: Mondrian list <mondrian@pentaho.org>
> Date: Wednesday, March 2, 2016 at 10:43 AM
>
> To: Mondrian list <mondrian@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@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@pentaho.org> on behalf of kevin melo <
>> kevinmelo92@gmail.com>
>> Reply-To: Mondrian list <mondrian@pentaho.org>
>> Date: Wednesday, March 2, 2016 at 8:55 AM
>> To: Mondrian list <mondrian@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@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@pentaho.org> on behalf of kevin melo <
>>> kevinmelo92@gmail.com>
>>> Reply-To: Mondrian list <mondrian@pentaho.org>
>>> Date: Wednesday, March 2, 2016 at 6:45 AM
>>> To: Mondrian list <mondrian@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@pentaho.org
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>
>>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian@pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian@pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
[Attachment #5 (text/html)]
<div dir="ltr">Thanks.</div><div class="gmail_extra"><br><div \
class="gmail_quote">2016-03-02 18:43 GMT-03:00 Matt Campbell <span dir="ltr"><<a \
href="mailto:mcampbell@pentaho.com" \
target="_blank">mcampbell@pentaho.com</a>></span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div>
<div>You wouldn't refer to Group 2 in your Role definition, you'd have a MemberGrant \
that gives access="none" to [Measures].[Measure 2].</div> <div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium \
none;BORDER-LEFT:medium \
none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt \
solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt"><span class=""> <span \
style="font-weight:bold">From: </span><<a \
href="mailto:mondrian-bounces@pentaho.org" \
target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a \
href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br> \
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br> \
</span><span style="font-weight:bold">Date: </span>Wednesday, March 2, 2016 at 10:43 \
AM<div><div class="h5"><br> <span style="font-weight:bold">To: </span>Mondrian list \
<<a href="mailto:mondrian@pentaho.org" \
target="_blank">mondrian@pentaho.org</a>><br> <span \
style="font-weight:bold">Subject: </span>Re: [Mondrian] Role and Cube<br> \
</div></div></div><div><div class="h5"> <div><br>
</div>
<div>
<div>
<div dir="ltr">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. <div>Can \
you help me?</div> <div><br>
</div>
<div>A example of my Schema:</div>
<div><<b>Schema</b> name="My Schema"></div>
<div> <<b>Dimension</b> name="My Dimension"></div>
<div> <<b>Attribute</b> name="address"/></div>
<div> </<b>Dimension</b>></div>
<div> <<b>Cube</b> name="My Cube"></div>
<div> <<b>Dimension</b> source="My Dimension"/></div>
<div> <<b>MeasureGroups</b>></div>
<div> <<b>MeasureGroup</b> name="Group 1" \
type="fact"></div> <div> \
<<b>Measures</b>></div> <div> <<b>Measure</b> \
name="Measure 1"></div> <div> \
</<b>Measures</b>></div> <div> \
</<b>MeasureGroup</b>></div> <div> <<b>MeasureGroup</b> \
name="Group 2" type="fact"></div> <div> \
<<b>Measures</b>></div> <div> <<b>Measure</b> \
name="Measure 2"></div> <div> \
</<b>Measures</b>></div> <div> \
</<b>MeasureGroup</b>></div> <div> \
<<b>MeasureGroups</b>></div> <div> </<b>Cube</b>></div>
<div></<b>Schema</b>></div>
<div><br>
</div>
<div>How will be the Role, if i want to deny the access to the <b>MeasureGroup </b>
name="Group 2"?</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-03-02 11:28 GMT-03:00 Matt Campbell <span dir="ltr">
<<a href="mailto:mcampbell@pentaho.com" \
target="_blank">mcampbell@pentaho.com</a>></span>:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div \
style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div>
<div><br>
</div>
<div>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'.</div> <div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium \
none;BORDER-LEFT:medium \
none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt \
solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt"> <span><span \
style="font-weight:bold">From: </span><<a \
href="mailto:mondrian-bounces@pentaho.org" \
target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a \
href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br> \
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br> \
</span><span style="font-weight:bold">Date: </span>Wednesday, March 2, 2016 at 8:55 \
AM<br> <span style="font-weight:bold">To: </span>Mondrian list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br> \
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Role and Cube<br> \
</div> <div>
<div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Ok, but in mondrian 3 i have 3 cube with one virtual cube.
<div>Now in mondrian 4 i have 1 cube with 3 facts MeasureGroup. And inside my \
measuregroup i didt' have hierarchy only inside my dimensions</div> <div><br>
</div>
<div>i want to restrict access to a specific measuregroup.</div>
<div>
<div><Role name="TEST"></div>
<div><span style="white-space:pre-wrap"></span><SchemaGrant \
access="none"></div> <div><span \
style="white-space:pre-wrap"></span><CubeGrant access="all" \
cube="MyCube"></div> <div><span \
style="white-space:pre-wrap"></span><<span \
style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">MemberGrant</span> \
access="none" member="MyMeasureGroup"/></div> <div><span \
style="white-space:pre-wrap"></span></CubeGrant></div> <div><span \
style="white-space:pre-wrap"></span></SchemaGrant></div> \
<div></Role></div> </div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-03-02 10:41 GMT-03:00 Matt Campbell <span dir="ltr">
<<a href="mailto:mcampbell@pentaho.com" \
target="_blank">mcampbell@pentaho.com</a>></span>:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div \
style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div>
<div><br>
</div>
<div>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'.</div> <div><br>
</div>
<div><br>
</div>
<div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium \
none;BORDER-LEFT:medium \
none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt \
solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt"> <span style="font-weight:bold">From: \
</span><<a href="mailto:mondrian-bounces@pentaho.org" \
target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a \
href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br> \
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br> \
<span style="font-weight:bold">Date: </span>Wednesday, March 2, 2016 at 6:45 AM<br> \
<span style="font-weight:bold">To: </span>Mondrian list <<a \
href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br> \
<span style="font-weight:bold">Subject: </span>[Mondrian] Role and Cube<br> </div>
<span>
<div><br>
</div>
<div>
<div>
<div dir="ltr">In mondrian-4 Role have any syntax difference in create a role?
<div><br>
</div>
<div>And i can restrict the access to some measure inside my cube?</div>
<div><br>
</div>
<div>Ex: I have 3 Measure: <b>amount, price, discount</b>. And i want to block the \
access to the amount measure.</div> </div>
</div>
</div>
</span></span></div>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> <br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</span></div>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> <br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div></div></span>
</div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> \
<br></blockquote></div><br></div>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic