9 Oracle Utilities Data Model OLAP Model Cubes

This chapter of Oracle Utilities Data Model Reference describes the Data Flow between fact tables and dimension tables of Oracle Utilities Data Model relational part to target materialize views and cubes to support the module Oracle Utilities Data Model OLAP.

This chapter includes the following section:

• Oracle Utilities Data Model OLAP Cubes

For more information, see Chapter 8, "Oracle Utilities Data Model OLAP Model Dimensions".

Note:

All materialized views underlying the OLAP cubes are disabled by default. To enable the cube materialized views, you must follow the steps outlined in Oracle Utilities Data Model Implementation and Operations Guide.

Oracle Utilities Data Model OLAP Cubes

For each cube, each section includes the following cube information:

• Description

• Dimensions (leaf load level and load sequence)

• Base Measures with Physical Mapping and Description

• Derived Measure with the Logical Name and the Calculations

Table 9-1 lists the Oracle Utilities Data Model OLAP cubes.

Table 9-1 OLAP Cubes

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

Note:

Oracle Utilities Data Model includes base measures with format such as, XXXX1. These base measures are intended for internal; Oracle Utilities Data Model uses these base measures to calculate EOP_XXXX (end of period value). Do not use these measures for reporting.

Meter Reading Account Cube: ACCTMTRR

This cube provides information on the aggregate meter readings of different accounts by month. It is based on dimensions like time, meter, and account.

Physical Name: ACCTMTRR

Dimensions and Load Level

The fact data of Meter Reading Account Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-2 Meter Reading Account Cube Dimensions and Load Level

Dimension Name	Load Level
Account	Account
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The Meter Reading Account Cube is aggregated by the order and operators on dimensions shown in Table 9-3.

Table 9-3 Meter Reading Account Cube Aggregation and Order

Dimension Name	Operator	Order
Time	Sum	1
Account	Sum	2
Meter	Sum	3

Table 9-4 Meter Reading Account Cube Descriptions and Physical Columns

