Table of Contents

Essbase - Formulas

About

Formulas calculate relationships between member in the database outline. You can :

This topic explains how TBC optimized the performance of its database by using formulas.

Formulas comprise :

Article Related

Operators

Essbase supports the following operators:

Example

The Measures dimension uses the following formulas:

Essbase uses Essbase - Consolidation Operator to calculate the Margin, Total Expenses, and Profit members :

In the Profit per Ounce formula, the @NAME function is also used to process the string “Ounces” for the @ATTRIBUTEVAL function.

Documentation / Reference