1. Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud
  2. Designing Reports with Financial Reporting Web Studio
  3. Defining Members
  4. Assigning Members
  5. Assigning Members Using Functions
  6. Functions Available Only Through Member Selection

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.