You use the Properties tab of Outline Editor to view and edit the following types of outline properties:
Case-sensitivity
Alias table settings
Uniqueness requirement for member names
Attribute settings
Dimension storage types
Note: | The contents of the tab differ, depending upon whether you are working with a block storage or an aggregate storage outline. |
The following nodes apply to database properties:
Case sensitive members—Specifies whether member names and UDAs are case sensitive. For example, if you select true, Product and product represent two members, and, if you select false, Product and product represent one member.
Outline type—Specifies aggregate storage or block storage or currency. The setting was defined when the database was created and cannot be changed.
Duplicate member names allowed—Identifies true (if the outline is enabled for duplicate member names) or false (if unique member names are required). You can change false to true but cannot change true to false.
Alias tables—Lists the alias tables that are associated with the outline. The alias table named Default is listed first. You right-click the node to display a menu that enables you to create, delete or clear alias tables.You right-click a table name to perform actions on the selected table or to import or export a table.
The “Attribute settings” node applies only to attribute dimensions. To define how Essbase handles names in attribute dimensions, specify the following properties:
Prefix/Suffix format—You select None (to present member names without prefixes or suffixes), or you perform the following actions:
Select Value.
Select a prefix or suffix value: Dimension, Parent, Grandparent, or Ancestors.
Select a separator (to place between the prefix or suffix and the original name): underscore ( _ ), pipe ( | ) , or caret.( ^ ).
Select Prefix or Suffix.
Note: | You use prefixes or suffixes to ensure that member names are unique. By default, attribute member names do not include prefixes or suffixes. |
Calculation dimension names—You specify a name for the Attribute Calculations dimension or for any member of the Attribute Calculations dimension. The specified names are used in reports and spreadsheets. Member functions are not affected by member names. For example, no matter what its name, the second member of the Attribute Calculations dimension counts. For block storage databases, the default names are Sum, Count, Min, Max, and Avg. For aggregate storage databases, only the Sum member is used.
Boolean, date, and numeric attribute settings—You specify member-name formats:
For Boolean dimensions, for example, specify Yes for true and No for false.
For date attribute dimensions, select Month First (mm-dd-yyyy) or Day First (dd-mm-yyyy).
For numeric dimensions, select “Bottoms of ranges” or “Tops or ranges,” and specify one or more values. For example, if you select “Tops of ranges” and specify the attributes 1000, 100000, and 1000000, the ranges are 0-1000, 1001-100000, and 100001-1000000.
For the dimensions of block storage databases, in the “Data storage” node, you can set a storage property—Auto configure or Dimension storage types. If the “Auto configure” option is selected, Essbase designates dimensions as dense (containing values for most intersections) or sparse (containing values for relatively few intersections). If “Auto configure” is not selected, you can, for user-created dimensions, in the “Dimension storage types” node, select Dense of Sparse. By default, attribute dimensions are permanently set as sparse. You can change underlined settings (by clicking their values).
“Creating and Changing Database Outlines” in the Oracle Essbase Database Administrator's Guide