[Mondrian] Access to cube in Mondrian 3.0.3

miguel mvillagomez at sayab.com.mx
Thu Jul 31 13:43:55 EDT 2008


What I have a poblema with Mondrian and permissions.
I have this table in my cube:

Table "Tree":
 supervisor |  merchant  |  route    
------------+------------+------------
 SUPERVISOR | D0001      | D0001
 SUPERVISOR | V0001      | V0001

And access to this size so I configured as follows:

 <Dimension name="Arbol">
  <Hierarchy hasAll="false" primaryKey="route">
   <Table name="tree"/>
   <Level name="Supervisor" column="supervisor" type="String"
hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Vendedor" column="merchant" type="String"
hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Ruta" column="route" type="String"
hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

Here roles:

  <Role name="SUPERVISOR">
   <SchemaGrant access="none">
     <CubeGrant cube="Presupuesto2" access="all"/>
   </SchemaGrant>
  </Role>

  <Role name="D0001">
   <SchemaGrant access="none">
     <CubeGrant cube="Presupuesto2" access="all">
	  <HierarchyGrant hierarchy="[Arbol]" access="custom"
topLevel="[Arbol].[Vendedor]">
       <MemberGrant member="[Arbol].[SUPERVISOR].[D0001]" access="all"/>
	  </HierarchyGrant>
	 </CubeGrant>
   </SchemaGrant>
  </Role>

  <Role name="V0001">
   <SchemaGrant access="none">
     <CubeGrant cube="Presupuesto2" access="all">
	  <HierarchyGrant hierarchy="[Arbol]" access="custom"
topLevel="[Arbol].[Ruta]">
       <MemberGrant member="[Arbol].[SUPERVISOR].[V0001].[V0001]"
access="all"/>
	  </HierarchyGrant>
	 </CubeGrant>
   </SchemaGrant>
  </Role>

They are only 3 permits, the former has access to all the cube and is
now the only one that works.
The second can only have access to the level of "Vendedor" and in this
case indicated that this tied to the value: "[Arbol]. [SUPERVISOR].
[D0001]"
this is correct as you can see values in the table.
Do this only to rise a level in the third role which reaches "route".

When I try to access the cube pulls me errors in these two permits which
reads:

Mondrian Error:Member '[Arbol].[SUPERVISOR].[D0001]' not found
Mondrian Error:Member '[Arbol].[SUPERVISOR].[V0001].[V0001]' not found

As far as these two quite accesses and try to see it in the editor mdx
within the cube.
It came with the role of "SUPERVISOR" and select the dimension "Arbol"
at level "Ruta" value "V0001" which you can see this in the table on the
base
data and note that throws me this:

select NON EMPTY {[Measures].[Total]} ON COLUMNS,
  NON EMPTY {[Arbol].[SUPERVISOR].[V0001].[V0001]} ON ROWS
from [Presupuesto2]

After I select the size "tree" at level "Merchant" value "D0001" which
also is on the table and pulls me this:

select NON EMPTY {[Measures].[Total]} ON COLUMNS,
  NON EMPTY {[Arbol].[SUPERVISOR].[D0001]} ON ROWS
from [Presupuesto2]
	
Now I have copied these as is the tool shed, then to come back and hit
me and as it draws the mistake that there is no such subject.
The time when I select the item and goes well (Image_1.png)
The time when I return to come and go wrong with the same query
(Image_2.png)

Which is what I am doing wrong?

Use:
Title: mondrian
Version: 3.0.3.11016
Vendor: Pentaho
-- 
Miguel Ángel Villagómez Díaz
Sayab Technologies S.C.
Tel. 3616-9100
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image1.png
Type: image/png
Size: 101962 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080731/a7f7637a/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image2.png
Type: image/png
Size: 108005 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080731/a7f7637a/attachment-0001.png 


More information about the Mondrian mailing list