Essbase - Members

Essbase Overview


Dimensional Data Modeling - Member

Members are the individual components of a dimension.

For example:

  • the members of a Region dimension can be East, West, South, and Total US.
  • Product A, Product B, and Product C might be members of the Product dimension.

Each member has a unique name.

The data associated with a member can be :

  • stored (referred to as a stored member ),
  • or dynamically calculated when a user retrieves it

The members may consist of other members and then represent a hierarchy.

When you create a dimension, you tell Essbase how to consolidate the values of its individual members. A consolidation is a group of members in a branch of the tree.

In Essbase, member combinations are denoted by the cross-dimensional operator. The symbol for the cross-dimensional operator is →, so July → Product A denotes the block for July and Product A. The intersection of July, Product A, and France is written July → Product A → France.


The properties of members define the roles of the members in the design of the multidimensional structure.

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 - (Parent-Child|Dimension Reference) Build Method

A parent-child reference build method is aimed to : Create shared members that roll up into different generations Share non-level 0 members Modify properties of existing dimensions and members ...
Essbase Overview
Essbase - Attribute calculations

A calculations for a member of an attribute dimensions.
Sample.basic Database Outline Attribute
Essbase - Attribute dimensions

An attribute dimension is a special type of dimension that is associated with a standard dimensions. Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions....
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 Calculations Script Process
Essbase - Calculation Script

Calculation scripts are text files that define how to calculate data in the database. In a block storage database, they represent the second method of calculations after the basic outline calculations...
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...
Member Relationship
Essbase - Child

child member in a database outline.
Tbc Product Dimension
Essbase - Consolidation Operator

The consolidations operator define the consolidation path and can be used in formulas. It defines how Essbase rolls up data for each member in a branch to the parent. Operator Representation Description...
Essbase Overview
Essbase - Consolidation Storage Properties

Data storage properties define where and when consolidations are stored. For example, by default, members are tagged as store data. Essbase sums the values of store data members and stores the result...

Share this page:
Follow us:
Task Runner