Essbase - Calculation Script

Essbase Overview

About

Essbase Calculations Script Process

Calculation scripts are text files that define how to calculate data in the database.

In a block storage database, they represent the second method of calculations after the basic outline calculations

Calculation scripts perform calculations different from the consolidations and mathematical operations that are defined in the database outline.

For example, you can calculate part of a database or copy values between members.

Because calculation scripts perform specific mathematical operations on member, they are typically associated with a particular database. You can, however, define a calculation script for use with multiple databases.

Calculation scripts files have a .csc extension.

The calculation processes of a single database can use any number of calculation scripts.

Oracle Hyperion Calculation Manager is a new tool which centralize the development of calculations for HFM, Essbase, and Planning.

Example

/* Turn off Intelligent Calculation */
SET UPDATECALC OFF;

/* Focus Calculation on Budget Scenario */
FIX (Budget)

/* Calculate discounts as 5% of Gross Sales */
"Discounts" = "Gross Sales" * .05;

/* Recalculate all dimensions except scenario */
CALC DIM ("Accounts", "Year Tot", "Customer", "Product");

/* End the focus on the Budget Scenario */
ENDFIX 

By default, Essbase calculates only data that changed since the prior calculation. In this example, intelligent calculation is disabled to force Essbase to recalculate data.

FIX statements enable you to limit your calculations on specific areas of the database. FIX statement end with an ENDFIX statement.

Documentation / Reference





Discover More
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
Essbase Overview
Essbase - Artifacts/Objects

Files that are related to are called : artifacts or objects. Database artifacts perform actions against one or more Essbase databases, such as : defining or reporting against data. In...
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...
Essbase Overview
Essbase - Data load in a parent member overwritten by consolidation

If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite...
Essbase Overview
Essbase - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
Essbase Overview
Essbase - Formulas

Formulas calculate relationships between member in the database outline. You can : apply formulas to members in the outline, or place formulas in a calculation script. This topic explains how TBC...
Essbase Overview
Essbase - Location Aliases

A location alias is a descriptor for a data source. A location alias maps an alias name for a database to the location of that database. A location alias specifies : an alias, a server, an application,...
Essbase Overview
Essbase - MDX

in Essbase. When creating formulas for an aggregate storage database, you use MDX. When the aggregate storage option was added to Essbase, MDX was chosen over the Calc Scripting Language in order to...
Essbase Outline
Essbase - Outline (Database Outline)

An outline (also known as database outline) define the database design in a tree structure which define : dimension member consolidations formulas and calculations scripts aliases, properties,...
Essbase Overview
Essbase - Servers

Essbase requires a server/computer to run a multi-threaded operating system so a server can efficiently manage simultaneous requests. Essbase server is also used in place of the essbase server agent which...



Share this page:
Follow us:
Task Runner