3.2 Adding Dimension Tables and Key Dimension (Leaf) Registration

The following section details the process in which users can add custom key dimensions to the OFSAA application.

Users can view the registered dimension within the AMHM screens. Also, users can add members and hierarchies for the dimension through AMHM screens.For Simple dimensions, entries should also be made in REV_DESCRIPTION_TABLES for each Instrument and Transaction Table in which that new dimension will occur.Registering a new Key Dimension (called as Leaf in OFSA 4.5) requires the following steps:

1. Add a set of dimension tables to store leaf values in ERwin model.
2. Add the key dimension column to required Entities in ERwin model.
3. Assign the Processing Key Column Property (Key Dimension Columns only).
4. Upload the model.
5. Register the Key Dimension.Modify Unique indexes (Key Leaf Dimension only).
6. Validate tables.Each of these steps is discussed in detail in the following sections.
7. Additionally, perform the following steps to avoid the errors running due to Allocations that use a Portfolio table.
8. Insert a row into REV_COLUMN_REQUIREMENTS for the custom dimension column.
9. Add the custom dimension to the Portfolio classification by following the instructions in the section Adding a new user defined column as a Portfolio column for use in all Instrument tables.

   Note:

   For more information on limitation for number of key (processing) dimensions, see the Doc ID 1478920.1.If an allocation using a Portfolio with expression fails, then you should do manual entries for standard columns in REV_COLUMN_REQUIREMENTS through sql script which comes as part of installer.