The data warehouse schema in Oracle Utilities Analytics Warehouse covers a wide range of reporting requirements. Often additional data elements are required to meet site-specific requirements. Oracle Utilities Analytics Warehouse allows such extensions to the schema through the user-defined constructs, such as User Defined Fields, User Defined Measures, User Defined Degenerate Dimensions, User Defined Foreign Keys, and User Defined Dimensions. Using these constructs, the star schemas delivered along with the product can be extended.

This chapter includes the following: