OLAP Server User Guide
MDX Documentation
MDX Functions Reference

Generate

(MDX)

Applies to the first set members, all the members of the second set. Can also be used to concatenate strings.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  set-string-expression  one   
  string-expression  zero-one   
  ALL  zero-one   

Return

set-string

Description

For each member of the first parameter set:

1) If the second parameter is a set expression, concatenates its elements (union).
ALL can be used as third parameter to keep duplicate member/tuples.

2) If the second parameter is a string expression, concatenates those strings.
If a delimiter string is defined, it will be used as a separator.

See Also

Union

Examples

Special Examples (errors, null, ...)

XMLA Properties

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