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

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

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

Hi, has somebody exprerience with VirtualCubes? I have 3 cubes each has different fact table, and i need combine measures and dimensions from these cubes. When I select only one measure from this Virtual cube everythings works fine, but when I'll select more measures, each from other cube I get exception: Code: Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Profitabilita2], [Measures].[Profitabilita1]} ON COLUMNS, Hierarchize(Union({[Account officers].[All Account officers]}, [Account officers].[All Account officers].Children)) ON ROWS from [ZustatkyAll] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1035) at mondrian.olap.Util.newInternal(Util.java:914) at mondrian.olap.Util.newError(Util.java:930) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:186) ... 81 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1032) at mondrian.olap.Util.newInternal(Util.java:907) at mondrian.olap.Util.assertTrue(Util.java:888) at mondrian.rolap.agg.SegmentArrayQuerySpec.addMeasure(SegmentArrayQuerySpec.java:105) at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSQL(AbstractQuerySpec.java:90) at mondrian.rolap.agg.SegmentArrayQuerySpec.generateSqlQuery(SegmentArrayQuerySpec.java:84) at mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:198) at mondrian.rolap.agg.Segment.load(Segment.java:251) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:130) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:71) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:292) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:157) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:239) at mondrian.rolap.RolapResult.<init>(RolapResult.java:157) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) ... 82 more Must be fulfilled some rule between Cubes for creating Virtual cube from them?What asserts mondrian in virtual cube? I didn't find anything in the documentation about this :- thx dis. Post edited by: disorder, at: 2006/11/23 10:17

I got there CDATA tags, but it didn't help. There must be problem somewhere in the definition of xml schema. I solved this problem so I created <View> with these counted columns. Also custom columns should help, I'll try it, it seems better solution than my. thx for reply dis

Hi, I have problem with definition of measure in modrian cube schema. I need measure which is not from column but counted with some expression. Definition of my measure is: Code: <Measure name="Activity" type="Numeric" aggregator="sum" formatString="#,###0.00"> <MeasureExpression> <SQL dialect="generic"> (IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0)) </SQL> </MeasureExpression> </Measure> When I run report I get exception Code:[code] Caused by: org.eigenbase.xom.XOMException: In element 'Schema': In element 'Cube': In element 'Measure': Attribute 'column' is unset and has no default value. at mondrian.olap.MondrianDef$Schema.<init>(MondrianDef.java:127) at mondrian.rolap.RolapSchema.load(RolapSchema.java:218) ... 71 more Thats right, column isn't there because i want to use expression. I followed example from documentation, where also isn't column in the tag defined. Is there problem with version? I'm using JI 1.0 thx for reply dis

yeah, it works :) ...thx dis

Hi, does anybody know if iReport forwards generating report with mondrian connection, but with field which is dimension with parent-child relation? I have MDX : Code:SELECT {[Measures].[Credit balance debet],[Measures].[Credit balance clear]} ON COLUMNS, {[Profit centers].members} ON ROWS FROM Zustatky where [Profit centers] is dimension with parent-child relation. Problem is, when i get field in detail band, generated report is empty. When I'll choose another dimension without parent-child relation, then works everything fine. Another question: Does anybody know,when will be feature to define mondrian connection for static report on JI forwarded? Or is it yet in JI 1.1, because I'm using 1.0. thanks for replay Dis

thx very much, now it works :silly: Dis

Hi all, I have problem with running recursively subreport in JI. I have main report which contains subreport and this has as subreport itself. In iReport it works without problem but when i deployed it in JI, after running the report, there is exception: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1da6868 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1fcadd3, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is java.lang.NullPointerException: null java.lang.NullPointerException at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:68) at java.net.URL.openStream(URL.java:1007) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:139) at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:243) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:277) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1289) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:631) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:494) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Thread.java:595) java.lang.NullPointerException java.lang.NullPointerException at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:68) at java.net.URL.openStream(URL.java:1007) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:139) at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:243) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:277) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1289) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:631) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:494) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Thread.java:595) Does anybody know, where can be problem?

Hi, does anybody know how to get smaller font for axis in the chart. I didn't find any attribute for change it in iReport:( Is it supported in JFreeChart? :(

Hi, I made report in iReport with internationalization support for czech language. I have problem with character encoding of properties file. I think that loaded parameters have another encoding as report. Report encoding is set to UTF-8, all characters from database are correct, only from properties file not. Property file is in UTF-8 also. Knows somebody, in which character encoding are loaded data from properties file? Or has somebody the same problem?

Hi, I made report in iReport with internationalization support for czech language. I have problem with character encoding of properties file. I think that loaded parameters have another encoding as report. Report encoding is set to UTF-8, all characters from database are correct, only from properties file not. Property file is in UTF-8 also. Knows somebody, in which character encoding are loaded data from properties file? Or has somebody the same problem?