Replicate (MDX+)

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

Parameters

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

Replicate([Geography].[Geo].[All Regions],2)

{ 
  [Geography].[Geo].[All Regions], 
  [Geography].[Geo].[All Regions]
}

{[Geography].[Geo].[All Regions],[Geography].[Geo].[All Regions]}

[Geography].[Geo].[All Regions].Replicate(2)

Replicate({[Geography].[Geo].[America],[Geography].[Geo].[America]},2)

{ 
  [Geography].[Geo].[Continent].[America], 
  [Geography].[Geo].[Continent].[America], 
  [Geography].[Geo].[Continent].[America], 
  [Geography].[Geo].[Continent].[America]
}

{[Geography].[Geo].[America],[Geography].[Geo].[America],[Geography].[Geo].[America],[Geography].[Geo].[America]}

{[Geography].[Geo].[America],[Geography].[Geo].[America]}.Replicate(2)

Vector( Replicate([Geography].[Geo].[America],5) as t, t.currentOrdinal /* like the i of a for (i) loop */ )

VectorN(1,2,3,4,5)

Special Examples (errors, null, ...)

Replicate(NULL,2)

{}

Replicate([Geography].[Geo].[America],0)

Replicate([Geography].[Geo].[America],-1)

Since Version

6.0

XMLA Properties

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