From Wiki
Welcome to Jaspersoft OLAP
Jaspersoft OLAP is an extension of JasperReports Server 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.
Jaspersoft OLAP integrates the underlying OLAP components around the JasperReports Server repository, security and administration services to provide a complete OLAP environment.
- JasperReports Server reports can use OLAP data sources
- JasperSoft ODBO Connect allows Excel Pivot Tables to use Jaspersoft OLAP as an OLAP data source in an interface business analysts are familiar with
- The Jaspersoft OLAP Professional edition adds user interface and security features and commercial support benefits to Jaspersoft OLAP Community Edition. See Jaspersoft OLAP
Starting with Jaspersoft OLAP
Jaspersoft OLAP 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: Jaspersoft OLAP 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 JasperReports Server through the user interface, and add analysis views with your starting MDX. See the JasperReports Server administration guide for details.
JSPWikiNotice
