Work with General and Attribute-related Outline Properties
Outline properties-General tab shows what outline features are enabled for your cube and how they are formatted. Some fields on this tab can be changed and others cannot be changed and are for your information.
Table 11-1 General Outline Properties
| Field | Description | View or Edit |
|---|---|---|
| Allow Duplicate Member Names |
Enabling a cube for duplicate member names is an option when a new application is created. If you migrate an on-premises Essbase application with a unique member outline to an Essbase instance, you cannot change the outline to allow duplicate members. To allow duplicate member names in your Essbase instance, convert the on-premises unique member outline to a duplicate member outline before migrating the application. |
This field cannot be changed and is for your information. |
| Typed Measures Enabled | All Essbase applications are enabled for typed measures by default. | If typed measures is disabled and you want to enable it, select True. If typed measures is enabled, you cannot change the setting and this field is for your information. |
| Date Format | You can change the date format if you plan to use typed measures that are dates. | Use the dropdown list to select the date format that will be displayed when you query typed measures that are dates. |
| Auto configure dimension storage type | When "Auto configure dimension storage type" is enabled, the dimensions are set to dense or sparse automatically. When using this option, there is a limit of twenty four dimensions. This setting applies to block storage cubes only. | If auto configure is disabled and you want to enable it, select True. If auto configure is enabled and you want to disable it, select False. |
Table 11-2 Boolean, Date and Numeric
| Field | Description | View or Edit |
|---|---|---|
| True Member Name | Although your cube can contain more than one Boolean attribute dimension, all Boolean attribute dimensions will share the same value for True Member Name and False Member Name. By default, Essbase assigns member names of True and False. If you want to change these names, you must change them before you add the first Boolean attribute to your cube. Once the first Boolean attribute dimension is created, you cannot change these names. | This field can only be changed before you add the first Boolean attribute dimension to your cube. |
| False Member Name | Although your cube can contain more than one Boolean attribute dimension, all Boolean attribute dimensions will share the same value for True Member Name and False Member Name. By default, Essbase assigns member names of True and False. If you want to change these names, you must change them before you add the first Boolean attribute to your cube. Once the first Boolean attribute dimension is created, you cannot change these names. | This field can only be changed before you add the first Boolean attribute dimension to your cube. |
| Date Member Names | You can change the format of members of date attribute dimensions. | Select Month First or Day First formatting convention for Date Member Names. |
| Numeric Range | Members of numeric attribute dimensions can be defined in dimension build rules to represent date ranges. Here, you can define these ranges to be Top or Bottom of Ranges.
All numeric attribute dimensions built using ranges will have the same numeric range setting. |
Options are Tops of Ranges and Bottoms of Ranges. |
Table 11-3 Attribute Settings – Prefix and Suffix Format
| Field | Description | View or Edit |
|---|---|---|
| Value | A prefix or suffix may be required for your attribute member names to support member name uniqueness. Prefix or suffix values display when attribute dimension members are included in a query. | To enable prefix or suffix values for your cube, make a selection in the Value drop-down menu. The default value of None disables all prefix or suffix options. |
| Format | You can define unique names by attaching a prefix or suffix to member names in Boolean, date, and numeric attribute dimensions in the outline. | After selecting a prefix or suffix Value, such as Parent, you can select the format. |
| Separator | Select a separator (to place between the prefix or suffix and the original name). | Options are underscore ( _ ), pipe ( | ), or caret ( ^ ). |
Table 11-4 Calculation Dimension Names
| Field | Description | View or Edit |
|---|---|---|
| Name | Every Essbase cube containing attribute dimensions contains a dimension containing standard math functions that can be applied to attribute queries. You can edit the name of this dimension, and the name of each standard math function. You cannot change which math functions are automatically calculated. | Type a name for the attribute calculations dimension, if you want to change it. |
| Sum Member | This is a member of the attribute calculations dimension. The name to use when requesting sum data. | Type a name for the Sum member in the attribute calculations dimension, if you want to change it. |
| Count Member | This is a member of the attribute calculations dimension. The name to use when requesting count data. | Type a name for the Count member in the attribute calculations dimension, if you want to change it. |
| Minimum Member | This is a member of the attribute calculations dimension. The name to use when requesting minimum data. | Type a name for the Minimum member in the attribute calculations dimension, if you want to change it. |
| Maximum Member | This is a member of the attribute calculations dimension. The name to use when requesting maximum data. | Type a name for the Maximum member in the attribute calculations dimension, if you want to change it. |
| Average Member | This is a member of the attribute calculations dimension. The name to use when requesting average data. | Type a name for the Average member in the attribute calculations dimension, if you want to change it. |