• Oracle Utilities Analytics Warehouse Developer’s Guide
• Preface
  • Audience
  • Prerequisite Knowledge
  • Related DocumentsDocumentation Roadmap
  • Conventions
  • Abbreviations
  • Documentation Accessibility
  • Related DocumentsDocumentation Roadmap
• 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 25.10.0.0.0 Developer’s Guide