[Mondrian] Error in Role (Mondrian 2.4)

miguel mvillagomez at sayab.com.mx
Tue Aug 7 21:37:45 EDT 2007


What so I am updating of mondrian 2,2 to mondrian 2.4.
My problem appears in the section of roles of my exquema, I I have: 

 <Dimension name="Force of Sales" caption="%{Opportunity.dimension.3}">
  <Hierarchy hasAll="false" primaryKey="repr">
   <Table name="forcesales"/>
   <Level name="Nivel_0" column="nivel_0" ordinalColumn="nivel_0"
type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Nivel_1" column="nivel_1" ordinalColumn="nivel_1"
type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Nivel_2" column="nivel_2" ordinalColumn="nivel_2"
type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Nivel_3" column="nivel_3" ordinalColumn="nivel_3"
type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Nivel_4" column="nivel_4" ordinalColumn="nivel_4"
type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
   <Level name="Nivel_5" column="nivel_5" ordinalColumn="nivel_5"
type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

With the next role:

  <Role name="D000"><!--DIRECTOR-->							
   <SchemaGrant access="none">
     <CubeGrant cube="Opportunity" access="all">
	 <HierarchyGrant hierarchy="[Force of Sales]" access="custom"
topLevel="[Force of Sales].[Nivel_1]">
      <MemberGrant member="[Force of Sales].[ADMINGRAL].[DIRECTOR]"
access="all"/>
	 </HierarchyGrant>
	</CubeGrant>						
   </SchemaGrant>							
  </Role> 	

This works well in mondrian 2.2; now in the 2,4 this same one causes the
following error to me: 

 javax.servlet.ServletException: javax.servlet.jsp.JspTagException: 
 javax.servlet.jsp.JspException:
 An error occurred while evaluating custom action attribute "test" with
value "${query01.result.overflowOccured}":
 An error occurred while getting property "result" from an instance of
class com.tonbeller.jpivot.tags.OlapModelProxy
(java.lang.NullPointerException)

I have already updated other cubes and they have not caused any problem
to me in this section of roles; this cube presents east problem of
isolated form,
reason why I was checking by enough short while that the error was not
mine, but have not been able to locate it or is bug in this version of
mondrian.
When I modify the roll and I leave it thus:

  <Role name="D000"><!--DIRECTOR-->							
   <SchemaGrant access="none">
     <CubeGrant cube="Opportunity" access="all">
	 <HierarchyGrant hierarchy="[Force of Sales]" access="custom"
topLevel="[Force of Sales].[Nivel_0]">
      <MemberGrant member="[Force of Sales].[ADMINGRAL]" access="all"/>
	 </HierarchyGrant>
	</CubeGrant>						
   </SchemaGrant>							
  </Role> 	

It works well, but adding more levels no.
Here my table: 

  nivel_0  | nivel_1  |    nivel_2     |    nivel_3     |  nivel_4  |
nivel_5  | representantes 
-----------+----------+----------------+----------------+-----------+----------+----------------
 ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | PROYECTOS |
PROY001  | PROY001
 ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | VENTAS    |
VTA001   | VTA001
 ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
ID001    | ID001
 ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
ID002    | ID002
 ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
ID003    | ID003
 ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
ID004    | ID004
 ADMINGRAL | DIRECTOR | ---            | ---            | ---       |
D000     | D000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | ---            | ---       |
A000     | A000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | SOPORTE        | ---       |
SREAD    | SREAD
 ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | ---       |
PROYREAD | PROYREAD
 ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | ---       |
VTAREAD  | VTAREAD
 ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | ---       |
STAFF000 | STAFF000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | DISTRIBUIDORES | ---       |
DIST000  | DIST000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | ---       |
IDREAD   | IDREAD
 ADMINGRAL | DIRECTOR | ADMINISTRACION | MONTERREY      | ---       |
MTY000   | MTY000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | SOPORTE        | SOP001    |
SOP001   | SOP001
 ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | PROYECTOS |
PROY000  | PROY000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | VENTAS    |
VTA000   | VTA000
 ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | STAFF001  |
STAFF001 | STAFF001
 ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | STAFF002  |
STAFF002 | STAFF002
 ADMINGRAL | DIRECTOR | ADMINISTRACION | DISTRIBUIDORES | DIST001   |
DIST001  | DIST001

I have already checked until the fatigue the roles, even single leaving
this of isolated form and trying to be able to see beyond nivel_0.
Somebody can say please to me that I must check or although this if he
is bug? 




More information about the Mondrian mailing list