After creating and organizing a database outline, you can define properties for dimensions and members in the outline. Properties define how dimensions and members are stored, calculated, and consolidated.
You can set some properties in common for multiple dimensions and members. If multiple members are selected and you change a property, the change is applied to all selected members.
To set properties for dimensions and members:
The Outline tab displays the outline in the form of a hierarchical outline tree.
Right-click one or more dimensions or members for which you want to set properties, and select Edit member properties.
In the Member Properties dialog box, select the appropriate tab and edit properties, as desired. If multiple dimensions or members are selected, not all properties are editable. Editable property fields are underlined.
Note:
For block storage databases, the dimension storage property (dense or sparse) is not editable in this dialog box. See Setting Dimensions as Dense or Sparse for instructions to change this setting.
To save changes, click OK, click Next or Prev, or select a different tab in the Member Properties dialog box.
To undo changes made since this tab was opened for the current member, click Cancel.
“Setting Dimension and Member Properties” in the Oracle Essbase Database Administrator's Guide