/
Generate
Document toolboxDocument toolbox

Support center for flex.bi version 3.2

Generate

Owned by Gvido
Sept 01, 2016

Applies a set to each member of another set, and then joins the resulting sets by union. Alternatively, this function returns a concatenated string created by evaluating a string expression over a set.

Syntax

Set expression syntax
	Generate( Set_Expression1 ,  Set_Expression2 , ALL )

String expression syntax
	Generate( Set_Expression1 ,  String_Expression , Delimiter )

Arguments

Set_Expression1
MDX expression that returns a set.
Set_Expression2
MDX expression that returns a set.
String_Expression
String expression
Delimiter
A valid delimiter expressed as a string expression.

Examples

Following example returns the names of all issues for each issue type. 

Generate(
  Filter(NonEmptyCrossJoin([Issue].[Issue].Members, [Measures].DefaultMember),
    [Measures].[Issue type] = [Issue Type].CurrentMember.Name),
  [Issue].CurrentMember.Name, ', '
)

See also