Essbase - Members

1 - About

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.

3 - Properties

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap