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,
   • To add a business cube, 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 appears. See the window.

   

4. Add elements to the business/report cube.
5. Define hierarchies on the business/report cube to allow end users to drill report data to particular dimensions.
6. Create some filters on the business/report cube to narrow down records.
7. For a business cube, you can also set up joins between the tables added to it.
8. Configure member-level security on dimension objects in the business/report cube if necessary.
9. Click the Save button on the toolbar to save the business/report cube.
10. Click File > Close to close the window. The business/report cube will now have been added to the catalog.

See also Business Cube Editor window and Report Cube Editor window for additional help about options in each window.