Oracle Utilities Analytics Warehouse Developer’s Guide
Getting Started
Object Naming Convention
Creating a Project
Creating a Model Folder
Using CM Metadata User Procedure
User Extension Methods
Dimension Patterns
Extending Dimensions
Fact Patterns
Extending Facts
Using Custom User-Defined Dimensions (UDD)
Custom Dimensions
Custom Facts
Extending Replication
Including Tables
Adding Custom Tables for OUAF-Based Source Applications
Adding Custom Tables for Oracle Utilities Network Management System
Enabling Replication
Creating Replicated Tables
Executing Initial Sync
Verifying Model Setup
Extending Star Schema
User Extensible Columns
UDX Processing
Populating User-Defined Columns
Creating CM Mappings
Creating CM Packages
Resetting Dimensions
Configuring CM Scenarios
Monitoring Job Execution
Validating Data Load
Populating User Defined Foreign Keys
Creating CM Views
Creating CM Mappings
Creating CM Packages
Configuring CM Scenarios
Star Schema
Custom Dimensions
Creating Dimension Table
Importing Dimension into Model
Importing Replicated Table into Replication Model
Creating Replication Key View in Dimension Model
Creating Mapping for Key Views in Dimension Model
Creating Loading Views in Dimension Model
Creating Mapping for Loading Views
Creating Package for Loading Views
Creating Staging Table in the Dimension Model
Creating Mapping in Dimension Model
Creating Package in Dimension Model
Configuring Entities in Dimension Model
Configuring Jobs in Dimension Model
Monitoring Job Execution
Validating the Data Loaded
Custom Facts
Creating Fact Tables
Importing Fact Tables into Model
Importing Replicated Tables into Fact Model
Creating Key Tables in Fact Model
Creating Mapping for Key Tables in Fact Model
Creating Loading Views in Fact Model
Creating Mapping to Loading Views for Fact Model
Creating Aggregate Tables in Fact Model
Creating Mapping to Load Aggregate Tables in Fact Model
Creating Staging Tables in Fact Model
Creating Error Tables in Fact Model
Creating Mapping to Load Facts
Creating Packages in Fact Model
Configuring Entities in Fact Model
Specifying Dependencies in Fact Model
Configuring Jobs in Fact Model
Monitoring Job Executions
Custom Materialized Views
Creating Mapping for Materialized View
Creating Packages for Materialized View
Configuring Entities for Materialized View
Specifying Dependencies for Materialized View
Configuring Jobs for Materialized View
Monitoring Job Execution
Extending Analytics
Customizing Existing Analytics
Modifying the RPD File
Customizing Answers
Customizing the Report Labels
Creating New Analytics
Creating New Answers
Adding New Labels
Customizing Hierarchy Levels
Migrating Environments
Migrating OAS Components
Presentation Catalog
Repository
Migrating ODI Components
CM Project
CM Models
CM Metadata
Oracle Utilities Analytics Warehouse Developer’s Guide
Oracle Utilities Analytics Warehouse Release 2.8.0.2.0 Developer’s Guide