Outlines are composed of members. The top level members of an outline are called dimensions. There are two types of dimensions: standard dimensions and attribute dimensions. For more information about dimensions, see the Oracle Essbase Database Administrator's Guide.
Dimension names must always be unique in the outline, even if the outline allows duplicate member names.
The position of dimensions in an outline can affect performance. For information about designing an outline to optimize performance, see the Oracle Essbase Database Administrator's Guide.
Note: | If you add, delete, or change dimensions and then save the outline, Essbase needs to restructure your database. After the restructuring is complete, you must recalculate the data. |
To add a dimension to an outline:
Perform an action:
If the outline does not contain members, right-click the Outline:<database name> node and select Add child.
If the outline contains members, right-click an existing dimension and select Add sibling.
Enter the dimension name, following the proper naming rules, and press Enter.
After you press Enter, a new text box is displayed, ready for you to add a sibling member. To close the text box without entering a name, press Esc.
For block storage outlines, change the storage configuration of the dimension, if necessary.
Define other dimension properties, as needed.
Consider the effects of the position of the dimension in the outline and position the dimension.
For information about designing an outline to optimize performance, see the Oracle Essbase Database Administrator's Guide.