Defining Formula in OLATION®

Defining Formula in Olation^®

We will next cover how to define formulas within an Olation Cube. For this exercise, we will create a simple Internal Cube Formula that computes the value of Margin Pcnt (abbreviation for Margin Percent).

When writing a Cube formula in Olation, be aware of the correct formula syntax and terminologies:

Left Hand Side Expression (LHS) = Right Hand Side Expression (RHS);

Parameters explained below:

Parameter	Description
Left Hand Side or LHS	The defined expression or range where the calculation “goes.”
Right Hand Side or RHS	Contains a constant value, a mathematical expression, and may include Cube Functions and a Cube Reference.
Semi-colon (;)	Indicates the end of a particular Formula.

It is also important to understand the SYNTAX for each side (LHS and RHS).

Left Hand Side (LHS) or RANGE Reference

Qualifier{"Dimension Name.Member Name"}

Qualifier

Determines in what areas or intersections within the Cube the value will be returned.

The different types of Qualifiers are:
• All And {}

• Aggregates And {}

• Details And {}

{"Dimension Name.Member Name"}

This indicates the specific Dimension and Member that will be populated by the resulting values.

The QUALIFIERS

Below is a brief explanation of what the qualifiers are:

All And {}
- This qualifier indicates that LHS Range will apply to all intersections and cells within the Cube, both for Aggregate and Detail level cells.
Aggregates And {}
- This qualifier indicates that LHS Range will apply only to intersections or cells that are on an Aggregate level.
Details And {}
- This qualifier indicates that LHS Range will apply only to intersections or cells which are on a Detail level or the lowest level Members.

Right Hand Side (RHS) or CUBE Reference (where applicable)

"Cube Name".["Dimension Name.Member Name"]

"Cube Name".

This specifies the source Cube where the data or range from the RHS are coming from.

For Internal Cube Formulas, the Cube name is the same as the name of the active Cube. For cross-cube formulas, the Cube name is that of a different Cube.

{"Dimension Name.Member Name"}

This specifies the specific Dimension and Member or range from within the source Cube.

Note

You can write a COMMENT within the Formula Editor; these comments will be skipped or will not be read by Olation when parsing through the formula syntax.
To write a comment, use the symbols:

/*   - marks the start of the comment
*/   - marks the end of the comment
//   - indicates that the whole line will be read as a comment

Click the links to easily navigate to the corresponding sub-topics under this section.

Defining Formula in Olation®

Defining Formula in Olation^®