Add Cube Element dialog

This dialog appears when you,

Do any of the following in the Business Cube Editor or Report Cube Editor:
- Click Insert > Dimension/Measure/Detail.
- Click the Insert Dimension button , Insert Measure button or Insert Detail button .
- Right-click the business/report cube or a category and select Add Cube Element from the shortcut menu.
Right-click a business/report cube or a category and click Add Cube Element on the shortcut menu in the Catalog Browser resource tree.

It helps you to add a new cube element into a business/report cube, and consists of the following tabs:

General tab
Security tab

Applies all changes and closes the dialog.

Cancel

Does not retain changes and closes the dialog.

Help

Displays the help document about this feature.

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 runs. 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. For details about each function, see Math functions.

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 Page Report Studio.

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 Page Report Studio.

Security tab

Specifies user accessibility to members of the dimension objects in all the business/report cubes in current data source. See the tab.

For details about options in the tab, refer to Edit Business Cube Security dialog.