Functions Available Only Through Member Selection

The functions listed in Table -6 can be selected from the Functions tab in the Select Member dialog box. They cannot be entered dynamically in the formula bar.

Table -6 Functions Available Only Through Member Selection

Function Description
Match Extracts members that match a specified pattern or set of characters.

Note:

When using the asterisk (*) wildcard, the pattern can contain only one asterisk and it can only appear as the last character.

Property Extracts members with the specified property value.
Range Defines a range of members.

For example, you can use the "Year" dimension to specify all months in the first quarter by selecting "January" as the start member and "March" as the end member.