icCube

Documentation

Prod

(MDX+)

Returns the product of all values of the specified set expression.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
value  numeric-expression  one   
flag  EXCLUDEEMPTY|INCLUDEEMPTY  zero-one  INCLUDEEMPTY 

Return

value

Description

Returns the product of all values of the specified set, evaluated using 'value-expression'.

The Prod function will return a double numeric value if the value-expression is an integer value. if an evaluated
value is Zero it will stop iterating an return this zero value.

EXCLUDEEMPTY, will ignore NULL values. INCLUDEEMPTY, will convert NULL value to Zero (if a non value exists).

If no numeric expression is specified, the current members context will be used to evaluate the tuples.

See Also

Avg Min Median Max Sum Vector

Examples

Special Examples (errors, null, ...)

Since Version

6.0

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.