jens_noering

If you want to use ireport 2.0.5 you will have to use the jasperreports 2.0.5 jar within jasperserver. simply replace the jasperreports.jar in the tomcat/webapps/jasperserver/WEB-INF/lib folder with the one shipped with IReport 2.0.5 and then restart tomcat. hth, jens

Hello, * IReport is the tool for Report design * jasperserver is the report server where you can publish the reports and give users access through a web app * jasperanalysis is the olap engine, here you can define your cubes and access them trough jpivot(web app shipped with jasperserver) or built reports with IReport on it You need to use all of these tools if you want to built reports on olap data. hth,

i think you could take a look at all forgein and primary kex defintions. maybe there is a problem. I think it is not necessary that you define the hierarchyName if you only have one hierarchy in the dimension. maybe i can take a deeper look at your schema at the weekend. i'm not so familar with defining the dimensions in the cube. i'm working with shared dimensions. hth, jens

I have no guess why mondrian points to the error, that the cube is not found. But I've seen one thing in your schema and querie that can not work: If you define the hierarchy as 'hasAll="True"' than you have to define an allMembername. hth, jens Post edited by: jens_noering, at: 2008/04/03 09:24

Maybe i can help you with that problem. The problem with the subreports and datasource i already solved: building a folder admin (name it like you want). building subfolders for datasources and inputcontrols after that change the permissions for the admin folder in that way, that only ROLE_ADMNINISTRATOR is able to view this folder. For the two subfolders you set the rights for ROLE_USER to Read Only. Now Standard user are not able to see the folder 'admin' but in reports the input controls and datasource work. Not tried this with hyperlink reports or subreports. hth, Jens

We are using jasperserver with the jt400 driver and everything works fine. So it should'nt be a jasperserver problem. Make sure you copied the driver in the /webapps/jasperserver/WEB-INF/lib folder and that you restart jasperserver after that. driver class name as you posted it. if that doesn't work maybe there is a problem with your jt400 driver version. hth, jens

We will now move with our jasperserver to 64-bit CentOS Linux. We installed seperatly: tomcat mysql(64-bit version) java (1.5 64-bit version) Hardware: 2X Intel Core2Quad 3 GHz 16 GB RAM After that we created the jasperserver tables and deployed the war file. Everything works fine. Only thing that had to be made was to deploy the import/ export tools seperatly, so that we could migrate the data from our old server. Performance is awesome. greetz, jens

Take a look at the jasperserver documentation. There is a chapter about the import and export tools of jasperserver. with this tolls you can migrate from one instance to another without any problems. hth, jens

Hello Sherman, that sounds great. We will try this solution with 64-bit java and 64-bit mysql version. When this is finished and it works, I will make a short summary who we did it and share it with the community. Thanks for the quick reply, Jens

We are using Jaspersoft open source server and analysis for reporting. Now we bought a new server that has 2 core2quad xeon with 16gb of ram. We are planing to run that machine on a 64-bit debian linux version. Is this supportet ? If not what are my opinions? We definitly need more than 4GB of ram. Maybe someone has experience with this? Greetz Jens,

Hello, bevor starting to create your own mdx statements you should take a look at some tutorials, because the mdx language is a powerfull database querying language which seems to be like sql, but there are a lot of differences beetwen same. A good tutorial is this: http://www.databasejournal.com/features/mssql/article.php/10894_1495511_2 With this tutorial you will understand how mdx and the function it contains work. hth, jens

With this description i can help you a lot more than with your initial post: with jasperserver you can pass the values from input controls to a jasperreport, so the user that is running the report for example chooses the year and the month. These two parameters are passed to the report. in this report you can define parameters which must have the same name as the input controls. then you can use this parameters to modify the slicers value in the way you posted ist. if you want to have an overview of the capabilities of jasperserver and the olap functionality there are some example reports comming with the open source version. there your can see how input controls are working and there is also an example of an report built on an mondrian connection. you can open the underlieing jrxml files with ireport an than see how an report with jasperreports has to be created. hope this helps you a little

At first you should explain in which way you want to use the olap engine comming with jasperserver: Do you want to use the jpivot interface or are you trying to create reports built on jasperreports and an mondrian datasource. The jpivot interface has no ability to use parameterized mdx query and this is nor the target of such an interface. with jasperreports and an mondrian datasource you can make parameterized mdx query. but you have to have some knowledge about the structure of mdx and the mondrian olap database. By the way: you should not post 5 or 6 topics at one day. be yourself clear about the problem and than post a significant question. hth, jens

Thanxx for your help, after downloading the new 1.3.5 snapshot it works. Have a nice weekend, greetz jens

I've updated js 1.2.1 to 2.0 using the war distribution and the given sql scripts. that works fine. At first I've tried to run a report built on a jdbc connection. That works fine, the report is generated in the way it should be. After that i tried to run a report built on a mondrian connection. But the only thing that was generated was a blank page. Now controll icons and now report. After that I've tried to generate the report using the backgroung excecution. Here the following message is shown: Job: Background Execution (ID: 1) Report unit: /Kostenanalyse_pro_Monat Quartz Job: ReportJobs.job_1 Quartz Trigger: ReportJobs.trigger_1_0 mondrian.olap.Query.getMdxHierarchiesOnAxis(I)[Lmondrian/olap/Hierarchy; java.lang.NoSuchMethodError: mondrian.olap.Query.getMdxHierarchiesOnAxis(I)[Lmondrian/olap/Hierarchy; at net.sf.jasperreports.olap.mondrian.JRMondrianResult.<init>(JRMondrianResult.java:60) at net.sf.jasperreports.olap.JRMondrianDataSource.<init>(JRMondrianDataSource.java:45) at net.sf.jasperreports.olap.JRMondrianQueryExecuter.createDatasource(JRMondrianQueryExecuter.java:89) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:682) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:614) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:892) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:716) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:568) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:320) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:254) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:299) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:277) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:148) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) I must also say that my analysis views are working well. So mondrian is running. It seems like there is a problem in the communication between jasperreports and mondrian. Has anybody a guess what problem this could be? Maybe Sherman has a idea? greetz jens

Yes you can do this with the combination of jasperserver and jasperreports. take a look at the example reports comming with jasperserver. there is one example where you can make such a drill down when you click on the name of an account manager. this works with the hyperlink tag, wich has to be set to report execution. hth jens

That would enhance security management a lot. The administrator would have the oportunity to filter the data of a query-input control through a join with a permission table. that would be great. We are using jasperserver 1.2.0 in combination with jasperanalysis and jasperreports. I've seen that a olap.report.datasource is implemented in JS 1.2.1. But Roles are not passed to the olap.datasource or is this feature implemented now? Greetz Jens

Hello, it would be great to have the opportunity to pass user informations to input controll query. Is there a way to handle this? Greetz Jens

If you are using jpivot interface you will have to define a query that uses to axis, Columns and Rows. So you have to put one dimension on columns and another on rows. for example you can put the measures on columns and your temps dimension on rows. hth, Jens Nöring

Hello, Maybe you should define your question more precise! What / if analysis can mean a lot. Do you need something like forecasting or which kind of what/if analysis do you need. With jasperserver you can run complex reprts you've built with jasperreports/ireport For example you can give a parameter to your report that let you specify a percentage of Turnover growth and than see what happens to your cost if the ratio of turnover to cost stay the same. But that is only one oppertunty. Precise your question for detailed informations. greetz, jens

ok installed Jasperserver 1.2 and tried to connect to my olap database. That is working well, but now the problem is, that the same error appears: defaultCloseOperation must be one of: DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, or DISPOSE_ON_CLOSE Maybe a java version problem? Installed JRE 1.6 Anybody got the same problem?

There are two things that could be the problem: First you should put the time dimension in the rows axis so that your query qould look like this: select {[Measures].avgTTC,[Measures].avgPrestHT,[Measures].avgAssurance} on columns, {[Time].[2006]} on rows from [Factures] The second thing is that you have to declare the fieldexpression in a special way: Measures: (Data[Measures].[avgTTC],?) for example. ',?' stands for the axis of the time dimension. If you want to use another axis you have to put one more ',?' to the expression. Make this for every measure your are using. Next for the Time dimension you need to declare the typ as mondrian.olap.Member This declaration is casesensitiv! Than create a java.lang.String variable with the expression $F{Time}.getName() If your field for the timedimension is namend 'Time' Than you should be able to run your report. With the measure fields to print the measures and the variable to print your choosen time on the report. Hope this helps you.

Update: I noticed the port for the jdbc connection to mysql was wrong. Updated it but nothing happend. greetz Jens Noering

Thanxx Sure, dont know why, but there was no Datasources.xml in the C:Programmejasperintelligence-1.1.0apache-tomcatwebappsjasperserverWEB-INF Folder. After I noticed that, I made my one one. Please take a look at it. As you can see in my folderdescription, i'm running the olap server on JI 1.1. Database is MySQL. MySQl Database is named olap. Olap Schema File Path = C:Programmejasperintelligence-1.1.0apache-tomcatwebappsjasperserverWEB-INFolappivot.xml Hope you can help me [file name=datasources-070fd19117e73a26dc22b6f58d2d77fc.xml size=554]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/datasources-070fd19117e73a26dc22b6f58d2d77fc.xml[/file]

Hi sure919, I already connected to JI trough ireport on a blank version(Samples installed) of JI (JR 1.2) with the foodmart and sugarcrm datasource, so the steps i've to make to connect are well known to me. But no I've to connect to our own olap database. And there is the problem that ireport shows me the correct provider and datasource, but no catalog appears in the drilldown box. So I'm able to connect to the databse through xml/a, but now catalog is found. But thanxx that you have taken a look at my problem. Did you connect to foodmart or to an own olap database? greetz jens noering Post edited by: jens_noering, at: 2007/02/28 09:24