[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