Adding a business/report cube

To add a business/report cube to a catalog, follow the steps below:

1. In JReport Designer, click File > Catalog Management > Open Catalog to open the catalog to which you want to add the business/report cube.
2. In the Data tab of the Catalog Browser, expand the desired data source, then the Relational node in the data source. In the connection node, right-click the Business Cubes node, and select Add Business Cube from the shortcut menu. Or, on the main menu bar, click File > New > Business Cube.

   To add a report cube, expand the Imported SQLs, Stored Procedures, User Defined or Queries node in the desired data source of the catalog, select the source on which the report cube will be based, right-click its Report Cube node and then click Add Report Cube.

3. In the Input Business/Report Cube Name dialog, enter a name for the business/report cube, and then click OK. The Business/Report Cube Editor window is then displayed.
4. Add elements to the business/report cube and configure security on the elements.
5. Define hierarchies on the business/report cube to allow end users to drill report data down to particular dimensions.
6. Create some filters on the business/report cube to narrow down records if required.
7. For a business cube, you can also set up joins among the tables added to it.
8. Click the Save button on the toolbar of the window to save it.
9. Click File > Close to close the window. The business/report cube will now have been added to the catalog.