List of Figures

• 3-1 Example of Hierarchy for US Acct
• 3-2 Screen Shot of file_glacct_segment_config_ora.csv Opened in a Text Editor
• 3-3 Screenshot of file_glacct_segment_config_ora.csv in text editor
• 3-4 Screen Shot of file_gl_hierarchy_assignment_ora.csv Opened in a Text Editor
• 5-1 Example GL Chartfield Hierarchy
• 5-2 Winter Loose-Level Tree
• 6-1 Handling Booked and Nonbooked Orders
• 6-2 Sales Order Lines and Bookings Table
• 6-3 Bookings recorded at the Schedule Line level
• 6-4 Sample BOM Structure
• 7-1 How the Department Tree Populates Data Warehouse Tables
• 7-2 How a Summer Tree Is Flattened
• 10-1 Screenshot of the Initialization Block - Authorization screen
• 10-2 Oracle Business Analytics Warehouse Environment
• 10-3 Merging with an Oracle BI Repository
• 11-1 Supported customizations based on data source
• 11-2 Preconfigured logic and customizations
• 11-3 Encapsulating logic
• 11-4 Encapsulated logic and extension logic
• 11-5 Re-extending and reconnecting to extension logic
• 11-6 Components of the Source adapter mapplet
• 11-7 Extract and load mappings
• 11-8 Primary Extract and Delete Mappings
• 11-9 An example Type 1 Slowly Changing Dimension
• 11-10 An example Type 2 Slowly Changing Dimension
• 11-11 An example Type 2 Slowly Changing Dimension
• 11-12 Example of a code mapping in Informatica PowerCenter Designer
• 11-13 Lookup for Employee Contract Data
• 11-14 Source Values Translated to Domain Values
• 11-15 Source Values in Different Tables Translated to Domain Values
• 11-16 HIR and REH Values Populating the W_EVENT_TYPES table
• 11-17 Metric Values From HIR and REH Domain Values