Edit Cube Element dialog

This dialog appears when you right-click any cube element of a business/report cube and select Edit from the shortcut menu in the Catalog Browser. It helps you to edit the specified cube element, and consists of the following tabs:

• General tab
• Security tab

General tab

Sets properties for 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
  Dimensions are the cube elements that will become the basis for analyzing data in a report. Dimensions characteristically return text data or dates.
• Measure
  Measures 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 provides additional information. It can be bound to dimension, measure or category. Detail information is not used for analysis but is useful to have.

Aggregate Function

Available only when the cube element is a measure object. It specifies the function for the measure object. It could be Count, Sum, Average, Maximum, Minimum, DistinctCount, PopulationStdDev, PopulationVariance, StdDev or Variance.

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 for the cube element. See the tab.

Role tab

Lists all the roles for the security policy.

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

Group tab

Lists all the groups for the security policy.

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

User tab

Lists all the users for the 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.

OK

Applies all changes and closes the dialog.

Cancel

Does not retain changes and closes the dialog.

Help

Displays this help document.