THISCUBE

Syntax

THISCUBE ()

Description

The THISCUBE function returns a reference to the current calculating data cube in a user function.

Returns

A reference to the current calculating data cube in a user function.

Example

CHANGE(MONTHS, THISCUBE())

The user function in this example calculates the monthly change for each data cube and is used inside an aggregate override user function that affects the SALES, COST_OF_GOODS, and GROSS_MARGIN data cubes.

In this example, the analytic calculation engine performs the same as if you entered these three functions:

• CHANGE(MONTHS, SALES)

• CHANGE(MONTHS, COST_OF_GOODS)

• CHANGE(MONTHS, GROSS_MARGIN)