Business Intelligence

Now Reading

Jmagallanes

Next
Prev

Review

Jmagallanes

Overview

Synopsis

The open source project JMagallanes is an end user application for Olap and Dynamic Reports written in Java/J2EE.

Category

Business Intelligence Open Source

Features

• Written entirely in Java
• Execution available for J2SE and J2EE
• Visualization of reports in pivot tables, static reports (Using JasperReports), and charts
• High adaptation capability. Data integration with JDBC
• Consolidation of multiple data sources in one single report
• Calculated columns
• Drilldown to new cubes, static reports, or even web pages
• Internationalize
• Report caching and cache expiration for "precalculated" use
• Export cubes to use and analyze them off-line
• PDF and Excel outputs
• Programmed report calculation and execution. It sends the results by mail automatically
• Wizard to generate the cube definitions from a SQL query
• Automatic static report layout generation tool, to complete with the use of IReport

License

Open Source

Price

Free

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)

Company

Jmagallanes

PAT Rating™

Editor Rating

Aggregated User Rating

Rate Here

Ease of use

8.5

7.4

Features & Functionality

8.3

6.2

Advanced Features

8.4

8.2

Integration

8.5

—

Performance

8.3

—

Training

7.6

Customer Support

8.4

7.8

Implementation

9.2

Renew & Recommend

Bottom Line

JMagallanes combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports.

8.4

Editor Rating

8.4

Aggregated User Rating

3 ratings

You have rated this

The open source project JMagallanes is an end user application for Olap and Dynamic Reports written in Java/J2EE. It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports. With this initial deploy, it is possible to use all the features offered by the tool, also making users’ own reports.

JMagallanes Project contains different products which provide an extensive platform for the analysis of company's information. The open source software JMagallanes Olap and Reports is one of them. But the project also has other products, which still are not open source, and are offered as a part of the JMagallanes Project.

This additional components are JMagallanes Datawarehouse and JMagallanes Web. JMagallanes Datawarehouse is an extension for the Olap & Reports product, which allows the user to work efficiently with large data sources. This tool uses a data base server (which may be embedded or external), to create a datawarehouse repository of the report data, resulting in a much more efficient use of the information.

The access to data is direct and an intelligent query mechanism discards the unnecessary information to reduce significantly the memory usage, process usage, and response time. JMagallanes Web is a web interface for the reports of JMagallanes Olap & Reports. Is based in the JPivot tool and presents a dynamic, flexible and light visualization without extra requirements for the client. This application runs over any web server supporting java (JSP) like Tomcat. It uses the flexibility of JPS, JavaScript and HTML itself to generate a visualization of the pivot table, without losing the functionality of the Swing interface.