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. |