38.3 OFSDF Supporting Documentation

The preceding sections have provided an overview of the organization of the OFSDF, and its various component data models. Appendix A explains the naming conventions used in OFSDF data model.

The OFSDF is a detailed model, with nearly 850 entities across both the Staging and Results Area in the physical data model.

Since it is delivered as an erwin file, all the detailed metadata for the model (Table, Column, Entity, Attribute, Relationship) definitions are embedded in the file itself. The advantage of this approach is that any site-specific customizations to OFSDF can be performed within erwin, and the updated documentation is retained in the file in the form of additional metadata.

The 2 key detailed artifacts of OFSDF documentation that can be extracted from within the erwin Data Model are:

• Data Dictionary
• Download Specifications

For more information on Dimension Management and AMHM, refer to the Dimension Management chapter in Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.2.0.0 and Dimension Load Procedure section in Oracle Financial Services Analytical Applications Data Model Utilities User Guide.