1. User Guide
  2. Overview of OFSAA Infrastructure
  3. Dimension Types
  4. Key Processing Dimensions

Key Processing Dimensions

Key Processing Dimensions have the following features:

  • Accessible as Modeling Dimensions for all of the OFSAA Analytical Engines.
  • Expressed as columns in nearly all of your Business Fact Tables.
  • Support both Attributes and Hierarchies.

Metadata for Key Processing Dimensions are stored in the following four tables:

  • A Base Table
  • A Translation Table
  • An Attribute Table
  • A Hierarchy Table

Base Tables store basic information about each dimension member and Translation Tables Store names and descriptions for each Dimension Member in multiple languages (see the Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) Installation and Configuration Guide for details on multi-language support). Attribute Tables store one or many attribute values for each dimension member. Hierarchy Tables store one or more hierarchies for each dimension (you can define as many hierarchies as you wish for any dimension that supports hierarchies).