updated to 1.1.0 mondrian crashes

[kidpollo]

I managed to update my jasper intelligence installation from 1.0.1 to 1.1.0 manually, I installed 1.1.0 with the bit rock installer and updated the database, everything works smoothly except the mondrian views I had working.

 

I get an error like this

 

Code:

Pivot had an error ...

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoSuchFieldError: CubeRelationNotTable

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoSuchFieldError: CubeRelationNotTable
java.lang.NoSuchFieldError: CubeRelationNotTable
	at mondrian.rolap.aggmatcher.ExplicitRules$Group.make(ExplicitRules.java:110)
	at mondrian.rolap.RolapCube.loadAggGroup(RolapCube.java:341)
	at mondrian.rolap.RolapCube.(RolapCube.java:239)
	at mondrian.rolap.RolapSchema.load(RolapSchema.java:309)
	at mondrian.rolap.RolapSchema.load(RolapSchema.java:229)
	at mondrian.rolap.RolapSchema.(RolapSchema.java:159)
	at mondrian.rolap.RolapSchema.(RolapSchema.java:49)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:802)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:636)
	at mondrian.rolap.RolapConnection.(RolapConnection.java:138)
	at mondrian.rolap.RolapConnection.(RolapConnection.java:73)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:120)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:87)
	at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:386)
.
.
.

 

any ideas?

[disorder]

Hi,

 

I got the same error, after update from 1.0 to 1.1.

The problem was that i used dimension as View with SQL query. But now I can't use View and I need it.

Mondrian should support View in the schema or not? Isn't this bug?

 

dis

[swood]

Can you post your schema?

 

 

Sherman

JasperSoft

[disorder]

Hi,

there's my schema

Code:

<?xml version="1.0"?>

<Schema name="Zustatkyy">

    <Dimension name="Accounts">
      <Hierarchy hasAll="true" allMemberName="All Accounts" primaryKey="ac">
        <Table name="vb.tblaccbridge" alias="tblaccbridge"/>
        <Level name="Accounts" column="ac" nameColumn="ACNameLL" uniqueMembers="true" type="String"/>
      </Hierarchy>
    </Dimension>

    <Dimension name="Clients">
      <Hierarchy hasAll="true" allMemberName="All Clients" primaryKey="c_cnum">
        <Table name="vb.tblcusts" alias="tblcusts"/>
        <Level name="Clients" column="c_cnum" nameColumn="c_bbcrnm" uniqueMembers="true" type="String"/>
      </Hierarchy>
    </Dimension>

    <Dimension name="Account officers">
      <Hierarchy hasAll="true" allMemberName="All Account officers" primaryKey="ao">
        <View alias="bs_todayO">
          <SQL dialect="generic">
            select distinct ao from vb.bs_today
          </SQL>
        </View>
        <Level name="Account officer" column="ao" nameColumn="ao" uniqueMembers="true" type="String"/>
      </Hierarchy>
    </Dimension>


  <Cube name="Zustatky">
    <View alias="bs_today">
      <SQL dialect="generic">
      <![CDATA[  
        SELECT*,(IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0)) as czkeqO,(IF(grp='ASS',if(czkeq>0,czkeq*indb,czkeq*incr),0)+IF(grp='ASL' AND czkeq>0,czkeq*indb,0))/(IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0)) AS i_assO,
          (IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)) AS liaO,
          (IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq*incr,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq*incr,0))/(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)) AS i_liaO, 
          (IF(acod=9742 or acod=9744,-1*czkeq,0)) AS seO, 
          (IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0))+(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)+IF(acod=9742 or acod=9744,-1*czkeq,0)) AS volO
        FROM vb.bs_today left join vb.tblaccbridge on acod=ac
        ]]> 
      </SQL>
    </View>

    <Dimension name="Division" foreignKey="pc">
	  <Hierarchy hasAll="true" allMemberName="All Divisions" primaryKey="pc">	  
      <Table name="profitability.division" alias="division"/>
      <Level name="Divize" column="divize_name" nameColumn="divize_name" uniqueMembers="true" type="String"/>
      <Level name="SubDivision" column="odbor" nameColumn="name" uniqueMembers="true" type="String"/>
      <Level name="ProfitCenter" column="pc" nameColumn="pc" uniqueMembers="true" type="String"/>
	  </Hierarchy>
    </Dimension>

    <DimensionUsage name="Account officers" source="Account officers" foreignKey="ao"/>
    <DimensionUsage name="Clients" source="Clients" foreignKey="cnum"/>
    <!--DimensionUsage name="Accounts" source="Accounts" foreignKey="acod"/-->
    
    <Measure name="Aktiva" type="Numeric" column="czkeqO" aggregator="sum" formatString="#,###0.00"/>    
    <Measure name="Aktiva ur. sazba" type="Numeric" column="i_assO" aggregator="sum" formatString="#,###0.00"/>
    <Measure name="Pasiva" type="Numeric" column="liaO" aggregator="sum" formatString="#,###0.00"/>
    <Measure name="Pasiva ur. sazba" type="Numeric" column="i_liaO" aggregator="sum" formatString="#,###0.00"/>
    <Measure name="Cenne papiry" type="Numeric" column="seo" aggregator="sum" formatString="#,###0.00"/>
    <Measure name="Obchodni objem" type="Numeric" column="volO" aggregator="sum" formatString="#,###0.00"/>    
    <!--Measure name="Warehouse Profit" aggregator="sum">
      <MeasureExpression>
        <SQL dialect="mysql">
(case when `vb.bs_today`.`promotion_id` = 0 then 0 else `sales_fact_1997`.`store_sales` end)
IF(`grp`='ASS',`czkeq`,0)+IF(`grp`='ASL' AND `czkeq`>0,`czkeq`,0)
        </SQL>
      </MeasureExpression>
    </Measure-->
  </Cube>
  
  <Cube name="Profitabilita">
    <Table name="dwh.margin_month" alias="margin_month"/>
    
    <DimensionUsage name="Clients" source="Clients" foreignKey="cnum"/>
    <Measure name="Profitability" type="Numeric" column="margin" aggregator="sum" formatString="#,###0.00"/>
    
  </Cube>
  
  <VirtualCube name="ZustatkyAll">
    <VirtualCubeDimension cubeName="Zustatky" name="Division"/>
    <VirtualCubeDimension name="Clients"/>
    
    <VirtualCubeMeasure cubeName="Zustatky" name="[Measures].[Aktiva]"/>
    <!--VirtualCubeMeasure cubeName="Zustatky" name="[Measures].[Aktiva ur. sazba]"/-->
    <VirtualCubeMeasure cubeName="Profitabilita" name="[Measures].[Profitability]"/>
  </VirtualCube>
  
</Schema>

I think problem was not in dimension but in the cube, because it is defined as view.
What is good, measure expression now works.

dis

[swood]

This looks like a Mondrian level bug. It may have been fixed - we will have to do some digging.

 

BTW: The way your cube database is laid out is not efficient. Doing the Views and MeasureExpressions forces Mondrian to do a lot of work that would be best done by a more efficient database layout.

 

 

 

Sherman

JasperSoft

[disorder]

thanks,

 

I know that my schema is not efficient, because I used mysql4 database and without admin privilegies. But now I work with mysql5 so I can create view and also I have root privilegies, so I changed my schema.

 

But I have another problem. Is there some solution for creating interactive reports? When I have report grouped by more values it is possible to expand/collapse report by clicking on grouped value? Because I find this feature only with using jpivot. But I need it for example in generated html from normall report.

 

dis

[swood]

You can define reports that have parameterized links that go to the same report or to another report with a different format.

 

 

Sherman

JasperSoft