Add Cube Element dialog

This dialog appears when you right-click a business/report cube in the Catalog Browser and select Add Cube Element from the shortcut menu. It helps you to add a new cube element into a business/report cube, and consists of the following tabs:

General tab
Security tab

General tab

Specifies properties of the cube element. See the tab.

Name

Specifies the name of the cube element.

Display Name

Specifies the display name of the cube element which is intuitive to the end user.

Mapping Name

Specifies the mapping name of the field to which the cube element is mapped. Click to select the field.

Type

Specifies the type of the cube element.

Dimension
Dimension objects are the cube elements that will become the basis for analyzing data in a report. They characteristically return text data or dates.
Measure
Measure objects are numeric cube elements that are calculated at the time the report is ran. The values they return are dependent on the dimension objects which they are used with. For example you may want a sales total by year.
Detail Info
Detail information objects provide additional information. They can be bound to dimension, measure or category. Detail information objects are not used for analysis but are useful to have.

Aggregate Function

Specifies the function of the measure object, available only when the type of the cube element is defined as measure object. It could be Count, Sum, Average, Maximum, Minimum, DistinctCount, PopulationStdDev, PopulationVariance, StdDev or Variance.

Note: When the measure object is mapped to a formula which references a dynamic summary, you are not allowed to specify the function for this measure object.

Tip

Specifies the tooltip of the cube element which will be shown when you hover the mouse pointer over the element in the Resource View panel of JReport Viewer.

Description

Specifies the description of the cube element which will be shown after the tooltip when you hover the mouse pointer over the element in the Resource View panel of JReport Viewer.

Security tab

Specifies principals' permissions to the cube element. See the tab.

Role tab

Lists all the roles for the current security policy.

Name
Displays role names.
Visible
Specifies whether or not the cube element is visible for the roles.

Group tab

Lists the groups for the current security policy.

Name
Displays group names.
Visible
Specifies whether or not the cube element is visible for the groups.

User tab

Lists the users for the current security policy.

Name
Displays user names.
Visible
Specifies whether or not the cube element is visible for the users.

Security Configuration

Opens the Security Configuration dialog to add or import principals - roles, groups and users to the cube element.

Applies all changes and closes the dialog.

Cancel

Does not retain changes and closes the dialog.

Help

Displays this help document.