Essbase - Dimension

Essbase Overview

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)

Essbase Outline

Dimension Type

Essbase has two main type of dimension :

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

Properties of dimensions

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

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)





Discover More
Essbase Overview
Essbase - (Accounts|Measures) Dimensions

Accounts dimensions are dimension that contains items that you want tomeasure, and makes Essbase built-in accounting functionality available. Accounting classifications. Ex: income expense profit...
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 - 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 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...
Essbase Data Source Kinds Of Fields
Essbase - Dimension Field

Dimension Field is a component of a which can contain also : , Dimension fields identify the dimensions of the database, such as Market. Use dimension fields to tell Essbase the order of the...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...
Essbase Generation
Essbase - Generation

generation relationship of the members in a database outline. Generation refers to a consolidation level within a dimension.
Essbase Outline
Essbase - Hierarchies

Essbase uses the concept of member to represent data hierarchies. Dimension contain Member, which you can nest inside of other members in a Hierarchies. Hierarchies also define the relationship that...
Essbase Overview
Essbase - Members

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...
Essbase Outline
Essbase - Outline (Database Outline)

An outline (also known as database outline) define the database design in a tree structure which define : dimension member consolidations formulas and calculations scripts aliases, properties,...



Share this page:
Follow us:
Task Runner