Returns the product of the tuples set evaluating the numeric expression.
In our example, for each member of the set we multiply by 2.
Query
WITH
MEMBER [Measures].[Sum Amount] AS Prod( {[Geography].[Geo].[America],[Geography].[Geo].[America]}, 2.0 )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS 2.0 * 2.0
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Unless all values are empty, the Prod function will return zero if an empty value is evaluated and
the INCLUDEEMPTY is active.
Query
WITH
MEMBER [Measures].[Sum Amount] AS Prod( [Geography].[Geo].[City], [Measures].[Amount] )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS 0
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS Prod( [Geography].[Geo].[City], [Measures].[Amount], INCLUDEEMPTY )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Returns the product of the tuples set evaluating the numeric expression, excluding empty values.
Query
WITH
MEMBER [Measures].[Sum Amount] AS Prod( {[Geography].[Geo].[America],[Geography].[Geo].[America]}, [Amount], EXCLUDEEMPTY )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS Vector( {[Geography].[Geo].[America],[Geography].[Geo].[America]}, [Amount], EXCLUDEEMPTY )->product()
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Returns empty if all values are empty
Query
WITH
MEMBER [Measures].[Sum Amount] AS Prod( [Geography].[Geo].[City], NULL )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS NULL
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]
Assertion : Cell Equals
WITH
MEMBER [Measures].[Sum Amount] AS Prod( [Geography].[Geo].[City], NULL, EXCLUDEEMPTY )
SELECT
[Measures].[Sum Amount] ON 0
FROM
[Sales]