View and Edit Outline Properties for a Newly Created Cube

Outline properties, in part, control the functionality available in an Essbase cube, but they also control member naming and member formatting for attribute dimensions, alias tables and text measures.

  1. Log into the web interface as a power user.
  2. On the Applications page, click Create to create a new application.
  3. Give the application a unique name.
  4. Name the cube.
  5. (Optional) Click Advanced Options to select a database type, allow duplicate member names, or enable scenarios.
  6. Click OK.
  7. On the Applications page, expand the new application.
  8. From the Actions menu, to the right of the cube name, select Outline.
  9. Click Edit.
  10. Click Outline Properties.

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 8-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 text measures that are dates.

Table 8-2 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 8-3 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 8-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.

Understand and Create Alias Tables

Aliases are stored in one or more tables as part of a database outline. An alias table maps a specific, named set of alias names to member names.

To create an alias table:

  1. On the Applications page, expand the application.
  2. Click the Actions menu to the right of the cube name and click Outline.
  3. Click Edit.
  4. Click Outline Properties.
  5. Select the Aliases tab.
  6. Enter the name of the alias table you want to create and click Add.

    You can have a maximum of 56 alias tables.

  7. Click Apply and Close.

See Create Aliases and Setting Aliases.

You cannot delete or rename the default alias table.

Understand and Create Textual Measures Outline Properties

Text measures serve as string masks for numeric values stored in Essbase.

Since all data stored in Essbase must be numeric, text measures provide the ability for users to select text strings as input to Essbase.

For example, assume that a user is to provide an input indicating risk assessment. It might be preferable to select from a list of strings: low, medium, high. To accomplish this in Essbase, you would create a textual measure list and assign the appropriate strings to numeric values stored in the database.

To add text measures:

  1. On the Applications page, expand the application.
  2. Click the Actions menu to the right of the cube name and click Outline.
  3. Click Edit.

    To view outline properties, simply click Outline Properties. You don't need to click Edit first.

  4. Click Outline Properties.
  5. Click Textual Measures.
  6. Type a text measure name and click Add.
  7. (Optional) Select Auto Generate IDs to automatically generate numeric IDs for the strings.
  8. (Optional) Rename the #Missing or #OutOfRange Names.
  9. Click Image of the plus sign icon..
  10. Assign a numeric ID (unless you auto-generated the IDs) and a string name.
  11. Repeat steps 4 & 5 until all strings are identified.
  12. Click Apply and Close.
  13. Click Save.

Once you have created a textual measure list, you can create a measure member on your outline and assign to it type “text.”

To select a text measure for a member, select the member and then select a text measure from the Type drop-down menu in the properties panel to the right of the outline. All text measures are shown with the prefix, "Text."