SHARE

SHARE calculates the ratio of an expression's value for the current dimension member to the value for a related member of the same dimension. Arguments to this function identify which related member is used in the ratio.

Return Value

NUMBER

Syntax

SHARE(expression OF {dimension | hierarchy} 
		share_clause [, share_clause]...
     )

Arguments

expression is a dimensional numeric expression.

dimension is a dimension of expression. The default hierarchy is used in the calculation. If you want to use a different hierarchy, use the hierarchy argument instead.

hierarchy is a level hierarchy of expression.

share_clause is one of the following keywords:

TOP: Top share is calculated as (current member/root ancestor * 100)
PARENT: Parent share is calculated as (current member/parent * 100)
LEVEL level: Level share is calculated as (current member/ancestor at specified level * 100)

Example

The following example calculates the percent share of Total Product for each product:

SHARE(GLOBAL.UNITS_CUBE.UNITS OF GLOBAL.PRODUCT.PRIMARY TOP)

The next example calculates the percent share of the parent member for each product:

SHARE(GLOBAL.UNITS_CUBE.UNITS OF GLOBAL.PRODUCT PARENT)