Essbase - Attribute dimensions

Essbase Overview


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. In the Sample.Basic database, for example, the Product dimension is associated with the Ounces attribute dimension. Members of the Ounces attribute dimension categorize products based on their size in ounces.

Essbase does not allocate storage for attribute dimension member. Instead, it dynamically calculates the members when the user requests data associated with them.

Attribute dimensions are always sparse dimensions. And you can associate attribute dimensions only with sparse standard dimensions

See Working with Attributes



In the figure below, Caffeinated, Intro Date, Ounces, Pkg Type and Population are attribute dimensions.

Sample.basic Database Outline Attribute

Through attribute dimensions, you group and analyze members of standard dimensions based on the member attributes (characteristics). For example, you can compare :

  • the profitability of noncaffeinated products that are packaged in glass
  • to the profitability of noncaffeinated products packaged in cans.


For example, the Pkg Type attribute dimension contains a member for each type of packaging, such as bottle or can, that applies to members of the Product dimension.

Recommended Pages
Essbase Overview
Essbase - (Consolidations|Aggregations)

Member consolidation Operators, determine how children roll up into their parents. Consolidation define how the data are aggregate. Consolidations are also known as aggregation rules. Consolidation...
Essbase Overview
Essbase - Attribute calculations

A calculations for a member of an attribute dimensions.
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Essbase Overview
Essbase - Dense and Sparse Dimension

Most data sets of multidimensional databases have two characteristics: Data is not smoothly and uniformly distributed. Data does not exist for the majority of member combinations. For example, all...
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....
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 Overview
Essbase - Outline Creation and Management using Outline Editor

This article provides an overview of creating outline using Outline Editor. For information Outline Editor, see the Oracle Essbase Administration Services Online Help. All examples in this chapter are...
Essbase Overview
Essbase - Shared Members

The data values associated with a shared member come from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once....
Essbase Outline Repetition Scenario
Essbase - Suppression of repetitions in Outline by adding a dimension

The repetition of elements in an outline often indicates a need to split dimension. The following examples show you how to avoid repetition. In the figure below, the left column, labeled “Repetition”,...

Share this page:
Follow us:
Task Runner