Adding elements

You can add more elements to a business/report cube at any time to suit your requirements.

Adding a category

To add a category, follow the steps below:

1. In the Business/Report Cube Editor window, select the business/report cube (or any existing category) in the right panel, right-click and then click Add Category to display the Category Property dialog. See the dialog.

   

2. In the General tab, set the name and display name for the category in the Name and Display Name text fields. The name and display name must be unique at current level.
3. Type a description for the category in the Description text box if required, which will be shown when you hover the mouse pointer over the category in the Resource View panel of JReport Viewer.
4. Click the Security tab and set permission to the category as required (for details, see Configuring security).
5. Click OK. A new category will be added to the business/report cube (or a selected category). You can then add cube elements to it.

Adding a cube element

To add a cube element, take either of the following two ways:

• Adding via dialog
  1. Select the business/report cube or a category into which to add the cube element, right-click it and then select Add Cube Element from the shortcut menu to bring up the Add Cube Element dialog. See the dialog.

     

  2. In the General tab, decide the type of the cube element by selecting the corresponding item from the Type drop-down list. It can be Dimension, Measure or Detail Info.
  3. In the Name text field, specify the name of the cube element as required. The name must be unique at current level.
  4. Click the chooser button next to the Mapping Name text field to specify the mapping field of the cube element.
  5. Specify the display name of the cube element in the Display Name text field.

     By default, the display name is the same as the mapping name. You can change it according to your requirements. The display name must be unique at current level.

  6. If you choose to create a measure object, click the Aggregate Function drop-down list to specify the aggregate function for the object. However, if the measure object is mapped to a formula which references a dynamic summary, you are not allowed to specify the aggregate function for the object.
  7. Specify the tooltip and description of the cube element in the Tip and Description text boxes respectively if required, which will be shown when you hover the mouse pointer over the cube element in the Resource View panel of JReport Viewer.
  8. Click the Security tab and set permission to the cube element as required (for details, see Configuring security).
  9. When done, click OK to close the dialog.
• Adding by dragging

  In the Business/Report Cube Editor window, drag a table, DBField, formula or summary from the Resource Objects panel to the business/report cube or a category. Then, all DBFields in the table, the DBField, formula or summary will be added as cube element into the business/report cube or that category, and JReport will determine their types automatically.