13.3.1.2.2 Instrument or Transaction Summary Source

When your Source is an Instrument or Transaction Summary table, you may choose any valid measure in the table. Valid measures include only rates, balances, and numeric statistics such as activity counts.

Figure 13-8 Instrument or Transaction Summary Source


The Instrument or Transaction Summary Source pane allows you to define the table name, column name, and option between column name and expression.

To simultaneously apply an allocation rule to a group of Instrument tables, select Portfolio Table as Table Name in the For pane. After selecting the Portfolio table, a new pane called Portfolio Table Details displays. From this pane, you may select one or more of the instrument tables that are defined in your environment. Using the Portfolio Table is supported for all allocation types except Constant and Leaf.

To select the Instrument tables, follow these steps:

  1. Select the Table Name as Portfolio Table. The Portfolio Table Details pane is added that shows the list of all Instrument tables.

    Figure 13-9 Portfolio Table Details Pane


    The Portfolio Table Details pane allows you to select a portfolio table as the table name. You can select one or more of the instrument tables that are defined in your environment. This is not supported for Constant and Leaf allocation types.

  2. Click Select Table.

    Figure 13-10 Portfolio Table Name Selector


    This screen allows you to select a table and then select the Available Tables and move them to Selected Tables list.

  3. Select the Instrument Tables from Table Selector and click Ok.