Essbase - Standard dimensions

Essbase Overview

About

Standard dimensions represent the core components of a business plan and often relate to departmental functions.

Typical standard dimensions: :

  • Time,
  • Accounts (The Measure dimension),
  • Scenario (The formula dimension),
  • Product Line,
  • Market,
  • and Division.

Dimensions change less frequently than members.

Essbase allocate storage for standard dimension members.

Article Related





Discover More
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 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 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 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 Short Cycle
Essbase - The OLAP Design Cycle (to create an optimized database)

A contains two types of values : the values that you enter or load (input data) and the values that are calculated from the input data (calculated data) Then a typical conforms to the following...
Cube Representing Three Database Dimensions
Essbase - User Requirement to determine the Dimension and Members

The analyze of the user requirement must determine the and . The number of members needed to describe a potential data point should determine the number of dimensions. To ensure that the design meets...



Share this page:
Follow us:
Task Runner