1. Using Oracle Essbase
  2. Application Workbooks Reference
  3. Understand the Cube.Settings Worksheet
  4. Understand the Cube.Settings Worksheet: Attribute Settings

Understand the Cube.Settings Worksheet: Attribute Settings

The following table shows the fields, values and descriptions for the Attribute Settings section on the Cube.Setting worksheet:

Table A-4 Attribute Settings

Property or Field Valid Values Description
Dimension Name Default: Attributes Calculation

To avoid duplicating names in an outline, you can change the names of members of the attribute calculations dimension. Regardless of the name that you use for a member, the function of the member remains the same. For example, the Sum member always calculates a sum, no matter what you name it.

See Changing the Member Names of the Attribute Calculations Dimension.

Sum Member Default: Sum

This is a member of the attribute calculations dimension. The name to use when requesting sum data.
Count Member Default: Count

This is a member of the attribute calculations dimension. The name to use when requesting count data.
Minimum Member Default: Min

This is a member of the attribute calculations dimension. The name to use when requesting minimum data.
Maximum Member Default: Max

This is a member of the attribute calculations dimension. The name to use when requesting maximum data.
Average Member Default: Avg

This is a member of the attribute calculations dimension. The name to use when requesting average data.
False Member Default: False

The initial Boolean member names in a cube are set as True and False.

See Setting Boolean Attribute Member Names.

True Member Default: True

The initial Boolean member names in a cube are set as True and False.

See Setting Boolean Attribute Member Names.

Prefix/Suffix Value
  • None
  • Dimension
  • Parent
  • Grandparent
  • Ancestors

See Setting Prefix and Suffix Formats for Member Names of Attribute Dimensions.

Prefix/Suffix Format
  • Prefix
  • Suffix

You can define unique names by attaching a prefix or suffix to member names in Boolean, date, and numeric attribute dimensions in the outline.

See Setting Prefix and Suffix Formats for Member Names of Attribute Dimensions.

Prefix/Suffix Separator
  • _ Underscore
  • | Pipe
  • ^ Carat

You can define unique names by attaching a prefix or suffix to member names in Boolean, date, and numeric attribute dimensions in the outline.

Select a separator (to place between the prefix or suffix and the original name): underscore ( _ ), pipe ( | ) , or caret.( ^ ).
Attribute Numeric Ranges
  • Tops of ranges
  • Bottoms of ranges

See Setting Up Member Names Representing Ranges of Values.

Date Member
  • Month First (mm-dd-yyyy)
  • Day First (dd-mm-yyyy)

You can change the format of members of date attribute dimensions. See Changing the Member Names in Date Attribute Dimensions.

You can modify the Attribute Settings section on the Cube.Settings worksheet in the Designer Panel. See Work with the Cube.Settings Worksheet: Attribute Settings in Cube Designer.