Adding a business view

The most efficient way of creating a business view is by converting a report cube. To do this:

  1. In the Data tab of the Catalog Browser, locate a report cube, right-click it, then select Create Business View from the shortcut menu.
  2. A business view with the same name as the report cube will be added under the Business View node at the same level as the Report Cube node in the query. The predefined filters and hierarchy groups will also be kept in the business view.

Note: Do not use the Create Business View shortcut if there is already an existing business view. All web reports and library components built on the old business view may be destroyed.

You can also create a business view manually. 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 view.
  2. In the Data tab of the Catalog Browser, 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 business view will be based, right-click the Business View node and then click Add Business View.
  3. In the Input Business View Name dialog, enter a name for the business view, and then click OK. The Business View Editor window appears. See the window.
  4. Add elements to the business view.
  5. Define hierarchies on the business view to allow end users to drill report data to particular groups.
  6. Create some predefined filters on the business view to narrow down records.
  7. Configure member-level security for the business view if necessary.
  8. Click the Save button on the toolbar to save the business view.
  9. Click File > Close to close the window. The business view will now have been added to the catalog.