Essbase - Suppression of interdimensional irrelevance by splitting the database

Essbase Overview

About

Interdimensional irrelevance occurs when many members of a dimension are irrelevant across other dimensions.

Essbase defines irrelevant data as data that Essbase stores only at the summary (dimension) level.

Irrelevant data are known also as :

  • level based measure
  • measure stored in a dimension table

Solution

In such a situation, you may be able to :

Example : salaries

For example, TBC considered analyzing salaries as a member of the Measures dimension. But salary information often are stored as a dimension column. The salary typically represent one cell, with no reason to intersect with any other dimension.

An “X” in a cell indicates relevance. Only the Salary measure is relevant to individual employees.

Example of Interdimensional Irrelevance

Measures Joe Smith Mary Jones Mike Garcia All Employees
Revenue x
Variable Costs x
COGS x
Advertising x
Salaries x x x x
Fixed Costs x
Expenses x
Profit x

Because individual employee information is irrelevant to the other information in the database, and also because adding an Employee dimension would substantially increase database storage needs, TBC created a separate Human Resources (HR) database. The new HR database contains a group of related dimensions and includes salaries, benefits, insurance, and 401(k) plans.





Discover More
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...
Essbase Overview
Reasons to Split Databases

There are many reasons for splitting a database. For example, suppose that a company maintains an organizational database that contains several international subsidiaries in several time zones. Each...



Share this page:
Follow us:
Task Runner