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, 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, then in the Data Source dialog, select the data source to which to add the business cube and click OK.
   • 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.

   For a business cube, the Add Data dialog is displayed for you to add tables on which to create the business cube. If more than one table is added, the Query Editor window appears, in which you can select the table columns you want to use for the business cube and set up joins between the tables.

4. The Business/Report Cube Editor window appears. See the window.

   

5. Add elements to the business/report cube.
6. Define hierarchies on the business/report cube to allow end users to drill report data to particular dimensions.
7. Create some filters on the business/report cube to narrow down records.
8. Configure member-level security for 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.