This chapter includes the following sections:
For more information, see Chapter 7, "Oracle Airlines Data Model OLAP Model Dimensions".
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 8-1 lists the Oracle Airlines Data Model OLAP cubes.
Contains the summarized booking segment departure information.
Table 8-2 briefly describes the Dimensions and Load Level.
Table 8-2 Booking Segment Departure Fact Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
BKCLS |
BKCLS |
|
ROUTE |
ROUTE |
|
OPFLT |
OPFLT |
|
OPSMT |
OPSMT |
|
BKOFC |
AGNT |
Table 8-3 briefly describes the Aggregation Order/Operator.
Table 8-3 Booking Segment Departure Fact Cube Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
sum |
1 |
|
BKCLS |
sum |
2 |
|
BKOFC |
sum |
3 |
|
OPFLT |
sum |
4 |
|
OPSMT |
sum |
5 |
|
ROUTE |
sum |
6 |
Table 8-4 briefly describes the Base Measures.
Table 8-4 Booking Segment Departure Fact Cube Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
BKD |
Booked Count |
DWA_DLY_BKG_FACT.BKD |
Booked Count |
|
CFCNT |
Confirmed Count |
DWA_DLY_BKG_FACT.CONFMD_CNT |
Confirmed Count |
|
CLCNT |
Canceled Count |
DWA_DLY_BKG_FACT.CNCLD_CNT |
Canceled Count |
|
TKD |
Ticketed Count |
DWA_DLY_BKG_FACT.TKTD |
Ticketed Count |
|
NTCFD |
Net Confirmed |
DWA_DLY_BKG_FACT.NET_CONFMD |
Net Confirmed |
|
GBKD |
Group Booked |
DWA_DLY_BKG_FACT.GRP_BKD_QTY |
Group Booked |
|
IBKD |
Individual Booked |
DWA_DLY_BKG_FACT.INDV_BKD_QTY |
Individual Booked |
|
OTCHR |
Other Charges |
DWA_DLY_BKG_FACT.OTR_CHARGES |
Other Charges |
|
TXS |
Taxes |
DWA_DLY_BKG_FACT.TAX_AMT |
Taxes |
|
TRVN |
Total Revenue |
DWA_DLY_BKG_FACT.TKT_AMT |
Total Revenue |
|
PXCNT |
Passenger Count |
DWA_DLY_BKG_FACT.PAX_CNT |
Passenger Count |
|
WTLST |
Wait Listed Count |
DWA_DLY_BKG_FACT.WAITLISED |
Wait Listed Count |
|
FRVN |
Flown Revenue |
DWA_DLY_BKG_FACT.FLN_REV |
Flown Revenue |
|
FPAX |
Flown Passenger Count |
DWA_DLY_BKG_FACT.FLN_PAX_CNT |
Flown Passenger Count |
|
NFPAX |
Non Revenue Flown Passenger Count |
DWA_DLY_BKG_FACT.NON_REV_FLN_PAX_CNT |
Non Revenue Flown Passenger Count |
|
CPC |
Coupons Count |
DWA_DLY_BKG_FACT.CPN_CNT |
Coupons Count |
|
OBRVN |
Onboard Revenue |
DWA_DLY_BKG_FACT.ONBRD_REV |
Onboard Revenue |
|
EBRVN |
Excess Bag Revenue |
DWA_DLY_BKG_FACT.EXCESS_BAG_REV |
Excess Bag Revenue |
|
FES |
Fees Revenue |
DWA_DLY_BKG_FACT.FEES_REV |
Fees Revenue |
|
CTRVN |
Charter Revenue |
DWA_DLY_BKG_FACT.CHARTER_REV |
Charter Revenue |
|
BCRVN |
Belly Cargo Revenue |
DWA_DLY_BKG_FACT.BELLY_CARGO_REV |
Belly Cargo Revenue |
|
CSRVN |
Code Share Revenue |
DWA_DLY_BKG_FACT.CDSH_REV |
Code Share Revenue |
|
OTRVN |
Other Revenue |
DWA_DLY_BKG_FACT.OTR_REV |
Other Revenue |
Table 8-5 briefly describes the Derived Measures.
Table 8-5 Booking Segment Departure Fact Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
BCRVN_LP |
Belly Cargo Revenue LP |
LAG(BSDF.BCRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BCRVN_LP_PCT_CHG |
Belly Cargo Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.BCRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BCRVN_YTD |
Belly Cargo Revenue YTD |
SUM(BSDF.BCRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BCRVN_YTD_LY |
Belly Cargo Revenue YTD LY |
LAG(BSDF.BCRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BCRVN_YTD_LYP_CHG |
Belly Cargo Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.BCRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKCR |
Booking Conversion Rate |
(BSDF.NTCFD / BSDF.NTBKD) * 100 |
|
BKD_LP |
Booked LP |
LAG(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKD_LP_PCT_CHG |
Booked % Change LP |
LAG_VARIANCE_PERCENT(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKD_LY |
Booked LY |
LAG(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_LY_CHG |
Booked Change LY |
LAG_VARIANCE(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_LY_PCT_CHG |
Booked % Change LY |
LAG_VARIANCE_PERCENT(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_RNK_OFC |
Booked Rank of Booking Office Parent |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.BKD DESC NULLS LAST WITHIN PARENT) |
|
BKD_RNK_RUT |
Booked Rank of Route Parent |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.BKD DESC NULLS LAST WITHIN PARENT) |
|
BKD_SHR_OFC |
Booked share of booking office parent |
SHARE(BSDF.BKD OF BKOFC.HBKOFC PARENT) |
|
BKD_YTD |
Booked Count YTD |
SUM(BSDF.BKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BKD_YTD_LY |
Booked Count YTD LY |
LAG(BSDF.BKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_YTD_LYP_CHG |
Booked Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.BKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BTTR |
Book to Ticket Rate |
(BSDF.TKD / BSDF.BKD) * 100 |
|
CFCNT_LP |
Confirmed LP |
LAG(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LP_PCT_CHG |
Confirmed % Change LP |
LAG_VARIANCE_PERCENT(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LY |
Confirmed LY |
LAG(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LY_CHG |
Confirmed Change LY |
LAG_VARIANCE(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LY_PCT_CHG |
Confirmed % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_RNK_OFC |
Confirmed Rank of Booking Office |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.CFCNT DESC NULLS LAST WITHIN PARENT) |
|
CFCNT_SHR_OFC |
Confirmed Share of Booking Office Parent |
SHARE(BSDF.CFCNT OF BKOFC.HBKOFC PARENT) |
|
CFCNT_YTD |
Confirmed Count YTD |
SUM(BSDF.CFCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CFCNT_YTD_LY |
Confirmed Count YTD LY |
LAG(BSDF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING |
|
CFCNT_YTD_LYP_CHG |
Confirmed Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LP |
Canceled LP |
LAG(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LP_PCT_CHG |
Canceled % Change LP |
LAG_VARIANCE_PERCENT(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LY |
Canceled LY |
LAG(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LY_CHG |
Canceled Change LY |
LAG_VARIANCE(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LY_PCT_CHG |
Canceled % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_RNK_OFC |
Canceled Rank of Booking Office |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.CLCNT DESC NULLS LAST WITHIN PARENT) |
|
CLCNT_SHR_OFC |
Canceled Share of Booking Office Parent |
SHARE(BSDF.CLCNT OF BKOFC.HBKOFC PARENT) |
|
CLCNT_YTD |
Canceled Count YTD |
SUM(BSDF.CLCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CLCNT_YTD_LY |
Canceled Count YTD LY |
LAG(BSDF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_YTD_LYP_CHG |
Canceled Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLFCF |
Canceled From Confirmed |
BSDF.CFCNT - BSDF.CLCNT |
|
CLFCF_LP |
Canceled From Confirmed LP |
BSDF.CFCNT_LP - BSDF.CLCNT_LP |
|
CLFCF_LP_PCT_CHG |
Canceled from Confirmed % Change LP |
((BSDF.CLFCF - BSDF.CLFCF_LP) / BSDF.CLFCF_LP) * 100 |
|
CLFCF_LY |
Canceled From Confirmed LY |
BSDF.CFCNT_LY - BSDF.CLCNT_LY |
|
CLFCF_LY_PCT_CHG |
Canceled from Confirmed % Change LY |
((BSDF.CLFCF - BSDF.CLFCF_LY) / BSDF.CLFCF_LY) * 100 |
|
CLRT |
Cancellation Rate |
(BSDF.CLCNT / BSDF.BKD) * 100 |
|
CLRT_LP |
Cancellation Rate LP |
(BSDF.CLCNT_LP / BSDF.BKD_LP) * 100 |
|
CPC_LP |
Coupons Count LP |
LAG(BSDF.CPC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CPC_LP_PCT_CHG |
Coupons Count % Change LP |
LAG_VARIANCE_PERCENT(BSDF.CPC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CPC_YTD |
Coupons Count YTD |
SUM(BSDF.CPC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CPC_YTD_LY |
Coupons Count YTD LY |
LAG(BSDF.CPC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CPC_YTD_LYP_CHG |
Coupons Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CPC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CSRVN_LP |
Code Share Revenue LP |
LAG(BSDF.CSRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CSRVN_LP_PCT_CHG |
Code Share Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.CSRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CSRVN_YTD |
Code Share Revenue YTD |
SUM(BSDF.CSRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CSRVN_YTD_LY |
Code Share Revenue YTD LY |
LAG(BSDF.CSRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CSRVN_YTD_LYP_CHG |
Code Share Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CSRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CTRVN_LP |
Charter Revenue LP |
LAG(BSDF.CTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CTRVN_LP_PCT_CHG |
Charter Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.CTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CTRVN_YTD |
Charter Revenue YTD |
SUM(BSDF.CTRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CTRVN_YTD_LY |
Charter Revenue YTD LY |
LAG(BSDF.CTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CTRVN_YTD_LYP_CHG |
Charter Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.CTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
EBRVN_LP |
Excess Bag Revenue LP |
LAG(BSDF.EBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
EBRVN_LP_PCT_CHG |
Excess Bag Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.EBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
EBRVN_YTD |
Excess Bag Revenue YTD |
SUM(BSDF.EBRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
EBRVN_YTD_LY |
Excess Bag Revenue YTD LY |
LAG(BSDF.EBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
EBRVN_YTD_LYP_CHG |
Excess Bag Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.EBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FES_LP |
Fees Revenue LP |
LAG(BSDF.FES, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FES_LP_PCT_CHG |
Fees Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.FES, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FES_YTD |
Fees Revenue YTD |
SUM(BSDF.FES) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FES_YTD_LY |
Fees Revenue YTD LY |
LAG(BSDF.FES_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FES_YTD_LYP_CHG |
Fees Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.FES_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPAX_LP |
Flown Passenger Count LP |
LAG(BSDF.FPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPAX_LP_PCT_CHG |
Flown Passenger Count % Change LP |
LAG_VARIANCE_PERCENT(BSDF.FPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPAX_YTD |
Flown Passenger Count YTD |
SUM(BSDF.FPAX) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FPAX_YTD_LY |
Flown Passenger Count YTD LY |
LAG(BSDF.FPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPAX_YTD_LYP_CHG |
Flown Passenger Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.FPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRVN_LP |
Flown Revenue LP |
LAG(BSDF.FRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRVN_LP_PCT_CHG |
Flown Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.FRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRVN_RNK_BKOFC |
Flown Revenue Ranking of Booking Office Parent |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.FRVN DESC NULLS LAST WITHIN ANCESTOR AT LEVEL BKOFC.TBKOFC) |
|
FRVN_RNK_CNTYP |
Flown Revenue Ranking of Channel Type Parent |
RANK() OVER HIERARCHY (BKOFC.HCNTYP ORDER BY BSDF.FRVN DESC NULLS LAST WITHIN PARENT) |
|
FRVN_YTD |
Flown Revenue YTD |
SUM(BSDF.FRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FRVN_YTD_LY |
Flown Revenue YTD LY |
LAG(BSDF.FRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRVN_YTD_LYP_CHG |
Flown Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.FRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
GBKD_LP |
Group Booked LP |
LAG(BSDF.GBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
GBKD_LP_PCT_CHG |
Group Booked % Change LP |
LAG_VARIANCE_PERCENT(BSDF.GBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
GBKD_YTD |
Group Booked YTD |
SUM(BSDF.GBKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
GBKD_YTD_LY |
Group Booked YTD LY |
LAG(BSDF.GBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
GBKD_YTD_LYP_CHG |
Group Booked YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.GBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
IBKD_LP |
Individual Booked LP |
LAG(BSDF.IBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
IBKD_LP_PCT_CHG |
Individual Booked % Change LP |
LAG_VARIANCE_PERCENT(BSDF.IBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
IBKD_YTD |
Individual Booked YTD |
SUM(BSDF.IBKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
IBKD_YTD_LY |
Individual Booked YTD LY |
LAG(BSDF.IBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
IBKD_YTD_LYP_CHG |
Individual Booked YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.IBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
MTLR |
Materialization Rate |
((BSDF.CFCNT - BSDF.CLFCF) / BSDF.CFCNT) * 100 |
|
MTLR_LP |
Materialization Rate LP |
((BSDF.CFCNT_LP - BSDF.CLFCF_LP) / BSDF.CFCNT_LP) * 100 |
|
MTLR_LP_PCT_CHG |
Materialization Rate % Change LP |
((BSDF.MTLR - BSDF.MTLR_LP) / BSDF.MTLR_LP) * 100 |
|
MTLR_LY |
Materialization Rate LY |
((BSDF.CFCNT_LY - BSDF.CLFCF_LY) / BSDF.CFCNT_LP) * 100 |
|
MTLR_LY_PCT_CHG |
Materialization Rate % Change LY |
((BSDF.MTLR - BSDF.MTLR_LY) / BSDF.MTLR_LY) * 100 |
|
NFPAX_LP |
Non Revenue Flown Passenger Count LP |
LAG(BSDF.NFPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
NFPAX_LP_PCT_CHG |
Non Revenue Flown Passenger Count % Change LP |
LAG_VARIANCE_PERCENT(BSDF.NFPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
NFPAX_YTD |
Non Revenue Flown Passenger Count YTD |
SUM(BSDF.NFPAX) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
NFPAX_YTD_LY |
Non Revenue Flown Passenger Count YTD LY |
LAG(BSDF.NFPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
NFPAX_YTD_LYP_CHG |
Non Revenue Flown Passenger Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.NFPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
NRPB |
Net Revenue Per Booking |
BSDF.NRVN / BSDF.BKD |
|
NRPB_LP |
Net Revenue Per Booking LP |
BSDF.NRVN_LP / BSDF.BKD_LP |
|
NRPB_LY |
Net Revenue Per Booking LY |
BSDF.NRVN_LY / BSDF.BKD_LY |
|
NRPB_LY_CHG |
Net Revenue Per Booking Change LY |
BSDF.NRPB - BSDF.NRPB_LY |
|
NRPB_LY_PCT_CHG |
Net Revenue Per Booking % Change LY |
(BSDF.NRPB_LY_CHG / BSDF.NRPB_LY) * 100 |
|
NRPP |
Net Revenue Per PAX |
BSDF.NRVN / BSDF.PXCNT |
|
NRPP_LP |
Net Revenue Per PAX LP |
BSDF.NRVN_LP / BSDF.PXCNT_LP |
|
NRPP_LY |
Net Revenue Per PAX LY |
BSDF.NRVN_LY / BSDF.PXCNT_LY |
|
NRPP_LY_CHG |
Net Revenue Per PAX Change LY |
BSDF.NRPP - BSDF.NRPP_LY |
|
NRPP_LY_PCT_CHG |
Net Revenue Per PAX % Change LY |
(BSDF.NRPP_LY_CHG / BSDF.NRPP_LY) * 100 |
|
NRPS |
Non Revenue Passenger Share |
(BSDF.NFPAX / BSDF.FPAX) * 100 |
|
NRVN |
Net Revenue |
BSDF.TRVN - (BSDF.OTCHR + BSDF.TXS) |
|
NRVN_LP |
Net Revenue LP |
BSDF.TRVN_LP - (BSDF.OTCHR_LP + BSDF.TXS_LP) |
|
NRVN_LY |
Net Revenue LY |
BSDF.TRVN_LY - (BSDF.OTCHR_LY + BSDF.TXS_LY) |
|
NRVN_LY_CHG |
Net Revenue Change LY |
BSDF.NRVN - BSDF.NRVN_LY |
|
NRVN_LY_PCT_CHG |
Net Revenue % Change LY |
(BSDF.NRVN_LY_CHG / BSDF.NRVN_LY) * 100 |
|
NTBKD |
Net Booked |
BSDF.BKD - BSDF.CLFCF |
|
NTBKD_LP |
Net Booked LP |
BSDF.BKD_LP - BSDF.CLFCF_LP |
|
NTBKD_LP_PCT_CHG |
Net Booked % Change LP |
((BSDF.NTBKD - BSDF.NTBKD_LP) / BSDF.NTBKD_LP) * 100 |
|
NTBKD_LY |
Net Booked LY |
BSDF.BKD_LY - BSDF.CLFCF_LY |
|
NTBKD_LY_PCT_CHG |
Net Booked % Change LY |
((BSDF.NTBKD - BSDF.NTBKD_LY) / BSDF.NTBKD_LY) * 100 |
|
NTCFD_YTD |
Net Confirmed YTD |
SUM(BSDF.NTCFD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
NTCFD_YTD_LY |
Net Confirmed YTD LY |
LAG(BSDF.NTCFD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
NTCFD_YTD_LYP_CHG |
Net Confirmed YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.NTCFD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OBRVN_LP |
Onboard Revenue LP |
LAG(BSDF.OBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OBRVN_LP_PCT_CHG |
Onboard Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.OBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OBRVN_YTD |
Onboard Revenue YTD |
SUM(BSDF.OBRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OBRVN_YTD_LY |
Onboard Revenue YTD LY |
LAG(BSDF.OBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OBRVN_YTD_LYP_CHG |
Onboard Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.OBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LP |
Other Charges LP |
LAG(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTCHR_LY |
Other Charges LY |
LAG(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LY_CHG |
Other Charges Change LY |
LAG_VARIANCE(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LY_PCT_CHG |
Other Charges % Change LY |
LAG_VARIANCE_PERCENT(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_YTD |
Other Charges YTD |
SUM(BSDF.OTCHR) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OTCHR_YTD_LY |
Other Charges YTD LY |
LAG(BSDF.OTCHR_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_YTD_LYP_CHG |
Other Charges YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.OTCHR_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTRVN_LP |
Other Revenue LP |
LAG(BSDF.OTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTRVN_LP_PCT_CHG |
Other Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.OTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTRVN_YTD |
Other Revenue YTD |
SUM(BSDF.OTRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OTRVN_YTD_LY |
Other Revenue YTD LY |
LAG(BSDF.OTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTRVN_YTD_LYP_CHG |
Other Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.OTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LP |
Passenger Count LP |
LAG(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PXCNT_LP_PCT_CHG |
Passenger Count % Change LP |
LAG_VARIANCE_PERCENT(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PXCNT_LY |
Passenger Count LY |
LAG(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LY_CHG |
Passenger Count Change LY |
LAG_VARIANCE(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LY_PCT_CHG |
Passenger Count % Change LY |
LAG_VARIANCE_PERCENT(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_RNK_RUT |
Passenger Count Rank of Route Parent |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.PXCNT DESC NULLS LAST WITHIN PARENT) |
|
PXCNT_YTD |
Passenger Count YTD |
SUM(BSDF.PXCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
PXCNT_YTD_LY |
Passenger Count YTD LY |
LAG(BSDF.PXCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_YTD_LYP_CHG |
Passenger Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.PXCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LP |
Ticked LP |
LAG(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKD_LP_PCT_CHG |
Ticketed % Change LP |
LAG_VARIANCE_PERCENT(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKD_LY |
Ticketed LY |
LAG(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LY_CHG |
Ticketed Change LY |
LAG_VARIANCE(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LY_PCT_CHG |
Ticketed % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_YTD |
Ticketed Count YTD |
SUM(BSDF.TKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TKD_YTD_LY |
Ticketed Count YTD LY |
LAG(BSDF.TKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_YTD_LYP_CHG |
Ticketed Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRPB |
Total Revenue Per Booking |
BSDF.TRVN / BSDF.BKD |
|
TRPB_LY |
Total Revenue Per Booking LY |
BSDF.TRVN_LY / BSDF.BKD_LY |
|
TRPB_LY_CHG |
Total Revenue Per Booking Change LY |
BSDF.TRPB - BSDF.TRPB_LY |
|
TRPB_LY_PCT_CHG |
Total Revenue Per Booking % Change LY |
(BSDF.TRPB_LY_CHG / BSDF.TRPB_LY) * 100 |
|
TRPP |
Total Revenue Per PAX |
BSDF.TRVN / BSDF.PXCNT |
|
TRPP_LY |
Total Revenue Per PAX LY |
BSDF.TRVN_LY / BSDF.PXCNT_LY |
|
TRPP_LY_CHG |
Total Revenue Per PAX Change LY |
BSDF.TRPP - BSDF.TRPP_LY |
|
TRPP_LY_PCT_CHG |
Total Revenue Per PAX % Change LY |
(BSDF.TRPP_LY_CHG / BSDF.TRPP_LY) * 100 |
|
TRVN_LP |
Total Revenue LP |
LAG(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TRVN_LP_PCT_CHG |
Total Revenue % Change LP |
LAG_VARIANCE_PERCENT(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TRVN_LY |
Total Revenue LY |
LAG(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_LY_CHG |
Total Revenue Change LY |
LAG_VARIANCE(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_LY_PCT_CHG |
Total Revenue % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_RNK_BKOFC |
Total Revenue Rank of Booking Office Parent |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.TRVN DESC NULLS LAST WITHIN PARENT) |
|
TRVN_RNK_RUT |
Total Revenue Rank of Route Parent |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.TRVN DESC NULLS LAST WITHIN PARENT) |
|
TRVN_YTD |
Total Revenue YTD |
SUM(BSDF.TRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TRVN_YTD_LY |
Total Revenue YTD LY |
LAG(BSDF.TRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_YTD_LYP_CHG |
Total Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LP |
Taxes LP |
LAG(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TXS_LY |
Taxes LY |
LAG(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LY_CHG |
Taxes Change LY |
LAG_VARIANCE(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LY_PCT_CHG |
Taxes % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_YTD |
Taxes YTD |
SUM(BSDF.TXS) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TXS_YTD_LY |
Taxes YTD LY |
LAG(BSDF.TXS_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_YTD_LYP_CHG |
Taxes YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.TXS_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LP |
Waitlist LP |
LAG(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME) |
|
WTLST_LY |
Waitlist LY |
LAG(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LY_CHG |
Waitlist Change LY |
LAG_VARIANCE(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LY_PCT_CHG |
Waitlist % Change LY |
LAG_VARIANCE_PERCENT(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_YTD |
Wait Listed Count YTD |
SUM(BSDF.WTLST) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
WTLST_YTD_LY |
Wait Listed Count YTD LY |
LAG(BSDF.WTLST_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_YTD_LYP_CHG |
Wait Listed Count YTD % Change LY |
LAG_VARIANCE_PERCENT(BSDF.WTLST_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
Contains the summarized booking segment departure fact forecast information.
Table 8-6 briefly describes the Dimensions and Load Level.
Table 8-6 Booking Segment Departure Fact Forecast Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
BKCLS |
BKCLS |
|
ROUTE |
ROUTE |
|
OPFLT |
OPFLT |
|
OPSMT |
OPSMT |
|
BKOFC |
AGNT |
Table 8-7 briefly describes the Aggregation Operator and Order
Table 8-7 Booking Segment Departure Fact Forecast Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
sum |
1 |
|
BKCLS |
sum |
2 |
|
BKOFC |
sum |
3 |
|
OPFLT |
sum |
4 |
|
OPSMT |
sum |
5 |
|
ROUTE |
sum |
6 |
Table 8-8 briefly describes the Base Measures
Table 8-8 Booking Segment Departure Fact Forecast Base Measures
| Physical Name | Logical Name | Physical Column |
|---|---|---|
|
BKD_F |
Booked Forecast |
Booked Forecast |
|
GBKD_F |
Group Booked Forecast |
Group Booked Forecast |
|
IBKD_F |
Individual Booked Forecast |
Individual Booked Forecast |
|
PXCNT_F |
Passenger Count Forecast |
Passenger Count Forecast |
|
TRVN_F |
Total Revenue Forecast |
Total Revenue Forecast |
Table 8-9 briefly describes the Derived Measures.
Contains the summarized call center performance information.
Table 8-10 briefly describes the Dimensions and Load Level.
Table 8-10 Call Center Performance Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
BKOFC |
AGNT |
Table 8-11 briefly describes the Aggregation Operator and Order
Table 8-11 Call Center Performance Fact Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
sum |
1 |
|
BKOFC |
sum |
2 |
Table 8-12 briefly describes the Base Measures
Table 8-12 Call Center Performance Fact Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
CCNT |
Total number of call |
DWA_DLY_CC_PRFM.CALL_CNT |
Total number of call |
|
ACCNT |
Total number of accessible call |
DWA_DLY_CC_PRFM.ACSBL_CNT |
Total number of accessible call |
|
STCNT |
Total number of satisfy call |
DWA_DLY_CC_PRFM.STFY_CNT |
Total number of satisfy call |
|
CMIN |
Total minute of call duration |
DWA_DLY_CC_PRFM.MIN_AMT |
Total minute of call duration |
|
AGCNT |
Working agent count |
DWA_DLY_CC_PRFM.AGNT_CNT |
Working agent count |
Table 8-13 briefly describes the Derived Measures
Table 8-13 Call Center Performance Fact Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
ACCNT_LP |
Total Number of Accessible Call LP |
LAG(CCPF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_LP_PCT_CHG |
Total Number of Accessible Call % Change LP |
LAG_VARIANCE_PERCENT(CCPF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_YTD |
Total Number of Accessible Call YTD |
SUM(CCPF.ACCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ACCNT_YTD_LY |
Total Number of Accessible Call YTD LY |
LAG(CCPF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
ACCNT_YTD_LYP_CHG |
Total Number of Accessible Call YTD % Change LY |
LAG_VARIANCE_PERCENT(CCPF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
AGCNT_LP |
Working Agent Count LP |
LAG(CCPF.AGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
AGCNT_LP_PCT_CHG |
Working Agent Count % Change LP |
LAG_VARIANCE_PERCENT(CCPF.AGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
AGCNT_YTD |
Working Agent Count YTD |
SUM(CCPF.AGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
AGCNT_YTD_LY |
Working Agent Count YTD LY |
LAG(CCPF.AGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
AGCNT_YTD_LYP_CH |
Working Agent Count YTD % Change LY |
LAG_VARIANCE_PERCENT(CCPF.AGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CCNT_LP |
Total Number of Call LP |
LAG(CCPF.CCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CCNT_LP_PCT_CHG |
Total Number of Call % Change LP |
LAG_VARIANCE_PERCENT(CCPF.CCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CCNT_YTD |
Total Number of Call YTD |
SUM(CCPF.CCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CCNT_YTD_LY |
Total Number of Call YTD LY |
LAG(CCPF.CCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CCNT_YTD_LYP_CHG |
Total Number of Call YTD % Change LY |
LAG_VARIANCE_PERCENT(CCPF.CCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CMIN_LP |
Total Minute of Call Duration LP |
LAG(CCPF.CMIN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CMIN_LP_PCT_CHG |
Total Minute of Call Duration % Change LP |
LAG_VARIANCE_PERCENT(CCPF.CMIN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CMIN_YTD |
Total Minute of Call Duration YTD |
SUM(CCPF.CMIN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CMIN_YTD_LY |
Total Minute of Call Duration YTD LY |
LAG(CCPF.CMIN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CMIN_YTD_LYP_CHG |
Total Minute of Call Duration YTD % Change LY |
LAG_VARIANCE_PERCENT(CCPF.CMIN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
STCNT_LP |
Total Number of Satisfy Call LP |
LAG(CCPF.STCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STCNT_LP_PCT_CHG |
Total Number of Satisfy Call % Change LP |
LAG_VARIANCE_PERCENT(CCPF.STCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STCNT_YTD |
Total Number of Satisfy Call YTD |
SUM(CCPF.STCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
STCNT_YTD_LY |
Total Number of Satisfy Call YTD LY |
LAG(CCPF.STCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
STCNT_YTD_LYP_CHG |
Total Number of Satisfy Call YTD % Change LY |
LAG_VARIANCE_PERCENT(CCPF.STCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
Contains the summarized customer survey daily information.
Table 8-14 briefly describes the Dimensions and Load Level.
Table 8-14 Customer Survey Daily Fact Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
IRSN |
IRSN |
|
SRV |
SRVC |
Table 8-15 briefly describes the Aggregation Operator and Order.
Table 8-15 Customer Survey Daily Fact Cube Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
SUM |
1 |
|
IRSN |
SUM |
2 |
|
SRVC |
SUM |
3 |
Table 8-16 briefly describes the Base Measures.
Table 8-16 Customer Survey Daily Fact Cube Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
STFC |
Satisfy Count |
DWA_DLY_CUST_SURVEY.STFY_CNT |
Satisfy Count |
|
TSRC |
Total Survey Count |
DWA_DLY_CUST_SURVEY.TOT_SURVEY_CNT |
Total Survey Count |
Table 8-17 briefly describes the Derived Measures.
Table 8-17 Customer Survey Daily Fact Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
STFC_LP |
Satisfy Count LP |
LAG(CSDF.STFC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STFC_LP_PCT_CHG |
Satisfy Count % Change LP |
LAG_VARIANCE_PERCENT(CSDF.STFC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STFC_YTD |
Satisfy Count YTD |
SUM(CSDF.STFC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
STFC_YTD_LY |
Satisfy Count YTD LY |
LAG(CSDF.STFC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
STFC_YTD_LYP_CHG |
Satisfy Count YTD % Change LY |
LAG_VARIANCE_PERCENT(CSDF.STFC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TSRC_LP |
Total Survey Count LP |
LAG(CSDF.TSRC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TSRC_LP_PCT_CHG |
Total Survey Count % Change LP |
LAG_VARIANCE_PERCENT(CSDF.TSRC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TSRC_YTD |
Total Survey Count YTD |
SUM(CSDF.TSRC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TSRC_YTD_LY |
Total Survey Count YTD LY |
LAG(CSDF.TSRC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TSRC_YTD_LYP_CHG |
Total Survey Count YTD % Change LY |
LAG_VARIANCE_PERCENT(CSDF.TSRC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
Contains the summarized flight detail daily information.
Table 8-18 briefly describes the Dimensions and Load Level.
Table 8-18 Flight Detail Daily Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
OPSMT |
OPSMT |
|
OPFLT |
OPFLT |
Table 8-19 briefly describes the Aggregation Operator and Order.
Table 8-19 Flight Detail Daily Cube Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
SUM |
1 |
|
OPSMT |
SUM |
2 |
|
OPFLT |
SUM |
3 |
Table 8-20 briefly describes the Base Measures.
Table 8-20 Flight Detail Daily Cube Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
SBCP |
Saleable Total Capacity |
DWA_DLY_FLT_DETLS.SALEBLE_TOT_CPCTY |
Total number of saleable seat |
|
DTFL |
Distance Flown |
DWA_DLY_FLT_DETLS.NAUTICAL_MLS |
The distance flown between the origin and destination |
Table 8-21 briefly describes the Derived Measures.
Table 8-21 Flight Detail Daily Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
DTFL_LP |
Distance Flown LP |
LAG(FDDF.DTFL, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PASK |
Passenger Available Seat Kilometer |
FDDF.DTFL * FDDF.SBCP |
|
PASK_LP |
Passenger Available Seat Kilometer LP |
FDDF.DTFL_LP * FDDF.SBCP_LP |
|
SBCP_LP |
Saleable Total Capacity LP |
LAG(FDDF.SBCP, 1) OVER HIERARCHY ("TIME".HTIME) |
Contains the summarized loyalty account information.
Table 8-22 briefly describes the Dimensions and Load Level.
Table 8-22 Loyalty Account Fact Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
GEO |
CITY |
|
LOYLV |
LOYLY |
Table 8-23 briefly describes the Aggregation Operator and Order.
Table 8-23 Loyalty Account Fact Cube Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
SUM |
1 |
|
GEO |
SUM |
2 |
|
LOYLV |
SUM |
3 |
Table 8-24 briefly describes the Base Measures.
Table 8-24 Loyalty Account Fact Cube Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
LYCNT |
Loyalty Account Count |
DWA_DLY_LYLTY_ACCT.LYLTY_ACCT_CNT |
Loyalty Account Count |
|
UGCNT |
Upgrade Count |
DWA_DLY_LYLTY_ACCT.UGRD_CNT |
Upgrade Count |
|
DGCNT |
Downgrade Count |
DWA_DLY_LYLTY_ACCT.DGRD_CNT |
Downgrade Count |
|
ATCNT |
Active Account Count |
DWA_DLY_LYLTY_ACCT.ACTV_CNT |
Active Account Count |
|
TAML |
The Total Mils Amount in Accounts |
DWA_DLY_LYLTY_ACCT.TOT_MILES_AMT |
The Total Mils Amount in Accounts |
|
TMED |
The Total Mils Amount Earned in Accounts |
DWA_DLY_LYLTY_ACCT.MILES_ERND_AMT |
The Total Mils Amount Earned in Accounts |
|
TMRD |
The Total Mils Amount Redeemed in Accounts |
DWA_DLY_LYLTY_ACCT.MILES_RDMD_AMT |
The Total Mils Amount Redeemed in Accounts |
Table 8-25 briefly describes the Derived Measures.
Table 8-25 Loyalty Account Fact Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
ATCNT_LP |
Active Account Count LP |
LAG(LYAF.ATCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ATCNT_LP_PCT_CHG |
Active Account Count % Change LP |
LAG_VARIANCE_PERCENT(LYAF.ATCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ATCNT_YTD |
Active Account Count YTD |
SUM(LYAF.ATCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ATCNT_YTD_LY |
Active Account Count YTD LY |
LAG(LYAF.ATCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
ATCNT_YTD_LYP_CHG |
Active Account Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.ATCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
DGCNT_LP |
Downgrade Count LP |
LAG(LYAF.DGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
DGCNT_LP_PCT_CHG |
Downgrade Count % Change LP |
LAG_VARIANCE_PERCENT(LYAF.DGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
DGCNT_YTD |
Downgrade Count YTD |
SUM(LYAF.DGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
DGCNT_YTD_LY |
Downgrade Count YTD LY |
LAG(LYAF.DGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
DGCNT_YTD_LYP_CHG |
Downgrade Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.DGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LYCNT_LP |
Loyalty Account Count LP |
LAG(LYAF.LYCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LYCNT_LP_PCT_CHG |
Loyalty Account Count % Change LP |
LAG_VARIANCE_PERCENT(LYAF.LYCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LYCNT_YTD |
Loyalty Account Count YTD |
SUM(LYAF.LYCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
LYCNT_YTD_LY |
Loyalty Account Count YTD LY |
LAG(LYAF.LYCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LYCNT_YTD_LYP_CHG |
Loyalty Account Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.LYCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TAML_LP |
The Total Mils Amount in Accounts LP |
LAG(LYAF.TAML, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TAML_LP_PCT_CHG |
The Total Mils Amount in Accounts % Change LP |
LAG_VARIANCE_PERCENT(LYAF.TAML, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TAML_YTD |
The Total Mils Amount in Accounts YTD |
SUM(LYAF.TAML) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TAML_YTD_LY |
The Total Mils Amount in Accounts YTD LY |
LAG(LYAF.TAML_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TAML_YTD_LYP_CHG |
The Total Mils Amount in Accounts YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.TAML_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMED_LP |
The Total Mils Amount Earned in Accounts LP |
LAG(LYAF.TMED, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMED_LP_PCT_CHG |
The Total Mils Amount Earned in Accounts % Change LP |
LAG_VARIANCE_PERCENT(LYAF.TMED, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMED_YTD |
The Total Mils Amount Earned in Accounts YTD |
SUM(LYAF.TMED) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TMED_YTD_LY |
The Total Mils Amount Earned in Accounts YTD LY |
LAG(LYAF.TMED_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMED_YTD_LYP_CHG |
The Total Mils Amount Earned in Accounts YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.TMED_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMRD_LP |
The Total Mils Amount Redeemed in Accounts LP |
LAG(LYAF.TMRD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMRD_LP_PCT_CHG |
The Total Mils Amount Redeemed in Accounts % Change LP |
LAG_VARIANCE_PERCENT(LYAF.TMRD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMRD_YTD |
The Total Mils Amount Redeemed in Accounts YTD |
SUM(LYAF.TMRD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TMRD_YTD_LY |
The Total Mils Amount Redeemed in Accounts YTD LY |
LAG(LYAF.TMRD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMRD_YTD_LYP_CHG |
The Total Mils Amount Redeemed in Accounts YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.TMRD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
UGCNT_LP |
Upgrade Count LP |
LAG(LYAF.UGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
UGCNT_LP_PCT_CHG |
Upgrade Count % Change LP |
LAG_VARIANCE_PERCENT(LYAF.UGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
UGCNT_YTD |
Upgrade Count YTD |
SUM(LYAF.UGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
UGCNT_YTD_LY |
Upgrade Count YTD LY |
LAG(LYAF.UGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
UGCNT_YTD_LYP_CHG |
Upgrade Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYAF.UGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
Contains the summarized loyalty account booking information.
Table 8-26 briefly describes the Dimensions and Load Level.
Table 8-26 Loyalty Booking Fact Cube Dimensions and Load Level
| Dimensions | Load Level |
|---|---|
|
TIME |
DAY |
|
LOYLV |
LOYLY |
|
BKOFC |
AGNT |
Table 8-27 briefly describes the Aggregation Operator and Order.
Table 8-27 Loyalty Booking Fact Cube Aggregation Operator and Order
| Dimension Name | Operator | Order |
|---|---|---|
|
TIME |
SUM |
1 |
|
LOYLV |
SUM |
2 |
|
BKOFC |
SUM |
3 |
Table 8-28 briefly describes the Base Measures.
Table 8-28 Loyalty Booking Fact Cube Base Measures
| Physical Name | Logical Name | Physical Column | Description |
|---|---|---|---|
|
LACNT |
Loyalty Account Count |
DWA_DLY_LA_BKG.LYLTY_ACCT_CNT |
Loyalty Account Count |
|
ACCNT |
Active Account Count |
DWA_DLY_LA_BKG.ACTV_CNT |
Active Account Count |
|
PCNT |
Passenger Count |
DWA_DLY_LA_BKG.PAX_CNT |
Passenger Count |
|
BKCNT |
Booked Count |
DWA_DLY_LA_BKG.BKD |
Booked Count |
|
CFCNT |
The Confirmed Booking Count |
DWA_DLY_LA_BKG.CONFMD_CNT |
The Confirmed Booking Count |
|
CLCNT |
The Canceled Booking Count |
DWA_DLY_LA_BKG.CNCLD_CNT |
The Canceled Booking Count |
|
FPCNT |
The Flown Passenger Count |
DWA_DLY_LA_BKG.FLN_PAX_CNT |
The Flown Passenger Count |
|
FRAC |
The Flown Revenue Contributed by Active Account |
DWA_DLY_LA_BKG.FLN_REV_BY_ACTV |
The Flown Revenue Contributed by Active Account |
|
FLRVN |
The Flown Revenue |
DWA_DLY_LA_BKG.FLN_REV |
The Flown Revenue |
|
FTCNT |
The Flight Count |
DWA_DLY_LA_BKG.FLT_CNT |
The Flight Count |
|
TKAMT |
Ticket Amount |
DWA_DLY_LA_BKG.TKT_AMT |
Ticket Amount |
Table 8-29 briefly describes the Derived Measures.
Table 8-29 Loyalty Booking Fact Cube Derived Measures
| Physical Name | Logical Name | Definition |
|---|---|---|
|
ACCNT_LP |
Active Account Count LP |
LAG(LYBF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_LP_PCT_CHG |
Active Account Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_YTD |
Active Account Count YTD |
SUM(LYBF.ACCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ACCNT_YTD_LY |
Active Account Count YTD LY |
LAG(LYBF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
ACCNT_YTD_LYP_CHG |
Active Account Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKCNT_LP |
Booked Count LP |
LAG(LYBF.BKCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKCNT_LP_PCT_CHG |
Booked Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.BKCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKCNT_YTD |
Booked Count YTD |
SUM(LYBF.BKCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BKCNT_YTD_LY |
Booked Count YTD LY |
LAG(LYBF.BKCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKCNT_YTD_LYP_CHG |
Booked Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.BKCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LP |
The Confirmed Booking Count LP |
LAG(LYBF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LP_PCT_CHG |
The Confirmed Booking Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_YTD |
The Confirmed Booking Count YTD |
SUM(LYBF.CFCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CFCNT_YTD_LY |
The Confirmed Booking Count YTD LY |
LAG(LYBF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_YTD_LYP_CHG |
The Confirmed Booking Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LP |
The Canceled Booking Count LP |
LAG(LYBF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LP_PCT_CHG |
The Canceled Booking Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_YTD |
The Canceled Booking Count YTD |
SUM(LYBF.CLCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CLCNT_YTD_LY |
The Canceled Booking Count YTD LY |
LAG(LYBF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_YTD_LYP_CHG |
The Canceled Booking Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FLRVN_LP |
The Flown Revenue LP |
LAG(LYBF.FLRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FLRVN_LP_PCT_CHG |
The Flown Revenue % Change LP |
LAG_VARIANCE_PERCENT(LYBF.FLRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FLRVN_YTD |
The Flown Revenue YTD |
SUM(LYBF.FLRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FLRVN_YTD_LY |
The Flown Revenue YTD LY |
LAG(LYBF.FLRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FLRVN_YTD_LYP_CHG |
The Flown Revenue YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.FLRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPCNT_LP |
The Flown Passenger Count LP |
LAG(LYBF.FPCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPCNT_LP_PCT_CHG |
The Flown Passenger Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.FPCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPCNT_YTD |
The Flown Passenger Count YTD |
SUM(LYBF.FPCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FPCNT_YTD_LY |
The Flown Passenger Count YTD LY |
LAG(LYBF.FPCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPCNT_YTD_LYP_CHG |
The Flown Passenger Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.FPCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRAC_LP |
The Flown Revenue Contributed by Active Account LP |
LAG(LYBF.FRAC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRAC_LP_PCT_CHG |
The Flown Revenue Contributed by Active Account % Change LP |
LAG_VARIANCE_PERCENT(LYBF.FRAC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRAC_YTD |
The Flown Revenue Contributed by Active Account YTD |
SUM(LYBF.FRAC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FRAC_YTD_LY |
The Flown Revenue Contributed by Active Account YTD LY |
LAG(LYBF.FRAC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRAC_YTD_LYP_CHG |
The Flown Revenue Contributed by Active Account YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.FRAC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FTCNT_LP |
The Flight Count LP |
LAG(LYBF.FTCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FTCNT_LP_PCT_CHG |
The Flight Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.FTCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FTCNT_YTD |
The Flight Count YTD |
SUM(LYBF.FTCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FTCNT_YTD_LY |
The Flight Count YTD LY |
LAG(LYBF.FTCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FTCNT_YTD_LYP_CHG |
The Flight Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.FTCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LACNT_LP |
Loyalty Account Count LP |
LAG(LYBF.LACNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LACNT_LP_PCT_CHG |
Loyalty Account Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.LACNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LACNT_YTD |
Loyalty Account Count YTD |
SUM(LYBF.LACNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
LACNT_YTD_LY |
Loyalty Account Count YTD LY |
LAG(LYBF.LACNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LACNT_YTD_LYP_CHG |
Loyalty Account Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.LACNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PCNT_LP |
Passenger Count LP |
LAG(LYBF.PCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PCNT_LP_PCT_CHG |
Passenger Count % Change LP |
LAG_VARIANCE_PERCENT(LYBF.PCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PCNT_YTD |
Passenger Count YTD |
SUM(LYBF.PCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
PCNT_YTD_LY |
Passenger Count YTD LY |
LAG(LYBF.PCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PCNT_YTD_LYP_CHG |
Passenger Count YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.PCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKAMT_LP |
Ticket Amount LP |
LAG(LYBF.TKAMT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKAMT_LP_PCT_CHG |
Ticket Amount % Change LP |
LAG_VARIANCE_PERCENT(LYBF.TKAMT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKAMT_YTD |
Ticket Amount YTD |
SUM(LYBF.TKAMT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TKAMT_YTD_LY |
Ticket Amount YTD LY |
LAG(LYBF.TKAMT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKAMT_YTD_LYP_CHG |
Ticket Amount YTD % Change LY |
LAG_VARIANCE_PERCENT(LYBF.TKAMT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |