6 Create and Manage Cube Outlines Using the Web Interface

An Essbase outline defines the structure of the cube through dimensions, members, attributes, and their properties. The outline structure, along with consolidation operators and formulas, determines how data is stored and calculated.

Dimensions and members represent data hierarchies. In an outline, each dimension consists of one or more members. The members, in turn, may have child members. This ancestral rollup is called a hierarchy. Unary operators (such as +, -, *, /), assigned to each member in a hierarchy define how a child member consolidates to its parent.

Note:

To migrate an existing cube outline to Essbase 21c, use a migration tool. See About Migration Tools and Use Cases. Do not copy the .otl file to migrate an outline to 21c.

Prerequisite: Import a cube from the gallery. The topics in this chapter assume you have built or imported Sample Basic. If you aren’t a power user, ask one to create an application for you and provision you as Database Manager for the application.

• View and Edit Outline Properties for a Newly Created Cube

• Add Dimensions and Members to Outlines

• Name Generations and Levels
• Restructure Cubes

• Create Attribute Dimensions and Members

• About Duplicate Member Names

• Set Dimension and Member Properties
• Select the Member Properties to Display in the Outline
• Compare Outlines
• Copy and Paste Members Within and Between Outlines