Essbase - Two-Pass Calculations

Essbase Overview

About

This label indicates that some member Essbase - Formulas must be calculated twice to produce the desired value.

The two-pass property works only :

  • on members of the dimension tagged as account
  • and on members tagged as Dynamic Calc and Dynamic Calc and Store.

Example

The following example illustrates why Profit % (based on the formula Profit % Sales) has a two-pass tag.

Tbc Measures Dimension

The tables have five columns (column headers are labeled left to right as Dimension, Jan, Feb, Mar, and Qtr1) and three rows (labeled as Profit, Sales, and Profit %). Jan, Feb, Mar, and Qtr1 are members of the Year dimension. Profit, Sales, and Profit % are members of the Measures (accounts) dimension.

Data Loaded into Essbase defines the initial data to load into Essbase.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100
Sales 1000 1000 1000
Profit %

First, Essbase calculates the Measures dimension.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100
Sales 1000 1000 1000
Profit % 10% 10% 10%

Next, Essbase calculates the Year dimension. The data rolls up across the dimension.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100 300
Sales 1000 1000 1000 3000
Profit % 10% 10% 10% 30%

The data values for Profit → Qtr1 (300) and Sales → Qtr1 (3000) are correct but the data value for Profit % → Qtr1 (30%) is incorrect because Profit % is tagged as a two-pass calculation.

Essbase then recalculates profit percentage at each occurrence of the member Profit %.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100 300
Sales 1000 1000 1000 3000
Profit % 10% 10% 10% 10%

The data value for Profit % → Qtr1 (10%) is correct after the second pass.





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

Essbase includes powerful calculation features for demanding analytic requirements. A rich library of functions makes it easy to define advanced and sophisticated business logic and relationships. Essbase...
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 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 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