CONSOL

Syntax

CONSOL (Dimension, Data)

Description

The CONSOL function returns the value of Data for the total member of Dimension.

Returns

The value of Data for the total member of Dimension.

Example

Suppose an analytic model contains a data cube called SALES that uses a dimension called PRODUCTS. Use the following formula to calculate each product's sales as a percentage of total sales:

SALES / CONSOL(PRODUCTS, SALES)

This formula divides each product's sales by the consolidated value for SALES.