Go to main content
1/23
Contents
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
Customer
Feeder
Geography Zone
Hour
Household
Manufacturer
Meter
Operational
Organization
Outage Record
Postcode
Product Asset Model
Region
Service Location
Substation
Time
Time Month Day Hour
Time Month
Time Month Hour
TOU
TOU Time
Time Season Month
Time Season Month Hour
Transformer
Usage Point
Usage Point Location
IETL Use Dimensions
Address Location
Asset Info
Demand Response Program
Outage Report
Product Offering
Reading Type
Usage Point Group
Zone
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
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
How to Populate Calendar Data
Part III Sample Reports
12
Oracle Utilities Data Model Sample Reports
Credit and Collection Sample Reports
Top N Arrear Accounts
Demand Response (DR) Sample Reports
Customer Savings by Demand Response (DR) Program
Meter Data Analysis Sample Reports
Top N Customer by Usage
Monthly Usage Season Profile
Daily Usage Season Profile
Monthly Total Usage
Low Usage by Usage Point
Time of Use Usage Profile
TOU Usage Trend
Top N Customer with Usage Change
Customer Count by Usage Grouping
Outage Analysis Sample Reports
Reliability by City
Worst Performing Feeder
Top N Customers by Customer Minutes Interrupted (CMI)
Top N Customers by Number of Outages
Top N Feeders by Outage Count
Top N Feeders by Total Minutes Lost
Top N Feeders by Reliability Indices
Top N City by Outage Count
Top N City by Total Minutes Lost
Top N City by Reliability Indices
Top N Region by Outage Count
Top N Region by Total Minutes Lost
Top N Region by Reliability Indices
Revenue Protection Sample Reports
Meter Tamper Event
Meter Stopped Event
Meter Reversed Event
Missing Meter Read
Event Analysis
Transformer Load Analysis Sample Reports
Transformer Daily Load Profile
13
Oracle Utilities Data Model Users and Application Roles
Steps to Create Oracle Utilities Data Model Application Roles
Steps to Create Oracle Utilities Data Model Users
Refresh 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)
Load Program (Intra-ETL) Metadata (Table MD_PRG)
Load Reports and KPI Metadata (Table MD_KPI and MD_REF_ENTY_KPI):
Part IV Appendices
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.