StrToSet (PQL)

Returns a list of members or elements for a given hierarchy or attribute.

  • Returned Output: List
  • Library: PQL \ Semantic \ String
  • Version: 2018.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources


StrToSet( <Hierarchy> , <Text> , OPTIONAL <Delimiter> )

Syntax Alternatives

StrToList( <Hierarchy> , <Text> , OPTIONAL <Delimiter> )

* Click on the function's arguments above for more details on the input values.

  • The hierarchy or attribute needs to the unique name for an existing hierarchy in the model.
  • The text string needs to be a delimited list of names or captions for members.
  • The optional delimiter indicates how the string of items is separated out. A simple comma (",") is assumed to be the delimiter if no delimiter is provided,
  • For details on how to employ and use this function see the semantic calculation overview.


This example returns a list of members comprising Australia and Canada from the country hierarchy in the customer dimension:

StrToSet( [customer].[country], "australia,canada" )

This example returns the same list of members, but the list has been delimited by semi-colon rather than commas:

StrToSet( [customer].[country], "australia;canada" ";" )