icCube

Documentation

Replicate

(MDX+)

Returns a set replicating n times the member or set parameter.

Parameters

Name Type Cardinality Default value
member|set  member-expression  one   
times  value-expression  one   

Return

set

Description

The function returns a set that is a 'times' replica of the first parameter that can
be a set or a member expression.

[Geography].[Geo].[ALL].Times(2) will return {[Geography].[Geo].[ALL], [Geography].[Geo].[ALL]}

Times( {[Geography].[Geo].[ALL], [Geography].[Geo].[ALL]}, 2) will return 4 times the member [ALL].

This function can be used with currentOrdinal to simulate a for loop.

See Also

Generate Vector CurrentOrdinal

Examples

Special Examples (errors, null, ...)

Since Version

6.0

XMLA Properties

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