User Defined Dimensions
A user defined dimension (UDD) is a means of extension for an existing fact. These dimensions have a foreign key reference to a fact; however no out-of-box ETL is delivered. Customers can define an ODI ETL process to populate these dimensions with the source data as per their requirement. Each fact is provided with two such user defined dimensions. For details about extending using UDDs, see the Oracle Utilities Analytics Warehouse Developer’s Guide.
All user defined dimensions have the same structure. The only technical difference is the column name of the primary key, which follows the pattern of using the fact for which it is linked to.
Below is the structure of the Fields table which is common to all user defined dimensions.
Following is a list of user defined dimensions in Oracle Utilities Network Management System:
•  
•  
 
Fields
Target Field
Description
Surrogate Key
<Fact_name_prefix>_UDDn_KEY
 
For example: The surrogate key for Asset Location UDD is ASSET_LOC_UDD1_KEY
<Fact name> User Defined Dimension n Dimension Surrogate Key
 
For example: Asset Location User Defined Dimension 1 Dimension Surrogate Key
Natural Keys
UDD1_CD
User Defined Dimension 1 Code
Attributes
UDD1_DESCR
User Defined Dimension 1 Description
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
UDF1_DESCR
User Defined Field 1 Description
UDF2_CD
User Defined Field 2 Code
UDF2_DESCR
User Defined Field 2 Description
UDF3_CD
User Defined Field 3 Code
UDF3_DESCR
User Defined Field 3 Description
UDF4_CD
User Defined Field 4 Code
UDF4_DESCR
User Defined Field 4 Description
UDF5_CD
User Defined Field 5 Code
UDF5_DESCR
User Defined Field 5 Description
UDL1_CD
User Defined Field Long 1 Code
UDL1_DESCR
User Defined Field Long 1 Description
UDL2_CD
User Defined Field Long 2 Code
UDL2_DESCR
User Defined Field Long 2 Description
UDL3_CD
User Defined Field Long 3 Code
UDL3_DESCR
User Defined Field Long 3 Description
UDL4_CD
User Defined Field Long 4 Code
UDL4_DESCR
User Defined Field Long 4 Description
UDL5_CD
User Defined Field Long 5 Code
UDL5_DESCR
User Defined Field Long 5 Description
COMMENT1
Comment 1
COMMENT2
Comment 2
COMMENT3
Comment 3
COMMENT4
Comment 4
COMMENT5
Comment 5
Data Load Attributes
EFF_START_DTTM
Effective Start Date/Time
EFF_END_DTTM
Effective End Date/Time
DATA_LOAD_DTTM
Data Load Date/Time
DATA_SOURCE_IND
Data Source Indicator
JOB_NBR
Job Number
 
Abnormal Device Log UDD1
Property
Value
Target Table
CD_ABNORMAL_DEVICE_LOG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Abnormal Device Log UDD2
Property
Value
Target Table
CD_ABNORMAL_DEVICE_LOG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Call UDD1
Property
Value
Target Table
CD_CALL_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Call UDD2
Property
Value
Target Table
CD_CALL_UDD2
Table Type
Dimension
SCD Type
Type 2
 
City Outage UDD1
Property
Value
Target Table
CD_CITY_OUTG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
City Outage UDD2
Property
Value
Target Table
CD_CITY_OUTG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Control Zone Outage UDD1
Property
Value
Target Table
CD_CTRL_ZONE_OUTG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Control Zone Outage UDD2
Property
Value
Target Table
CD_CTRL_ZONE_OUTG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Crew UDD1
Property
Value
Target Table
CD_CREW_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Crew UDD2
Property
Value
Target Table
CD_CREW_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Crew Activity UDD1
Property
Value
Target Table
CD_CREW_ACTIVITY_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Crew Activity UDD2
Property
Value
Target Table
CD_CREW_ACTIVITY_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Customer Outage UDD1
Property
Value
Target Table
CD_CUST_OUTG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Customer Outage UDD2
Property
Value
Target Table
CD_CUST_OUTG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Customer Recent Outage UDD1
Property
Value
Target Table
CD_CUST_OUTG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Customer Recent Outage UDD2
Property
Value
Target Table
CD_CUST_OUTG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Damage Assessment UDD1
Property
Value
Target Table
CD_DAMAGE_ASMT_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Damage Assessment UDD2
Property
Value
Target Table
CD_DAMAGE_ASMT_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Damage Assessment Detail UDD1
Property
Value
Target Table
CD_DAMAGE_ASMT_DETAIL_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Damage Assessment Detail UDD2
Property
Value
Target Table
CD_DAMAGE_ASMT_DETAIL_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Job UDD1
Property
Value
Target Table
CD_JOB_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Job UDD2
Property
Value
Target Table
CD_JOB_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Outage UDD1
Property
Value
Target Table
CD_OUTG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Outage UDD2
Property
Value
Target Table
CD_OUTG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Outage History UDD1
Property
Value
Target Table
CD_OUTG_HIST_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Outage History UDD2
Property
Value
Target Table
CD_OUTG_HIST_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Recent Call UDD1
Property
Value
Target Table
CD_CALL_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Recent Call UDD2
Property
Value
Target Table
CD_CALL_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Recent Crew UDD1
Property
Value
Target Table
CD_CREW_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Recent Crew UDD2
Property
Value
Target Table
CD_CREW_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Recent Job UDD1
Property
Value
Target Table
CD_JOB_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Recent Job UDD2
Property
Value
Target Table
CD_JOB_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Storm UDD1
Property
Value
Target Table
CD_STORM_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Storm UDD2
Property
Value
Target Table
CD_STORM_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan UDD1
Property
Value
Target Table
CD_SW_PLAN_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan UDD2
Property
Value
Target Table
CD_SW_PLAN_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan Segmentation UDD1
Property
Value
Target Table
CD_SW_PLAN_SEG_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan Segmentation UDD2
Property
Value
Target Table
CD_SW_PLAN_SEG_UDD2
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan State UDD1
Property
Value
Target Table
CD_SW_PLAN_STATE_UDD1
Table Type
Dimension
SCD Type
Type 2
 
Switch Plan State UDD2
Property
Value
Target Table
CD_SW_PLAN_STATE_UDD2
Table Type
Dimension
SCD Type
Type 2