Essbase - Suppression of repetitions in Outline by adding a dimension

Essbase Overview

About

The repetition of elements in an outline often indicates a need to split dimension. The following examples show you how to avoid repetition.

Eliminating Repetition By Creating a

Scenario Dimension

In the figure below, the left column, labeled “Repetition”, shows Profit, Margin, Sales, COGS, and Expenses repeated under Budget and Actual in the Accounts dimension.

The right column, labeled “No Repetition”, separates Budget and Actual into another dimension (Scenario), leaving just one set of Profit, Margin, Sales, COGS, and Expenses members in the Accounts dimension. This approach simplifies the outline and provides a simpler view of the budget and actual figures of the other dimensions in the database.

Essbase Outline Repetition Scenario

Attribute Dimension

In the figure below, the left column, labeled “Repetition”, uses shared members in the Diet dimension to analyze diet beverages. Members 100–20, 200–20, and 300–20 are repeated: once under Diet, and once under their respective parents.

The right column, labeled “No Repetition”, simplifies the outline by creating a Diet attribute dimensions of type Boolean (True or False). All members are shown only once, under their respective parents, and are tagged with the appropriate attribute (“Diet: True” or “Diet: False”).

Essbase Outline Repetition Attribute





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...



Share this page:
Follow us:
Task Runner