Contains

Returns a subset of elements in a list based on a string search on captions. The search is based on a 'contains" operation.

Syntax & Usage

• Create a list from which you want to derive the list of elements containing the specified text.
• Add the Contains block to the list; go to the Insert Arguments window and enter the "Text to search for".
• Select "Exclude from Result Set" if you want to remove the elements containing the given text from the list (as opposed to creating a list from them).

Example

Here the term "Frame" is searched from the Product hierarchy, and a subset of product elements containing Frame is returned:

{Contains({AllMembers([products].[Product])},"Frame")}