Views
JasperAnalysis
From Wiki
Welcome to JasperAnalysis
JasperAnalysis is an extension of JasperServer that adds Online Analytical Processing (OLAP) using existing relational databases. An OLAP engine (based on the Mondrian open source project) is used to connect to databases, query using MDX (OLAP specific language), and return OLAP results. A web based user interface based on JPivot (an open source project related to Mondrian) allows end users to interact with the OLAP information without knowing MDX.
JasperAnalysis integrates the underlying OLAP components around the JasperServer repository, security and administration services to provide a complete OLAP environment.
- JasperServer reports can use OLAP data sources
- JasperSoft ODBO Connect allows Excel Pivot Tables to use JasperAnalysis as an OLAP data source in an interface business analysts are familiar with
- The JasperAnalysis Professional edition adds user interface and security features and commercial support benefits to JasperAnalysis Community Edition. See JasperAnalysis Professional
Starting with JasperAnalysis
JasperAnalysis needs to be configured with your database. A Mondrian schema is a XML file that defines the relationships in your database (metadata) that are to be used in OLAP processing. The Schema Workbench is a desktop tool that allows you to develop and test a schema. The workbench can be downloaded here: JasperAnalysis Workbench download.
The workbench download includes Mondrian documentation that explains schemas and terminology.
To use the workbench, you can proceed with:
- unzip the workbench ZIP file
- put your database JDBC driver in the /drivers directory
- start the workbench
- set your JDBC driver class, URL, user name and password of your cube database under Preferences in the workbench
- Create a new schema
- Add the elements to the schema by right clicking, and change the details in the right hand panel
- You can test the schema by running MDX queries against the schema
- Once you are happy with the schema, you can add it into JasperServer through the user interface, and add analysis views with your starting MDX. See the JasperServer administration guide for details.