You use Outline Editor to manage outlines. For information about outlines, dimensions, and members, see the Oracle Essbase Database Administrator's Guide.
You can also use rules files to create and maintain outlines from data sources such as flat files or relational databases. For information about data loading and dimension building, see the Oracle Essbase Database Administrator's Guide.
To use Outline Editor to create and manage an outline:
After creating a database, open the outline in Outline Editor.
Populate the outline by copying an existing outline or by using Outline Editor to add dimensions and members.
Set whether names are case-sensitive.
Set the active alias table and manage alias tables.
If relevant, define the format for members of attribute dimensions.
Define the following dimension and member properties and characteristics:
The data storage for each dimension as dense or sparse (block storage outlines only).
Member storage properties (block storage outlines only).
Optional: Define the following dimension and member properties and characteristics:
Tag the time dimension (block storage outlines only).
Enable dynamic time series members (block storage outlines only).
Set variance reporting properties (block storage outlines only).
Set two-pass calculation properties (block storage outlines only).
Create formulas for specific members (different for aggregate storage outlines).
Define attribute dimensions, associate attribute dimensions with their base dimensions, and associate attributes to specific members.
If relevant, prepare the outline for currency conversion (block storage outlines only).
Optional: Create alias tables and define aliases.
Sort members to maximize performance.
“Case Study: Designing a Single-Server, Multidimensional Database” in the Oracle Essbase Database Administrator's Guide