Essbase - Outline (Database Outline)

Essbase Overview

About

Essbase Outline

An outline (also known as database outline) define the database design in a tree structure which define :

To display, create or modify the outline, you use Outline Editor in Essbase - Administration Services Console

Creating and changing database outline

The structure defined in the outline determines how data is stored in the database :

Documentation / Reference




Discover More
Essbase Overview
Essbase - (Dimension|Outline) Build

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file. When...
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
Essbase Overview
Essbase - Artifacts/Objects

Files that are related to are called : artifacts or objects. Database artifacts perform actions against one or more Essbase databases, such as : defining or reporting against data. In...
Essbase Overview
Essbase - Build Method

The build method has to be choose to perform a dimension build. The build method that you select : depends on the type of data in the data source and determines the algorithm that Essbase uses...
Essbase Overview
Essbase - Calculations

Essbase includes powerful calculation features for demanding analytic requirements. A rich library of functions makes it easy to define advanced and sophisticated business logic and relationships. Essbase...
Essbase Overview
Essbase - Cell

A cell is a part of a data block and represent a combination of the dense dimension members. Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the...
Member Relationship
Essbase - Child

child member in a database outline.
Essbase Data Load Rules Files
Essbase - Data Load Rules Files

Data Load Rules file is the second type of rules files which is involved in the data load process. A data source for data load must contain : not only the values that you want to load but also identification...
Outline For Optimized Query Times
Essbase - Designing an Outline to Optimize Query or Calculations Performance

The relative locations of dimensions in an outline can affect performance times : either or retrieval . Indeed, although they contain the same dimensions, the outline examples below : for Optimized...
Essbase Outline
Essbase - Dimension

in Essbase. A dimension represents the highest consolidation level in the database outline. The database outline presents dimensions and members in a tree structure to indicate a hierarchy relationship....



Share this page:
Follow us:
Task Runner