All eazyBI for Jira eazyBI for Confluence Private eazyBI

SetToStr

Constructs a string from the set. The string contains member names that correspond to a specified set. This is a useful function to validate the MDX calculation and see which members are included in the set.

Syntax

SetToStr( Set_Expression )

Arguments

Set_ExpressionMDX expression that returns a set of members.

Returns

String_Expression
String expression representing member names.

Examples

The following example returns filtered Assignee users that have any issues assigned for the selected report row and column.

SetToStr(
  Filter( 
    [Assignee].[User].Members,
    [Measures].[Issues created] > 0)
)

This example shows the names of Sprints that correspond to filter criteria and the selected report row and column.

SetToStr(
  -- filter last 5 closed sprints
  Tail(
    Filter(
      [Sprint].[Sprint].Members,
      [Measures].[Sprint closed?] = 'Yes' AND
      -- only sprints with some issues at closing are retrieved
      [Measures].[Sprint issues at closing] > 0
    ),5
  )
)


See also