6.1.7 Creating Reporting Bucket

The Time Bucket definition screen allows you to define multi-level time buckets. Reporting time buckets are defined over an existing computational time bucket set.

To create a reporting bucket, follow these steps:

  1. On the Oracle Financial Services Analytical Applications Infrastructure window under Time Bucket Summary window, select a created Computational Time Bucket and then click Create Reporting Bucket icon to create a reporting bucket.

    The Time Bucket Details – Edit window is displayed.

    Figure 6-4 Time Bucket Details – Edit window


    The image shows the Time Bucket Details – Edit window, allowing users to modify existing time bucket definitions, including bucket names, frequencies, and associated parameters.

  2. Enter the time bucket Name .
  3. Enter the time bucket Description .

    Note:

    Active option and dynamic start date selection are disabled for LRM users.
  4. Select the Folder from the drop-down list.
  5. Under the Liquidity Buckets section, the level 0 buckets defined as part of thes elected computational bucket are displayed.
  6. Click Calendar icon to select the Start Date from the MIS Date format.
  7. To group, click Apply . The Time Bucket Grouping icon is now enabled to group different levels. Only the Level 0 buckets defined in computational time bucket are displayed. You must define new higher levels. It is possible to group up to 5 levels. Once the grouping is done you can save it.
  8. Click Add Levels . The Time Bucket Grouping window is displayed.

    The process of grouping more granular buckets in higher-level buckets is consistent for all bucket levels.

    Figure 6-5 Time Bucket Grouping window


    The image displays the Time Bucket Grouping window, where users define and manage hierarchical groupings of time buckets for computational and reporting purposes.

  9. Click Select icon against a time bucket and click Add to group the time buckets.

    You can select multiple time buckets that form a single higher-level bucket at a single instance by clicking the last time bucket. A dialog box is displayed to define the Level 1 Bucket name that is, a user- specified name for the higher- level time bucket is created.

  10. Enter the Node Name and then click OK . Repeat steps 10 and 11 to group the other level 0 buckets into the level 1 bucket.
  11. Click Refresh icon to reset all the levels defined for the time bucket definition.
  12. Once all level 0 buckets are grouped, click the Group icon to save the grouping. On clicking the icon, the level 1 grouping is displayed in a new section named Level 2 BucketDefinition.

    The process of grouping level 1 bucket to level 2 buckets is similar to that detailed in points 10 through 12.

  13. Once you have defined your multi-level time buckets, click OK to save the definition. The hierarchy for the specified time bucket definition is now created and can be used for further computations.

    Note:

    • For all bucket types, you are allowed to specify a bucket called Unspecified Bucket. This is available at all bucket levels and will not have a time period associated with it.
    • The Overnight bucket will be the second time bucket in the list. The frequency and multiplier are 0 and days respectively. The start date and end date are set to as of date.
    • Additionally, a time bucket called Open Maturity is present. This is the time bucket used to bucket all cash flows from accounts that have do not have a maturity associated with them.
    • On execution of a Run, the start and end date are stored against each time bucket. This is for reporting purposes only. All definitions will use bucket names.