Physical Name	Description	Measure Type	Physical Column
MXKW	Max KW	Measure	DWA_MTR_RDNG_MO_ACCT.MAX_KW
TMXKW	Total Max KW	Measure	DWA_MTR_RDNG_MO_ACCT.TOT_KWH
MXKW_LP	Max KW Last Period	Calculated Measure	LAG(MTRRACCT.MXKW, 1) OVER (HIERARCHY "TIME".HTCLNDR)
MXKW_LY	Max KW Last Year	Calculated Measure	LAG(MTRRACCT.MXKW, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD	Max KW YTD	Calculated Measure	SUM(MTRRACCT.MXKW) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
MXKW_YTD_LY	MAX KW YTD Last Year	Calculated Measure	LAG(MTRRACCT.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD_PCT_LY	MXKW YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRACCT.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_LP	Total KWH Last Period	Calculated Measure	LAG(MTRRACCT.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR)
TKWH_LY	Total KWH Last Year	Calculated Measure	LAG(MTRRACCT.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD	Total KWH YTD	Calculated Measure	SUM(MTRRACCT.TKWH) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
TKWH_YTD_LY	Total KWH YTD Last Year	Calculated Measure	LAG(MTRRACCT.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD_PCT_LY	Total KWH YTD Percent Change Last Year	Calculated Measure	LAG(MTRRACCT.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

End Device Event Customer Cube: CUST_ENDVC

This cube stores the aggregates on the end device events by customer by month. It is based on time, customer, and operational usage point dimensions.

Physical Name: CUST_ENDVC

Dimensions and Load Level

The fact data of End Device Event Customer Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-5 End Device Event Customer Cube Dimensions and Load Level

Dimension Name	Load Level
Time	Business Month
Customer	Customer Code
Operational Usage Point	Sub Station

Aggregation Order/Operator

The End Device Event Customer Cube is aggregated by the order and operators on dimensions shown in Table 9-6.

Table 9-6 End Device Event Customer Cube Aggregation and Order

Dimension Name	Operator	Order
Operational Usage Point	Sum	1
Customer	Sum	2
Time	Sum	3

Table 9-7 End Device Event Customer Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
RVS_MTR_CNT	Reversed Meter Count	Measure	DWA_END_DVC_EVT_CUST_MO.USG_PNT_KEY
STPD_MTR_CNT	Stopped Meter Event Count	Measure	DWA_END_DVC_EVT_CUST_MO.RVS_MTR_CNT
TMPR_MTR_CNT	Tamper Meter Count	Measure	DWA_END_DVC_EVT_CUST_MO.STPD_MTR_CNT
RVS_MTR_CNT_LP	RVS MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.RVS_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
RVS_MTR_CNT_LY	RVS MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.RVS_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
STPD_MTR_CNT_LP	Stopped MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.STPD_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
STPD_MTR_CNT_LY	Stopped MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.STPD_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TMPR_MTR_CNT_LP	TMPR MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.TMPR_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TMPR_MTR_CNT_LY	TMPR MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.TMPR_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

End Device Event by Device Cube: DVC_ENDVC

This cube stores the aggregates on the end device events by different devices by month. It is based on time, meter, and manufacturer dimensions.

Physical Name: DVC_ENDVC

Dimensions and Load Level

The fact data of End device Event by Device Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-8 End Device Event by Device Cube Dimensions and Load Level

Dimension Name	Load Level
Manufacturer Product	Asset Model
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The End Device Event by Cube is aggregated by the order and operators on dimensions shown in Table 9-9.

Table 9-9 End Device Event by Device Cube Aggregation and Order

Dimension Name	Operator	Order
Manufacturer	Sum	1
Meter	Sum	2
Time	Sum	3

Table 9-10 End Device Event by Device Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
RVS_MTR_CNT	Reversed Meter Count	Measure	DWA_END_DVC_EVT_CUST_MO.USG_PNT_KEY
STPD_MTR_CNT	Stopped Meter Event Count	Measure	DWA_END_DVC_EVT_CUST_MO.RVS_MTR_CNT
TMPR_MTR_CNT	Tamper Meter Count	Measure	DWA_END_DVC_EVT_CUST_MO.STPD_MTR_CNT
RVS_MTR_CNT_LP	RVS MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.RVS_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
RVS_MTR_CNT_LY	RVS MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.RVS_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
STPD_MTR_CNT_LP	Stopped MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.STPD_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
STPD_MTR_CNT_LY	Stopped MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.STPD_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TMPR_MTR_CNT_LP	TMPR MTR CNT Last Period	Calculated Measure	LAG(ENDVC_CUST.TMPR_MTR_CNT, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TMPR_MTR_CNT_LY	TMPR MTR CNT Last Year	Calculated Measure	LAG(ENDVC_CUST.TMPR_MTR_CNT, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

Meter Reading Geo Usage Point Cube: GUSPMTRR

This cube provides information on the aggregate meter reading by different geographies by month. It is based on the following dimensions like time, meter, and geography usage point.

Physical Name: GUSPMTRR

Dimensions and Load Level

The fact data of Meter Reading Geo Usage Point Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-11 Meter Reading Geo Usage Point Cube Dimensions and Load Level

Dimension Name	Load Level
Geography Usage Point	Geography Usage Point
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The Meter Reading Geo Usage Point Cube is aggregated by the order and operators on dimensions shown in Table 9-12.

Table 9-12 Meter Reading Geo Usage Point Cube Aggregation and Order

Dimension Name	Operator	Order
Time	Sum	1
Meter	Sum	2
Geography Usage Point	Sum	3

Table 9-13 Meter Reading Geo Usage Point Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
MXKW	Max KW	Measure	DWA_MTR_RDNG_MO_UP.MAX_KW
TMXKW	Total KW Hour	Measure	DWA_MTR_RDNG_MO_UP.TOT_KWH
MXKW_LP	Max KW Last Period	Calculated Measure	LAG(MTRRGUSP.MXKW, 1) OVER (HIERARCHY "TIME".HTCLNDR)
MXKW_LY	Max KW Last Year	Calculated Measure	LAG(MTRRGUSP.MXKW, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD	Max KW YTD	Calculated Measure	SUM(MTRRGUSP.MXKW) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
MXKW_YTD_LY	MAX KW YTD Last Year	Calculated Measure	LAG(MTRRGUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD_PCT_LY	MXKW YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRGUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_LP	Total KWH Last Period	Calculated Measure	LAG(MTRRGUSP.TKWH, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TKWH_LY	Total KWH Last Year	Calculated Measure	LAG(MTRRGUSP.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD	Total KWH YTD	Calculated Measure	SUM(MTRRGUSP.TKWH) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
TKWH_YTD_LY	Total KWH YTD Last Year	Calculated Measure	LAG(MTRRGUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD_PCT_LY	Total KWH YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRGUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

Meter Reading Operational Usage Point Cube: OUSPMTRR

This cube provides information on the aggregate meter reading by operational usage points by month. It is based on time, meter, and operational usage point dimensions.

Physical Name: OUSPMTRR

Dimensions and Load Level

The fact data of Meter Reading Operational Usage Point Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-14 Meter Reading Operational Usage Point Cube Dimensions and Load Level

Dimension Name	Load Level
Usage	Point
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The Meter Reading Operational Usage Point Cube is aggregated by the order and operators on dimensions shown in Table 9-15.

Table 9-15 Meter Reading Operational Usage Point Cube Aggregation and Order

Dimension Name	Operator	Order
Time	Sum	1
Account	Sum	2
Operational Usage	Point	3

Table 9-16 Meter Reading Operational Usage Point Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
MXKW	Max KW	Measure	DWA_MTR_RDNG_MO_UP.MAX_KW
TMXKW	Total KW Hour	Measure	DWA_MTR_RDNG_MO_UP.TOT_KWH
MXKW_LP	Max KW Last Period	Calculated Measure	LAG(MTRROUSP.MXKW, 1) OVER (HIERARCHY "TIME".HTCLNDR)
MXKW_LY	Max KW Last Year	Calculated Measure	LAG(MTRROUSP.MXKW, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD	Max KW YTD	Calculated Measure	SUM(MTRROUSP.MXKW) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
MXKW_YTD_LY	MAX KW YTD Last Year	Calculated Measure	LAG(MTRROUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD_PCT_LY	MXKW YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRROUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_LP	Total KWH Last Period	Calculated Measure	LAG(MTRROUSP.TKWH, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TKWH_LY	Total KWH Last Year	Calculated Measure	LAG(MTRROUSP.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD	Total KWH YTD	Calculated Measure	SUM(MTRROUSP.TKWH) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
TKWH_YTD_LY	Total KWH YTD Last Year	Calculated Measure	LAG(MTRROUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD_PCT_LY	Total KWH YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRROUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

Meter Reading Regional Usage Point Cube: RUSPMTRR

This cube stores the aggregate meter reading by different regions by month. This cube is based on dimensions, time, region, and meter.

Physical Name: RUSPMTRR

Dimensions and Load Level

The fact data of Meter Reading Regional Usage Point Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-17 Meter Reading Regional Usage Point Cube Dimensions and Load Level

Dimension Name	Load Level
Regional Usage Point	Regional Usage
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The Meter Reading Regional Usage Point Cube is aggregated by the order and operators on dimensions shown in Table 9-18.

Table 9-18 Meter Reading Regional Usage Point Cube Aggregation and Order

Dimension Name	Operator	Order
Time	Sum	1
Meter	Sum	2
Regional Usage Point	Sum	3

Table 9-19 Meter Reading Regional Usage Point Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
MXKW	Max KW	Measure	DWA_MTR_RDNG_MO_UP.MAX_KW
TMXKW	Total KW Hour	Measure	DWA_MTR_RDNG_MO_UP.TOT_KWH
MXKW_LP	Max KW Last Period	Calculated Measure	LAG(MTRRRUSP.MXKW, 1) OVER (HIERARCHY "TIME".HTCLNDR)
MXKW_LY	Max KW Last Year	Calculated Measure	LAG(MTRRRUSP.MXKW, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD	Max KW YTD	Calculated Measure	SUM(MTRROUSP.MXKW) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
MXKW_YTD_LY	MAX KW YTD Last Year	Calculated Measure	LAG(MTRROUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD_PCT_LY	MXKW YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRRUSP.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_LP	Total KWH Last Period	Calculated Measure	LAG(MTRROUSP.TKWH, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TKWH_LY	Total KWH Last Year	Calculated Measure	LAG(MTRRRUSP.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD	Total KWH YTD	Calculated Measure	SUM(MTRRRUSP.TKWH) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
TKWH_YTD_LY	Total KWH YTD Last Year	Calculated Measure	LAG(MTRRRUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD_PCT_LY	Total KWH YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRRUSP.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)

Meter Reading Customer Cube: CUSTMTRR

This cube stores the aggregate meter reading by different regions by month. This cube is based on dimensions, time, region, and meter.

Physical Name: CUSTMTRR

Dimensions and Load Level

The fact data of Meter Reading Customer Cube will be loaded from the relational schema at these dimension levels (leaf level).

Table 9-20 Meter Reading Customer Cube Dimensions and Load Level

Dimension Name	Load Level
Customer	Customer
Meter	Meter
Time	Calendar Month

Aggregation Order/Operator

The Meter Reading Customer Cube is aggregated by the order and operators on dimensions shown in Table 9-21.

Table 9-21 Meter Reading Customer Cube Aggregation and Order

Dimension Name	Operator	Order
Time	Sum	1
Customer	Sum	2
Meter	Sum	3

Table 9-22 Meter Reading Regional Usage Point Cube Description and Physical Columns

Physical Name	Description	Measure Type	Physical Column
MXKW	Max KW	Measure	DWA_MTR_RDNG_MO_CUST.TOT_KWH
TMKW	Total kilo watt hour	Measure	DWA_MTR_RDNG_MO_CUST.MAX_KW
MXKW_LP	Max KW Last Period	Calculated Measure	LAG(MTRRCUST.MXKW, 1) OVER (HIERARCHY "TIME".HTCLNDR)
MXKW_LY	Max KW Last Year	Calculated Measure	LAG(MTRRCUST.MXKW, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD	Max KW YTD	Calculated Measure	SUM(MTRRCUST.MXKW) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
MXKW_YTD_LY	MAX KW YTD Last Year	Calculated Measure	LAG(MTRRCUST.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
MXKW_YTD_PCT_LY	MXKW YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRCUST.MXKW_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_LP	Total KWH Last Period	Calculated Measure	LAG(MTRRCUST.TKWH, 1) OVER (HIERARCHY "TIME".HTCLNDR)
TKWH_LY	Total KWH Last Year	Calculated Measure	LAG(MTRRCUST.TKWH, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD	Total KWH YTD	Calculated Measure	SUM(MTRRCUST.TKWH) OVER HIERARCHY ("TIME".HTCLNDR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME".CLNDR_YR)
TKWH_YTD_LY	Total KWH YTD Last Year	Calculated Measure	LAG(MTRRCUST.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)
TKWH_YTD_PCT_LY	Total KWH YTD Percent Change Last Year	Calculated Measure	LAG_VARIANCE_PERCENT(MTRRCUST.TKWH_YTD, 1) OVER HIERARCHY ("TIME".HTCLNDR BY ANCESTOR AT LEVEL "TIME".HTCLNDR.CLNDR_YR POSITION FROM BEGINNING)