Describes the OLAP model cubes.
Parent topic: Intra-ETL, OLAP, Data Mining, and Utility Scripts
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
The following table lists the Oracle Airlines Data Model OLAP cubes:
Table 8-1 Oracle Airlines Data Model OLAP Cubes
Cube | Physical Name |
---|---|
BSDF |
|
BSDF_F |
|
CCPF |
|
CSDF |
|
FDDF |
|
LYAF |
|
LYBF |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized booking segment departure information.
Physical Name: BSDF
Dimensions and Load Level
The following table 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 |
Aggregation Order/Operator
The following table 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 |
Base Measures
The following table 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 |
Derived Measures
The following table 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized booking segment departure fact forecast information.
Physical Name: BSDF_F
Dimensions and Load Level
The following table 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 |
Aggregation Order/Operator
The following table 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 |
Base Measures
The following table 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 |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized call center performance information.
Physical Name: CCPF
Dimensions and Load Level
The following table briefly describes the Dimensions and Load Level:
Table 8-9 Call Center Performance Cube Dimensions and Load Level
Dimensions | Load Level |
---|---|
TIME |
DAY |
BKOFC |
AGNT |
Aggregation Order/Operator
The following table briefly describes the Aggregation Operator and Order:
Table 8-10 Call Center Performance Fact Aggregation Operator and Order
Dimension Name | Operator | Order |
---|---|---|
TIME |
sum |
1 |
BKOFC |
sum |
2 |
Base Measures
The following table briefly describes the Base Measures:
Table 8-11 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 |
Derived Measures
The following table briefly describes the Derived Measures:
Table 8-12 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized customer survey daily information.
Physical Name: CSDF
Dimensions and Load Level
The following table briefly describes the Dimensions and Load Level:
Table 8-13 Customer Survey Daily Fact Cube Dimensions and Load Level
Dimensions | Load Level |
---|---|
TIME |
DAY |
IRSN |
IRSN |
SRV |
SRVC |
Aggregation Order/Operator
The following table briefly describes the Aggregation Operator and Order:
Table 8-14 Customer Survey Daily Fact Cube Aggregation Operator and Order
Dimension Name | Operator | Order |
---|---|---|
TIME |
SUM |
1 |
IRSN |
SUM |
2 |
SRVC |
SUM |
3 |
Base Measures
The following table briefly describes the Base Measures:
Table 8-15 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 |
Derived Measures
The following table briefly describes the Derived Measures:
Table 8-16 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized flight detail daily information.
Physical Name: FDDF
Dimensions and Load Level
The following table briefly describes the Dimensions and Load Level:
Table 8-17 Flight Detail Daily Cube Dimensions and Load Level
Dimensions | Load Level |
---|---|
TIME |
DAY |
OPSMT |
OPSMT |
OPFLT |
OPFLT |
Aggregation Order/Operator
The following table briefly describes the Aggregation Operator and Order:
Table 8-18 Flight Detail Daily Cube Aggregation Operator and Order
Dimension Name | Operator | Order |
---|---|---|
TIME |
SUM |
1 |
OPSMT |
SUM |
2 |
OPFLT |
SUM |
3 |
Base Measures
The following table briefly describes the Base Measures:
Table 8-19 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 |
Derived Measures
The following table briefly describes the Derived Measures:
Table 8-20 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized loyalty account information.
Physical Name: LYAF
Dimensions and Load Level
The following table briefly describes the Dimensions and Load Level:
Table 8-21 Loyalty Account Fact Cube Dimensions and Load Level
Dimensions | Load Level |
---|---|
TIME |
DAY |
GEO |
CITY |
LOYLV |
LOYLY |
Aggregation Order/Operator
The following table briefly describes the Aggregation Operator and Order:
Table 8-22 Loyalty Account Fact Cube Aggregation Operator and Order
Dimension Name | Operator | Order |
---|---|---|
TIME |
SUM |
1 |
GEO |
SUM |
2 |
LOYLV |
SUM |
3 |
Base Measures
The following table briefly describes the Base Measures:
Table 8-23 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 |
Derived Measures
The following table briefly describes the Derived Measures:
Table 8-24 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes
Contains the summarized loyalty account booking information.
Physical Name: LYBF
Dimensions and Load Level
The following table briefly describes the Dimensions and Load Level:
Table 8-25 Loyalty Booking Fact Cube Dimensions and Load Level
Dimensions | Load Level |
---|---|
TIME |
DAY |
LOYLV |
LOYLY |
BKOFC |
AGNT |
Aggregation Order/Operator
The following table briefly describes the Aggregation Operator and Order:
Table 8-26 Loyalty Booking Fact Cube Aggregation Operator and Order
Dimension Name | Operator | Order |
---|---|---|
TIME |
SUM |
1 |
LOYLV |
SUM |
2 |
BKOFC |
SUM |
3 |
Base Measures
The following table briefly describes the Base Measures:
Table 8-27 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 |
Derived Measures
The following table briefly describes the Derived Measures:
Table 8-28 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) |
Parent topic: Oracle Airlines Data Model OLAP Model Cubes