Go to main content
1/23
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Logical and Physical Data Model
1
Introducing Oracle Utilities Data Model
Overview of Oracle Utilities Data Model
What Are the Benefits of Using Oracle Utilities Data Model?
What Are the Components of Oracle Utilities Data Model?
What Oracle Technologies are in Oracle Utilities Data Model
What is Oracle Utilities Data Model
About Business Areas and Subject Areas in Oracle Utilities Data Model
About the Logical Data Model and Physical Data Model
About Entity Relationships in Oracle Utilities Data Model
Understanding Named and Flexible Hierarchies
About Common Information Model (CIM) Users Group
About Business Areas in Oracle Utilities Data Model
2
Logical Data Model Foundation
Major Subject Areas and Related Entities
Subject Area: Account
Subject Area: Account Balance
Subject Area: Account Credit Limit
Subject Area: Agreement
Subject Area: Asset
Subject Area: Asset Information Classes
Subject Area: Billing
Subject Area: Business Events
Subject Area: Business Interaction
Subject Area: Channel
Subject Area: Connectivity Model
Subject Area: Cost
Subject Area: Curve Schedule
Subject Area: Customer
Subject Area: Customer Account and Agreement
Subject Area: Demand Response Program
Subject Area: Employee
Subject Area: End Device Control
Subject Area: End Device Event
Subject Area: Financial
Subject Area: Generating Unit
Subject Area: Line Model
Subject Area: Load Model
Subject Area: Location
Subject Area: Meter Asset
Subject Area: Meter Event and Reading
Subject Area: Meter Reading
Subject Area: Meter Reading and Events
Subject Area: Meter Reading and Control Overview
Subject Area: Meter Reading Register and Channel
Subject Area: Meter Reading Type
Subject Area: Network Operation
Subject Area: Outage Management
Subject Area: Party Organization Business Unit
Subject Area: Payment
Subject Area: Phase Model
Subject Area: Premise and Node
Subject Area: Pricing Structure
Subject Area: Promotion and Campaign
Subject Area: Regulating Equipment Model
Subject Area: SCADA
Subject Area: Schedule Model
Subject Area: Substation, Feeder, and Transformer Hierarchy Model
Subject Area: Switching Equipment Model
Subject Area: Tap Changer Model
Subject Area: Transformer Model
Subject Area: Usage Point, Agreement, Account, Customer, and Premise
Subject Area: Usage Point and End Device
Subject Area: Voltage Control Model
Subject Area: Weather Model
Subject Area: Work Management
Logical Entities for Business Areas
Business Area: Account Management
Business Area: Asset Management
Business Area: Customer Management
Business Area: Meter Reading and Control
Business Area: Network Operation
Business Area: Outage Management
Business Area: Weather Model
Business Area: Work Management
Logical Data Model Entity Dictionary
3
Logical Data Model Dimensions
Logical Data Model Dimensions
Account
Account Hierarchy
Account Levels
Customer
Customer Hierarchy
Customer Levels
Feeder
Feeder Hierarchy
Feeder Levels
Geography Zone
Geography Zone Hierarchy
Geography Zone Levels
Hour
Hour Hierarchy
Hour Levels
Household
Household Hierarchy
Household Levels
Manufacturer
Manufacturer Hierarchy
Manufacturer Levels
Meter
Meter Hierarchy
Meter Levels
Operational
Operational Hierarchy
Operational Levels
Organization
Organization Hierarchy
Organization Levels
Outage Record
Outage Record Hierarchy
Outage Record Levels
Postcode
Postcode Hierarchy
Postcode Levels
Product Asset Model
Product Asset Model Hierarchy
Product Asset Model Levels
Region
Region Hierarchy
Region Levels
Service Location
Service Location Hierarchy
Service Location Levels
Substation
Substation Hierarchy
Substation Levels
Time
Time Hierarchy
Time Levels
Time Month Day Hour
Time Month Hour Hierarchy
Time Month Hour Levels
Time Month
Time Month Hierarchy
Time Month Levels
Time Month Hour
Time Month Hour Hierarchy
Time Month Hour Levels
TOU
Time Of Use Hierarchy
Time Of Use Levels
TOU Time
TOU Time Hierarchy
TOU Time Levels
Time Season Month
Time Season Month Hierarchy
Time Season Month Levels
Time Season Month Hour
Time Season Month Hour Hierarchy
Time Season Month Hour Levels
Transformer
Transformer Hierarchy
Transformer Levels
Usage Point
Usage Point Hierarchy
Usage Point Levels
Usage Point Location
Usage Point Location Hierarchy
Usage Point Location Levels
IETL Use Dimensions
Address Location
Address Location Hierarchy
Address Location Levels
Asset Info
Asset Info Hierarchy
Asset Info Levels
Demand Response Program
Demand Response Program Hierarchy
Demand Response Program Levels
Outage Report
Outage Report Hierarchy
Outage Report Levels
Product Offering
Product Offering Hierarchy
Product Offering Level
Reading Type
Reading Type Hierarchy
Reading Type Levels
Usage Point Group
Usage Point Group Hierarchy
Usage Point Group Levels
Zone
Zone Hierarchy
Zone Levels
4
Oracle Utilities Data Model Physical Data Model
Introduction to Oracle Utilities Data Model Physical Data Model
Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Temporary and Other Tables
Sequences in Oracle Utilities Data Model
Compressed Tables
Oracle Utilities Data Model OLAP Cube MV, Cube View
5
Oracle Utilities Data Model Logical to Physical Mapping
Overview of Mapping and Inheritance in Oracle Utilities Data Model
Logical to Physical Mappings for Oracle Utilities Data Model
6
Oracle Utilities Data Model Partitioning
About Oracle Utilities Data Model Partitioning, Compression, and Parallelism
Partitioning Strategy for Oracle Utilities Data Model
Part II Intra-ETL, OLAP, Data Mining, and Utility Scripts
7
Oracle Utilities Data Model Intra-ETL
About Oracle Utilities Data Model Intra-ETL
Intra-ETL PL/SQL Packages Business Rules and Source Tables
PKG_DWD_ACCT_ARRER_MO Package
PKG_DWD_ACCT_BAL_MO Package
PKG_DWD_ACCT_DEBT_DAY
PKG_DWD_ACCT_PMT_MTD_STAT_HST
PKG_DWD_ACCT_PYMT_DAY
PKG_DWD_ACCT_STAT_MO
PKG_DR_PROG_LD_RDCTN_RGN_DAY
PKG_DWD_END_DVC_EVT_CUST_DAY
PKG_DWD_END_DVC_EVT_DVC_DAY
PKG_DWD_MTR_RDNG_DAY
PKG_DWD_MTR_RDNG_HR
PKG_DWD_OUTG_DAY
PKG_DWD_OUTG_USG_PNT
PKG_DWD_RLBLTY_IND_CITY_MO
PKG_DWD_RLBLTY_IND_FEDR_MO
8
Oracle Utilities Data Model OLAP Model Dimensions
Introduction to OLAP Architecture
General Process to Populate the OLAP Module in Oracle utilities Data Model
Query Rewrite to Cube Organized Materialized Views
Oracle Utilities Data Model OLAP Dimensions
Account: ACCT
Customer: CUST
Geography Usage Point: GEOUP
Manufacturer: MNFCTR
Meter:MTR
Operational Usage Point: OPTUP
Regional Usage Point: RGUP
Time: TIME
Usage Point: UP
9
Oracle Utilities Data Model OLAP Model Cubes
Oracle Utilities Data Model OLAP Cubes
Meter Reading Account Cube: ACCTMTRR
End Device Event Customer Cube: CUST_ENDVC
End Device Event by Device Cube: DVC_ENDVC
Meter Reading Geo Usage Point Cube: GUSPMTRR
Meter Reading Operational Usage Point Cube: OUSPMTRR
Meter Reading Regional Usage Point Cube: RUSPMTRR
Meter Reading Customer Cube: CUSTMTRR
10
Oracle Utilities Data Model Data Mining Model
About Data Mining in Oracle Utilities Data Model
Understanding the Mining Architecture
Oracle Utilities Data Model Mining Result Tables
Model 1: Customer Savings and Customer Profile by DR Program
STEP1: Segmentation Using Oracle Data Mining Clustering Algorithm
Algorithms Used
Algorithm Setting Table
STEP2 Segmentation and Customer Saving Calculation
Oracle Utilities Data Model Mining Setting Tables
11
Oracle Utilities Data Model Utility Scripts
Calendar Population
Calendar Population Scripts
Populating Calendar Data
Part III Sample Reports Users, Roles, and Metadata
12
Oracle Utilities Data Model Sample Reports
Credit and Collection Sample Reports
Top N Arrear Accounts
Top N Arrear Accounts
Demand Response (DR) Sample Reports
Customer Savings by Demand Response (DR) Program
Available Load Reduction by Program
Meter Data Analysis Sample Reports
Top N Customer by Usage
Top N Customers by Usage
Monthly Usage Season Profile
Season Monthly Usage by Geographical Zones Report
Monthly Usage Season Profile by Operational Zones Report
Usage Season Profile
Usage Season Profile by Operational Zones
Usage Season Profile by Geographical Zones
Monthly Total Usage
Operational Monthly Usage
Regional Monthly Usage
Geographical Monthly Usage
Low Usage by Usage Point
Low Usage by Usage Point
Time of Use Usage Profile
Time of Use Usage Profile
TOU Usage Trend
Time of Use Usage Trend
Top N Customer with Usage Change
Top N Customer with Usage Change
Customer Count by Usage Grouping
Customer Count by Usage Grouping
Outage Analysis Sample Reports
Reliability by City
Reliability by City
Worst Performing Feeder
Worst Performing Feeder
Top N Customers by Customer Minutes Interrupted (CMI)
Top N Usage Points by CMI
Top N Customers by Number of Outages
Top N Customers by Number of Outages
Top N Feeders by Outage Count
Top N Feeders by Outage Count
Top N Feeders by Total Minutes Lost
Top N Feeders by Total Minutes Lost
Top N Feeders by Reliability Indices
Top N Feeders by Reliability Indices
Top N City by Outage Count
Top N City by Outage Count
Top N City by Total Minutes Lost
Top N City by Total Minutes Lost
Top N City by Reliability Indices
Top N City by Reliability Indices
Top N Region by Outage Count
Top N Region by Outage Count
Top N Region by Total Minutes Lost
Top N Region by Total Minutes Lost
Top N Region by Reliability Indices
Top N Region by Reliability Indices
Revenue Protection Sample Reports
Meter Tamper Event
Meter Tamper Event: Region
Meter Tamper Event: Geography
Meter Tamper Event: Operational
Meter Stopped Event
Meter Stopped Event: Region
Meter Stopped Event: Geography
Meter Stopped Event: Operational
Meter Reversed Event
Meter Reversed Event: Region
Meter Reversed Event: Geography
Meter Reversed Event: Operational
Missing Meter Read
Missing Meter Read
Event Analysis
Event Analysis
Load Analysis Sample Reports
Daily Load Profile
Daily Load Profile
Daily Load Profile by Geography
OLAP Sample Reports
Monthly Total Usage Operational
Monthly Total Usage (Utility)
Monthly Total Usage Geography
Event Analysis
Usage Point Analysis
13
Oracle Utilities Data Model Users and Application Roles
Creating Oracle Utilities Data Model Application Roles
Creating Oracle Utilities Data Model Users
Refreshing the GUID
14
Metadata Collection and Reports
Overview of Managing Metadata for Oracle Utilities Data Model
Metadata Categories and Standards
Working with a Metadata Repository
Browsing Metadata Reports and Dashboard
Using the Measure-Entity Tab Business Areas and Measures Attributes and Entities
Using the Entity-Measure Tab Entity to Attribute Measures
Using the Program-Table Tab
Using the Table-Program Tab
Collecting and Populating Metadata
Load LDM/PDM Metadata (Table MD_ENTY)
GIVE_ABBRV
MD_DM_ALL_ENT_ATTR
PL/SQL Program to Update Column Name
PL/SQL program to insert initial data into MD_OIDM_ATTR_COL_NAM
PL/SQL program to load data into MD_ENTY
Load Program (Intra-ETL) Metadata (Table MD_PRG)
Load Reports and KPI Metadata (Table MD_KPI and MD_REF_ENTY_KPI):
A
Control Tables
Intra-ETL Load Parameters Control Table
Intra-ETL OLAP Mapping Control Table
Intra-ETL Monitoring Process Control Tables
Index
Scripting on this page enhances content navigation, but does not change the content in any way.