1. Administering Profitability and Cost Management
  2. Working with Profitability and Cost Management Analytics Features
  3. Working with Analysis Views
  4. Using Member Functions

Using Member Functions

You can use Member Functions to select the member defined for that dimension in Preferences (Setting User Preferences), or you can use a formula that references a member relative to the current one. The following figure shows the Member Function list for the Period dimension.

Figure 12-4 Member Functions for the Period Dimension


The Member Selector screen with Level 1 selections (Q1, Q2, and so on) plus a series of formulas as described in the following text.

In the previous figure, Quarter to Date and Year to Date, and Current are self-explanatory and based on the date selected for this purpose. To set Current dates, see Editing an Application’s Description and Default Dimension Settings.

The Single... options select one member at the indicated level, counting back the indicated number from the current member at that level. For example, Single(-1) Level 0 provides data for June if the current month is July. Single(-1) Level1 provides data for Q2 if the current month is July, since July is in the third calendar quarter.

The Multiple... options select all members in the indicated range, counting back from the current member at that level. For example, Multiple(-6) Level 0 retrieves trailing six months data (for February through July, if the current month is July).