Essbase - Dimension

1 - About

Dimensional Data Modeling - Dimension (Perspective) 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.

For example, below, Hierarchical Structure:

  • Year, Accounts, Scenario, Product are a dimension
  • Qtr1 is a member of the Dimension Year (of type Time)

3 - Dimension Type

Essbase has two main type of dimension :

  • standard dimensions. Standard dimensions represent the core dimensions (Time, Account, Scenario)

Essbase - How to determine if the dimension must be of a type standard or attribute ?

4 - Properties of dimensions

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

4.1 - Dimension type

When you tag a dimension as a specific type, the dimension can access built-in functionality designed for that type.

For example, if you define a dimension as accounts, you can specify accounting measures for members in that dimension. Essbase calculates the two primary dimension types, time and accounts, before other dimensions in the database. By default, all dimensions are tagged as none.

Dimension type:

  • None

Specifies no particular dimension type. Default.

Defines the time periods for which you report and update data. You can tag only one dimension as time. The time dimension enables several accounts dimension functions, such as first and last time balances.

Contains items that you want to measure, such as profit and inventory, and makes Essbase built-in accounting functionality available. Only one dimension can be defined as accounts.

Contains members that can be used to classify members of another, associated dimension. See attribute dimension

Contains data about where business activities take place. In a country dimension, you can specify the currency used in each member. For example, Canada has three markets—Vancouver, Toronto, and Montreal, which use the same currency, Canadian dollars.

Separates local currency members from the base currency defined in the application. This dimension type is used only in the main database and is only for currency conversion applications. The base currency for analysis may be U.S. dollars, and the local currency members may contain values that are based on the currency type of their region.

Example


Database:Design
   Year (Type: time)
   Measures (Type: accounts)
   Product
   Market
   Scenario
   Pkg Type (Type: attribute)
   Ounces (Type: attribute)


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap