Generate analysis view in jasperserver

[kevinchristian]

 Hello Everybody,

I have just started learing the jasper server and iReport analysis and reporting tool. I have successfully created simple reports using iReport and am able to view them from jasper server repository on jasper server browser.

As I was going through the JasperServer Documentation to read on "How to Create Analysis View?". I really got confused from where to start. Can anyone please help me on this? I will simplify my problem.

I have installed "jasperserver-ce-3.7.0-RC-windows-installer.exe" and "iReport-3.7.0-windows-installer.exe". I have "Oracle 9i" DBMS installed on my machine. [All applications are installed on the same machine(Server).]

Database Schema:

Employee: EmpID, EmpName

EmpWork: EmpID, Month, HoursWorked

From iReport, I can create report of (list of employees etc) using SQL and JDBC connecter (ojdbc.jar).

Now I want to use the analysis view to create multidimensional report with Employee Name(JOHN, MARK, KANT....) in rows and Months(JAN, FEB, MAR...) in Columns such that each cell value show the number of hours worked by an employee in a month.

Can anyone please guide me to resolve the issue mentioned above??

 

Thanks

Kevin Christian

[kevinchristian]

 Anyone please guide me on the above problem.

I am not able to create analysis view in Jasper Server. Do I need to learn MDX query language or Mondrian tool or anything else. I dont know from where to start.

Thanks in Advance.

Kevin Christian

[kevinchristian]

I have tried running Mondrian application(http://localhost:8080/mondrian) from JasperServer/mondrian-3.1.4.jar. But I can not run it. Do I really need Mondrian application to create OLAP schema? or is there any other way for creating multidimensional report from Oracle Database.

I have also tried JasperETL, but not able to start it due to Incompatible JVM error.

Am I going in the right direction or not?

Please guide me.

[svenn]

Try posting your question to one of these forums

http://jasperforge.org/projects/jasperserver/forum

This forum is for iReport development