| Oracle® Airlines Data Modelリファレンス 11gリリース2 (11.2) B72453-01 |
|
 前 |
 次 |
この章の内容は次のとおりです。
詳細は、第7章「Oracle Airlines Data Model OLAPモデル・ディメンション」を参照してください。
各項には、各キューブに関する次の情報が含まれます。
説明
ディメンション(リーフ・ロード・レベルおよびロード順序)
ベース・メジャーと物理マッピングおよび説明
導出メジャーと論理名および計算
表8-1に、Oracle Airlines Data Model OLAPキューブのリストを示します。
表8-1 Oracle Airlines Data Model OLAPキューブ
| キューブ | 物理名 |
|---|---|
|
|
BSDF |
|
|
BSDF_F |
|
コール・センター・パフォーマンス・ファクト・キューブ: CCPF |
CCPF |
|
|
CSDF |
|
|
FDDF |
|
|
LYAF |
|
|
LYBF |
物理名: BSDF
ディメンションおよびロード・レベル
表8-2に、ディメンションおよびロード・レベルの簡単な説明を示します。
表8-2 予約セグメント出発ファクト・キューブのディメンションおよびロード・レベル
| ディメンション | ロード・レベル |
|---|---|
|
TIME |
DAY |
|
BKCLS |
BKCLS |
|
ROUTE |
ROUTE |
|
OPFLT |
OPFLT |
|
OPSMT |
OPSMT |
|
BKOFC |
AGNT |
集計の順序/演算子
表8-3に、集計の順序/演算子の簡単な説明を示します。
表8-3 予約セグメント出発ファクト・キューブの集計の演算子および順序
| ディメンション名 | 演算子 | 順序 |
|---|---|---|
|
TIME |
sum |
1 |
|
BKCLS |
sum |
2 |
|
BKOFC |
sum |
3 |
|
OPFLT |
sum |
4 |
|
OPSMT |
sum |
5 |
|
ROUTE |
sum |
6 |
ベース・メジャー
表8-4に、ベース・メジャーの簡単な説明を示します。
表8-4 予約セグメント出発ファクト・キューブのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
BKD |
予約数 |
DWA_DLY_BKG_FACT.BKD |
予約数 |
|
CFCNT |
確認数 |
DWA_DLY_BKG_FACT.CONFMD_CNT |
確認数 |
|
CLCNT |
キャンセル数 |
DWA_DLY_BKG_FACT.CNCLD_CNT |
キャンセル数 |
|
TKD |
チケット発行数 |
DWA_DLY_BKG_FACT.TKTD |
チケット発行数 |
|
NTCFD |
正味の確認済 |
DWA_DLY_BKG_FACT.NET_CONFMD |
正味の確認済 |
|
GBKD |
グループ予約 |
DWA_DLY_BKG_FACT.GRP_BKD_QTY |
グループ予約 |
|
IBKD |
個人予約 |
DWA_DLY_BKG_FACT.INDV_BKD_QTY |
個人予約 |
|
OTCHR |
その他の課金 |
DWA_DLY_BKG_FACT.OTR_CHARGES |
その他の課金 |
|
TXS |
税金 |
DWA_DLY_BKG_FACT.TAX_AMT |
税金 |
|
TRVN |
総収益 |
DWA_DLY_BKG_FACT.TKT_AMT |
総収益 |
|
PXCNT |
乗客数 |
DWA_DLY_BKG_FACT.PAX_CNT |
乗客数 |
|
WTLST |
待機リスト数 |
DWA_DLY_BKG_FACT.WAITLISED |
待機リスト数 |
|
FRVN |
飛行収益 |
DWA_DLY_BKG_FACT.FLN_REV |
飛行収益 |
|
FPAX |
飛行乗客数 |
DWA_DLY_BKG_FACT.FLN_PAX_CNT |
飛行乗客数 |
|
NFPAX |
収益外の飛行乗客数 |
DWA_DLY_BKG_FACT.NON_REV_FLN_PAX_CNT |
収益外の飛行乗客数 |
|
CPC |
クーポン数 |
DWA_DLY_BKG_FACT.CPN_CNT |
クーポン数 |
|
OBRVN |
搭乗収益 |
DWA_DLY_BKG_FACT.ONBRD_REV |
搭乗収益 |
|
EBRVN |
超過荷物収益 |
DWA_DLY_BKG_FACT.EXCESS_BAG_REV |
超過荷物収益 |
|
FES |
料金収益 |
DWA_DLY_BKG_FACT.FEES_REV |
料金収益 |
|
CTRVN |
チャータ収益 |
DWA_DLY_BKG_FACT.CHARTER_REV |
チャータ収益 |
|
BCRVN |
ベリー・カーゴ収益 |
DWA_DLY_BKG_FACT.BELLY_CARGO_REV |
ベリー・カーゴ収益 |
|
CSRVN |
コード共有収益 |
DWA_DLY_BKG_FACT.CDSH_REV |
コード共有収益 |
|
OTRVN |
その他の収益 |
DWA_DLY_BKG_FACT.OTR_REV |
その他の収益 |
導出メジャー
表8-5に、導出メジャーの簡単な説明を示します。
表8-5 予約セグメント出発ファクト・キューブの導出メジャー
| 物理名 | 論理名 | 定義 |
|---|---|---|
|
BCRVN_LP |
ベリー・カーゴ収益LP |
LAG(BSDF.BCRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BCRVN_LP_PCT_CHG |
ベリー・カーゴ収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.BCRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BCRVN_YTD |
ベリー・カーゴ収益YTD |
SUM(BSDF.BCRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BCRVN_YTD_LY |
ベリー・カーゴ収益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 |
ベリー・カーゴ収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.BCRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKCR |
予約変換率 |
(BSDF.NTCFD / BSDF.NTBKD) * 100 |
|
BKD_LP |
予約LP |
LAG(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKD_LP_PCT_CHG |
予約%変更LP |
LAG_VARIANCE_PERCENT(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKD_LY |
予約LY |
LAG(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_LY_CHG |
予約変更LY |
LAG_VARIANCE(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_LY_PCT_CHG |
予約%変更LY |
LAG_VARIANCE_PERCENT(BSDF.BKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKD_RNK_OFC |
予約オフィスの親の予約ランク |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.BKD DESC NULLS LAST WITHIN PARENT) |
|
BKD_RNK_RUT |
航路の親の予約ランク |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.BKD DESC NULLS LAST WITHIN PARENT) |
|
BKD_SHR_OFC |
予約オフィスの親の予約共有 |
SHARE(BSDF.BKD OF BKOFC.HBKOFC PARENT) |
|
BKD_YTD |
予約数YTD |
SUM(BSDF.BKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BKD_YTD_LY |
予約数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 |
予約数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.BKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BTTR |
予約とチケットの比率 |
(BSDF.TKD / BSDF.BKD) * 100 |
|
CFCNT_LP |
確認LP |
LAG(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LP_PCT_CHG |
確認%変更LP |
LAG_VARIANCE_PERCENT(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LY |
確認LY |
LAG(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LY_CHG |
確認変更LY |
LAG_VARIANCE(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LY_PCT_CHG |
確認%変更LY |
LAG_VARIANCE_PERCENT(BSDF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_RNK_OFC |
予約オフィスの確認ランク |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.CFCNT DESC NULLS LAST WITHIN PARENT) |
|
CFCNT_SHR_OFC |
予約オフィスの親の確認共有 |
SHARE(BSDF.CFCNT OF BKOFC.HBKOFC PARENT) |
|
CFCNT_YTD |
確認数YTD |
SUM(BSDF.CFCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CFCNT_YTD_LY |
確認数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 |
確認数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LP |
キャンセルLP |
LAG(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LP_PCT_CHG |
キャンセル%変更LP |
LAG_VARIANCE_PERCENT(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LY |
キャンセルLY |
LAG(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LY_CHG |
キャンセル変更LY |
LAG_VARIANCE(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LY_PCT_CHG |
キャンセル%変更LY |
LAG_VARIANCE_PERCENT(BSDF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_RNK_OFC |
予約オフィスのキャンセル・ランク |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.CLCNT DESC NULLS LAST WITHIN PARENT) |
|
CLCNT_SHR_OFC |
予約オフィスの親のキャンセル共有 |
SHARE(BSDF.CLCNT OF BKOFC.HBKOFC PARENT) |
|
CLCNT_YTD |
キャンセル数YTD |
SUM(BSDF.CLCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CLCNT_YTD_LY |
キャンセル数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 |
キャンセル数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLFCF |
確認からのキャンセル |
BSDF.CFCNT - BSDF.CLCNT |
|
CLFCF_LP |
確認からのキャンセルLP |
BSDF.CFCNT_LP - BSDF.CLCNT_LP |
|
CLFCF_LP_PCT_CHG |
確認からのキャンセル%変更LP |
((BSDF.CLFCF - BSDF.CLFCF_LP) / BSDF.CLFCF_LP) * 100 |
|
CLFCF_LY |
確認からのキャンセルLY |
BSDF.CFCNT_LY - BSDF.CLCNT_LY |
|
CLFCF_LY_PCT_CHG |
確認からのキャンセル%変更LY |
((BSDF.CLFCF - BSDF.CLFCF_LY) / BSDF.CLFCF_LY) * 100 |
|
CLRT |
キャンセル率 |
(BSDF.CLCNT / BSDF.BKD) * 100 |
|
CLRT_LP |
キャンセル率LP |
(BSDF.CLCNT_LP / BSDF.BKD_LP) * 100 |
|
CPC_LP |
クーポン数LP |
LAG(BSDF.CPC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CPC_LP_PCT_CHG |
クーポン数%変更LP |
LAG_VARIANCE_PERCENT(BSDF.CPC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CPC_YTD |
クーポン数YTD |
SUM(BSDF.CPC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CPC_YTD_LY |
クーポン数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 |
クーポン数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.CPC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CSRVN_LP |
コード共有収益LP |
LAG(BSDF.CSRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CSRVN_LP_PCT_CHG |
コード共有収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.CSRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CSRVN_YTD |
コード共有収益YTD |
SUM(BSDF.CSRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CSRVN_YTD_LY |
コード共有収益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 |
コード共有収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.CSRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CTRVN_LP |
チャータ収益LP |
LAG(BSDF.CTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CTRVN_LP_PCT_CHG |
チャータ収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.CTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CTRVN_YTD |
チャータ収益YTD |
SUM(BSDF.CTRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CTRVN_YTD_LY |
チャータ収益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 |
チャータYTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.CTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
EBRVN_LP |
超過荷物収益LP |
LAG(BSDF.EBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
EBRVN_LP_PCT_CHG |
超過荷物収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.EBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
EBRVN_YTD |
超過荷物収益YTD |
SUM(BSDF.EBRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
EBRVN_YTD_LY |
超過荷物収益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 |
超過荷物収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.EBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FES_LP |
料金収益LP |
LAG(BSDF.FES, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FES_LP_PCT_CHG |
料金収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.FES, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FES_YTD |
料金収益YTD |
SUM(BSDF.FES) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FES_YTD_LY |
料金収益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 |
料金収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.FES_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPAX_LP |
飛行乗客数LP |
LAG(BSDF.FPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPAX_LP_PCT_CHG |
飛行乗客数%変更LP |
LAG_VARIANCE_PERCENT(BSDF.FPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPAX_YTD |
飛行乗客数YTD |
SUM(BSDF.FPAX) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FPAX_YTD_LY |
飛行乗客数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 |
飛行乗客数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.FPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRVN_LP |
飛行収益LP |
LAG(BSDF.FRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRVN_LP_PCT_CHG |
飛行収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.FRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRVN_RNK_BKOFC |
予約オフィスの親の飛行収益ランク |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.FRVN DESC NULLS LAST WITHIN ANCESTOR AT LEVEL BKOFC.TBKOFC) |
|
FRVN_RNK_CNTYP |
チャネル・タイプの親の飛行収益ランク |
RANK() OVER HIERARCHY (BKOFC.HCNTYP ORDER BY BSDF.FRVN DESC NULLS LAST WITHIN PARENT) |
|
FRVN_YTD |
飛行収益YTD |
SUM(BSDF.FRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FRVN_YTD_LY |
飛行収益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 |
飛行収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.FRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
GBKD_LP |
グループ予約LP |
LAG(BSDF.GBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
GBKD_LP_PCT_CHG |
グループ予約%変更LP |
LAG_VARIANCE_PERCENT(BSDF.GBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
GBKD_YTD |
グループ予約YTD |
SUM(BSDF.GBKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
GBKD_YTD_LY |
グループ予約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 |
グループ予約YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.GBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
IBKD_LP |
個人予約LP |
LAG(BSDF.IBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
IBKD_LP_PCT_CHG |
個人予約%変更LP |
LAG_VARIANCE_PERCENT(BSDF.IBKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
IBKD_YTD |
個人予約YTD |
SUM(BSDF.IBKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
IBKD_YTD_LY |
個人予約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 |
個人予約YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.IBKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
MTLR |
実現率 |
((BSDF.CFCNT - BSDF.CLFCF) / BSDF.CFCNT) * 100 |
|
MTLR_LP |
実現率LP |
((BSDF.CFCNT_LP - BSDF.CLFCF_LP) / BSDF.CFCNT_LP) * 100 |
|
MTLR_LP_PCT_CHG |
実現率%変更LP |
((BSDF.MTLR - BSDF.MTLR_LP) / BSDF.MTLR_LP) * 100 |
|
MTLR_LY |
実現率LY |
((BSDF.CFCNT_LY - BSDF.CLFCF_LY) / BSDF.CFCNT_LP) * 100 |
|
MTLR_LY_PCT_CHG |
実現率%変更LY |
((BSDF.MTLR - BSDF.MTLR_LY) / BSDF.MTLR_LY) * 100 |
|
NFPAX_LP |
収益外の飛行乗客数LP |
LAG(BSDF.NFPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
NFPAX_LP_PCT_CHG |
収益外の飛行乗客数%変更LP |
LAG_VARIANCE_PERCENT(BSDF.NFPAX, 1) OVER HIERARCHY ("TIME".HTIME) |
|
NFPAX_YTD |
収益外の飛行乗客数YTD |
SUM(BSDF.NFPAX) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
NFPAX_YTD_LY |
収益外の飛行乗客数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 |
収益外の飛行乗客数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.NFPAX_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
NRPB |
予約当たりの純収益 |
BSDF.NRVN / BSDF.BKD |
|
NRPB_LP |
予約当たりの純収益LP |
BSDF.NRVN_LP / BSDF.BKD_LP |
|
NRPB_LY |
予約当たりの純収益LY |
BSDF.NRVN_LY / BSDF.BKD_LY |
|
NRPB_LY_CHG |
予約当たりの純収益変更LY |
BSDF.NRPB - BSDF.NRPB_LY |
|
NRPB_LY_PCT_CHG |
予約当たりの純収益%変更LY |
(BSDF.NRPB_LY_CHG / BSDF.NRPB_LY) * 100 |
|
NRPP |
乗客当たりの純収益 |
BSDF.NRVN / BSDF.PXCNT |
|
NRPP_LP |
乗客当たりの純収益LP |
BSDF.NRVN_LP / BSDF.PXCNT_LP |
|
NRPP_LY |
乗客当たりの純収益LY |
BSDF.NRVN_LY / BSDF.PXCNT_LY |
|
NRPP_LY_CHG |
乗客当たりの純収益変更LY |
BSDF.NRPP - BSDF.NRPP_LY |
|
NRPP_LY_PCT_CHG |
乗客当たりの純収益%変更LY |
(BSDF.NRPP_LY_CHG / BSDF.NRPP_LY) * 100 |
|
NRPS |
収益外の乗客共有 |
(BSDF.NFPAX / BSDF.FPAX) * 100 |
|
NRVN |
純収益 |
BSDF.TRVN - (BSDF.OTCHR + BSDF.TXS) |
|
NRVN_LP |
純収益LP |
BSDF.TRVN_LP - (BSDF.OTCHR_LP + BSDF.TXS_LP) |
|
NRVN_LY |
純収益LY |
BSDF.TRVN_LY - (BSDF.OTCHR_LY + BSDF.TXS_LY) |
|
NRVN_LY_CHG |
純収益変更LY |
BSDF.NRVN - BSDF.NRVN_LY |
|
NRVN_LY_PCT_CHG |
純収益%変更LY |
(BSDF.NRVN_LY_CHG / BSDF.NRVN_LY) * 100 |
|
NTBKD |
正味の予約済 |
BSDF.BKD - BSDF.CLFCF |
|
NTBKD_LP |
正味の予約済LP |
BSDF.BKD_LP - BSDF.CLFCF_LP |
|
NTBKD_LP_PCT_CHG |
正味の予約済%変更LP |
((BSDF.NTBKD - BSDF.NTBKD_LP) / BSDF.NTBKD_LP) * 100 |
|
NTBKD_LY |
正味の予約済LY |
BSDF.BKD_LY - BSDF.CLFCF_LY |
|
NTBKD_LY_PCT_CHG |
正味の予約済%変更LY |
((BSDF.NTBKD - BSDF.NTBKD_LY) / BSDF.NTBKD_LY) * 100 |
|
NTCFD_YTD |
正味の確認済YTD |
SUM(BSDF.NTCFD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
NTCFD_YTD_LY |
正味の確認済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 |
正味の確認済YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.NTCFD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OBRVN_LP |
搭乗収益LP |
LAG(BSDF.OBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OBRVN_LP_PCT_CHG |
搭乗収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.OBRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OBRVN_YTD |
搭乗収益YTD |
SUM(BSDF.OBRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OBRVN_YTD_LY |
搭乗収益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 |
搭乗収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.OBRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LP |
その他の課金LP |
LAG(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTCHR_LY |
その他の課金LY |
LAG(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LY_CHG |
その他の課金変更LY |
LAG_VARIANCE(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_LY_PCT_CHG |
その他の課金%変更LY |
LAG_VARIANCE_PERCENT(BSDF.OTCHR, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTCHR_YTD |
その他の課金YTD |
SUM(BSDF.OTCHR) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OTCHR_YTD_LY |
その他の課金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 |
その他の課金YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.OTCHR_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
OTRVN_LP |
その他の収益LP |
LAG(BSDF.OTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTRVN_LP_PCT_CHG |
その他の収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.OTRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
OTRVN_YTD |
その他の収益YTD |
SUM(BSDF.OTRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
OTRVN_YTD_LY |
その他の収益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 |
その他の収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.OTRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LP |
乗客数LP |
LAG(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PXCNT_LP_PCT_CHG |
乗客数%変更LP |
LAG_VARIANCE_PERCENT(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PXCNT_LY |
乗客数LY |
LAG(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LY_CHG |
乗客数変更LY |
LAG_VARIANCE(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_LY_PCT_CHG |
乗客数%変更LY |
LAG_VARIANCE_PERCENT(BSDF.PXCNT, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PXCNT_RNK_RUT |
航路の親の乗客数ランク |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.PXCNT DESC NULLS LAST WITHIN PARENT) |
|
PXCNT_YTD |
乗客数YTD |
SUM(BSDF.PXCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
PXCNT_YTD_LY |
乗客数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 |
乗客数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.PXCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LP |
チケット発行LP |
LAG(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKD_LP_PCT_CHG |
チケット発行%変更LP |
LAG_VARIANCE_PERCENT(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKD_LY |
チケット発行LY |
LAG(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LY_CHG |
チケット発行変更LY |
LAG_VARIANCE(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_LY_PCT_CHG |
チケット発行%変更LY |
LAG_VARIANCE_PERCENT(BSDF.TKD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKD_YTD |
チケット発行数YTD |
SUM(BSDF.TKD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TKD_YTD_LY |
チケット発行数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 |
チケット発行数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.TKD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRPB |
予約当たりの総収益 |
BSDF.TRVN / BSDF.BKD |
|
TRPB_LY |
予約当たりの総収益LY |
BSDF.TRVN_LY / BSDF.BKD_LY |
|
TRPB_LY_CHG |
予約当たりの総収益変更LY |
BSDF.TRPB - BSDF.TRPB_LY |
|
TRPB_LY_PCT_CHG |
予約当たりの総収益%変更LY |
(BSDF.TRPB_LY_CHG / BSDF.TRPB_LY) * 100 |
|
TRPP |
乗客当たりの総収益 |
BSDF.TRVN / BSDF.PXCNT |
|
TRPP_LY |
乗客当たりの総収益LY |
BSDF.TRVN_LY / BSDF.PXCNT_LY |
|
TRPP_LY_CHG |
乗客当たりの総収益変更LY |
BSDF.TRPP - BSDF.TRPP_LY |
|
TRPP_LY_PCT_CHG |
乗客当たりの総収益%変更LY |
(BSDF.TRPP_LY_CHG / BSDF.TRPP_LY) * 100 |
|
TRVN_LP |
総収益LP |
LAG(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TRVN_LP_PCT_CHG |
総収益%変更LP |
LAG_VARIANCE_PERCENT(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TRVN_LY |
総収益LY |
LAG(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_LY_CHG |
総収益変更LY |
LAG_VARIANCE(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_LY_PCT_CHG |
総収益%変更LY |
LAG_VARIANCE_PERCENT(BSDF.TRVN, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TRVN_RNK_BKOFC |
予約オフィスの親の総収益ランク |
RANK() OVER HIERARCHY (BKOFC.HBKOFC ORDER BY BSDF.TRVN DESC NULLS LAST WITHIN PARENT) |
|
TRVN_RNK_RUT |
航路の親の総収益ランク |
RANK() OVER HIERARCHY (ROUTE.HROUTE ORDER BY BSDF.TRVN DESC NULLS LAST WITHIN PARENT) |
|
TRVN_YTD |
総収益YTD |
SUM(BSDF.TRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TRVN_YTD_LY |
総収益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 |
総収益YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.TRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LP |
税金LP |
LAG(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TXS_LY |
税金LY |
LAG(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LY_CHG |
税金変更LY |
LAG_VARIANCE(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_LY_PCT_CHG |
税金%変更LY |
LAG_VARIANCE_PERCENT(BSDF.TXS, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TXS_YTD |
税金YTD |
SUM(BSDF.TXS) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TXS_YTD_LY |
税金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 |
税金YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.TXS_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LP |
待機リストLP |
LAG(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME) |
|
WTLST_LY |
待機リストLY |
LAG(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LY_CHG |
待機リスト変更LY |
LAG_VARIANCE(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_LY_PCT_CHG |
待機リスト%変更LY |
LAG_VARIANCE_PERCENT(BSDF.WTLST, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
WTLST_YTD |
待機リスト数YTD |
SUM(BSDF.WTLST) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
WTLST_YTD_LY |
待機リスト数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 |
待機リスト数YTD %変更LY |
LAG_VARIANCE_PERCENT(BSDF.WTLST_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
物理名: BSDF_F
ディメンションおよびロード・レベル
表8-6に、ディメンションおよびロード・レベルの簡単な説明を示します。
表8-6 予約セグメント出発ファクト予測キューブのディメンションおよびロード・レベル
| ディメンション | ロード・レベル |
|---|---|
|
TIME |
DAY |
|
BKCLS |
BKCLS |
|
ROUTE |
ROUTE |
|
OPFLT |
OPFLT |
|
OPSMT |
OPSMT |
|
BKOFC |
AGNT |
集計の順序/演算子
表8-7に、集計の演算子および順序の簡単な説明を示します。
表8-7 予約セグメント出発ファクト予測の集計の演算子および順序
| ディメンション名 | 演算子 | 順序 |
|---|---|---|
|
TIME |
sum |
1 |
|
BKCLS |
sum |
2 |
|
BKOFC |
sum |
3 |
|
OPFLT |
sum |
4 |
|
OPSMT |
sum |
5 |
|
ROUTE |
sum |
6 |
ベース・メジャー
表8-8に、ベース・メジャーの簡単な説明を示します。
表8-8 予約セグメント出発ファクト予測のベース・メジャー
| 物理名 | 論理名 | 物理列 |
|---|---|---|
|
BKD_F |
予約予測 |
予約予測 |
|
GBKD_F |
グループ予約予測 |
グループ予約予測 |
|
IBKD_F |
個人予約予測 |
個人予約予測 |
|
PXCNT_F |
乗客数予測 |
乗客数予測 |
|
TRVN_F |
総収益予測 |
総収益予測 |
導出メジャー
表8-9に、導出メジャーの簡単な説明を示します。
物理名: CCPF
ディメンションおよびロード・レベル
表8-10に、ディメンションおよびロード・レベルの簡単な説明を示します。
集計の順序/演算子
表8-11に、集計の演算子および順序の簡単な説明を示します。
ベース・メジャー
表8-12に、ベース・メジャーの簡単な説明を示します。
表8-12 コール・センター・パフォーマンス・ファクトのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
CCNT |
電話の合計数 |
DWA_DLY_CC_PRFM.CALL_CNT |
電話の合計数 |
|
ACCNT |
対応可能な電話の合計数 |
DWA_DLY_CC_PRFM.ACSBL_CNT |
対応可能な電話の合計数 |
|
STCNT |
満足させた電話の合計数 |
DWA_DLY_CC_PRFM.STFY_CNT |
満足させた電話の合計数 |
|
CMIN |
電話時間の合計分数 |
DWA_DLY_CC_PRFM.MIN_AMT |
電話時間の合計分数 |
|
AGCNT |
作業代理店数 |
DWA_DLY_CC_PRFM.AGNT_CNT |
作業代理店数 |
導出メジャー
表8-13に、導出メジャーの簡単な説明を示します。
表8-13 コール・センター・パフォーマンス・ファクト・キューブの導出メジャー
| 物理名 | 論理名 | 定義 |
|---|---|---|
|
ACCNT_LP |
対応可能な電話の合計数LP |
LAG(CCPF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_LP_PCT_CHG |
対応可能な電話の合計数%変更LP |
LAG_VARIANCE_PERCENT(CCPF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_YTD |
対応可能な電話の合計数YTD |
SUM(CCPF.ACCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ACCNT_YTD_LY |
対応可能な電話の合計数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 |
対応可能な電話の合計数YTD %変更LY |
LAG_VARIANCE_PERCENT(CCPF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
AGCNT_LP |
作業代理店数LP |
LAG(CCPF.AGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
AGCNT_LP_PCT_CHG |
作業代理店数%変更LP |
LAG_VARIANCE_PERCENT(CCPF.AGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
AGCNT_YTD |
作業代理店数YTD |
SUM(CCPF.AGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
AGCNT_YTD_LY |
作業代理店数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 |
作業代理店数YTD %変更LY |
LAG_VARIANCE_PERCENT(CCPF.AGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CCNT_LP |
電話の合計数LP |
LAG(CCPF.CCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CCNT_LP_PCT_CHG |
電話の合計数%変更LP |
LAG_VARIANCE_PERCENT(CCPF.CCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CCNT_YTD |
電話の合計数YTD |
SUM(CCPF.CCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CCNT_YTD_LY |
電話の合計数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 |
電話の合計数YTD %変更LY |
LAG_VARIANCE_PERCENT(CCPF.CCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CMIN_LP |
電話時間の合計分数LP |
LAG(CCPF.CMIN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CMIN_LP_PCT_CHG |
電話時間の合計分数%変更LP |
LAG_VARIANCE_PERCENT(CCPF.CMIN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CMIN_YTD |
電話時間の合計分数YTD |
SUM(CCPF.CMIN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CMIN_YTD_LY |
電話時間の合計分数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 |
電話時間の合計分数YTD %変更LY |
LAG_VARIANCE_PERCENT(CCPF.CMIN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
STCNT_LP |
満足させた電話の合計数LP |
LAG(CCPF.STCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STCNT_LP_PCT_CHG |
満足させた電話の合計数%変更LP |
LAG_VARIANCE_PERCENT(CCPF.STCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STCNT_YTD |
満足させた電話の合計数YTD |
SUM(CCPF.STCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
STCNT_YTD_LY |
満足させた電話の合計数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 |
満足させた電話の合計数YTD %変更LY |
LAG_VARIANCE_PERCENT(CCPF.STCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
物理名: CSDF
ディメンションおよびロード・レベル
表8-14に、ディメンションおよびロード・レベルの簡単な説明を示します。
集計の順序/演算子
表8-15に、集計の演算子および順序の簡単な説明を示します。
ベース・メジャー
表8-16に、ベース・メジャーの簡単な説明を示します。
表8-16 顧客調査日次ファクト・キューブのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
STFC |
満足数 |
DWA_DLY_CUST_SURVEY.STFY_CNT |
満足数 |
|
TSRC |
合計調査数 |
DWA_DLY_CUST_SURVEY.TOT_SURVEY_CNT |
合計調査数 |
導出メジャー
表8-17に、導出メジャーの簡単な説明を示します。
表8-17 顧客調査日次ファクト・キューブの導出メジャー
| 物理名 | 論理名 | 定義 |
|---|---|---|
|
STFC_LP |
満足数LP |
LAG(CSDF.STFC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STFC_LP_PCT_CHG |
満足数%変更LP |
LAG_VARIANCE_PERCENT(CSDF.STFC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
STFC_YTD |
満足数YTD |
SUM(CSDF.STFC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
STFC_YTD_LY |
満足数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 |
満足数YTD %変更LY |
LAG_VARIANCE_PERCENT(CSDF.STFC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TSRC_LP |
合計調査数LP |
LAG(CSDF.TSRC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TSRC_LP_PCT_CHG |
合計調査数%変更LP |
LAG_VARIANCE_PERCENT(CSDF.TSRC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TSRC_YTD |
合計調査数YTD |
SUM(CSDF.TSRC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TSRC_YTD_LY |
合計調査数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 |
合計調査数YTD %変更LY |
LAG_VARIANCE_PERCENT(CSDF.TSRC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
物理名: FDDF
ディメンションおよびロード・レベル
表8-18に、ディメンションおよびロード・レベルの簡単な説明を示します。
集計の順序/演算子
表8-19に、集計の演算子および順序の簡単な説明を示します。
ベース・メジャー
表8-20に、ベース・メジャーの簡単な説明を示します。
表8-20 フライト詳細日次キューブのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
SBCP |
販売可能な合計座席数 |
DWA_DLY_FLT_DETLS.SALEBLE_TOT_CPCTY |
販売可能な座席の合計数 |
|
DTFL |
飛行距離 |
DWA_DLY_FLT_DETLS.NAUTICAL_MLS |
出発地と目的地の間の飛行距離 |
導出メジャー
表8-21に、導出メジャーの簡単な説明を示します。
物理名: LYAF
ディメンションおよびロード・レベル
表8-22に、ディメンションおよびロード・レベルの簡単な説明を示します。
集計の順序/演算子
表8-23に、集計の演算子および順序の簡単な説明を示します。
ベース・メジャー
表8-24に、ベース・メジャーの簡単な説明を示します。
表8-24 ロイヤルティ・アカウント・ファクト・キューブのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
LYCNT |
ロイヤルティ・アカウント数 |
DWA_DLY_LYLTY_ACCT.LYLTY_ACCT_CNT |
ロイヤルティ・アカウント数 |
|
UGCNT |
アップグレード数 |
DWA_DLY_LYLTY_ACCT.UGRD_CNT |
アップグレード数 |
|
DGCNT |
ダウングレード数 |
DWA_DLY_LYLTY_ACCT.DGRD_CNT |
ダウングレード数 |
|
ATCNT |
アクティブ・アカウント数 |
DWA_DLY_LYLTY_ACCT.ACTV_CNT |
アクティブ・アカウント数 |
|
TAML |
アカウントの合計マイル数 |
DWA_DLY_LYLTY_ACCT.TOT_MILES_AMT |
アカウントの合計マイル数 |
|
TMED |
付与されたアカウントの合計マイル数 |
DWA_DLY_LYLTY_ACCT.MILES_ERND_AMT |
付与されたアカウントの合計マイル数 |
|
TMRD |
引き換えられたアカウントの合計マイル数 |
DWA_DLY_LYLTY_ACCT.MILES_RDMD_AMT |
引き換えられたアカウントの合計マイル数 |
導出メジャー
表8-25に、導出メジャーの簡単な説明を示します。
表8-25 ロイヤルティ・アカウント・ファクト・キューブの導出メジャー
| 物理名 | 論理名 | 定義 |
|---|---|---|
|
ATCNT_LP |
アクティブ・アカウント数LP |
LAG(LYAF.ATCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ATCNT_LP_PCT_CHG |
アクティブ・アカウント数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.ATCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ATCNT_YTD |
アクティブ・アカウント数YTD |
SUM(LYAF.ATCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ATCNT_YTD_LY |
アクティブ・アカウント数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 |
アクティブ・アカウント数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.ATCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
DGCNT_LP |
ダウングレード数LP |
LAG(LYAF.DGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
DGCNT_LP_PCT_CHG |
ダウングレード数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.DGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
DGCNT_YTD |
ダウングレード数YTD |
SUM(LYAF.DGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
DGCNT_YTD_LY |
ダウングレード数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 |
ダウングレード数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.DGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LYCNT_LP |
ロイヤルティ・アカウント数LP |
LAG(LYAF.LYCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LYCNT_LP_PCT_CHG |
ロイヤルティ・アカウント数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.LYCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LYCNT_YTD |
ロイヤルティ・アカウント数YTD |
SUM(LYAF.LYCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
LYCNT_YTD_LY |
ロイヤルティ・アカウント数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 |
ロイヤルティ・アカウント数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.LYCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TAML_LP |
アカウントの合計マイル数LP |
LAG(LYAF.TAML, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TAML_LP_PCT_CHG |
アカウントの合計マイル数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.TAML, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TAML_YTD |
アカウントの合計マイル数YTD |
SUM(LYAF.TAML) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TAML_YTD_LY |
アカウントの合計マイル数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 |
アカウントの合計マイル数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.TAML_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMED_LP |
付与されたアカウントの合計マイル数LP |
LAG(LYAF.TMED, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMED_LP_PCT_CHG |
付与されたアカウントの合計マイル数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.TMED, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMED_YTD |
付与されたアカウントの合計マイル数YTD |
SUM(LYAF.TMED) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TMED_YTD_LY |
付与されたアカウントの合計マイル数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 |
付与されたアカウントの合計マイル数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.TMED_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TMRD_LP |
引き換えられたアカウントの合計マイル数LP |
LAG(LYAF.TMRD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMRD_LP_PCT_CHG |
引き換えられたアカウントの合計マイル数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.TMRD, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TMRD_YTD |
引き換えられたアカウントの合計マイル数YTD |
SUM(LYAF.TMRD) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TMRD_YTD_LY |
引き換えられたアカウントの合計マイル数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 |
引き換えられたアカウントの合計マイル数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.TMRD_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
UGCNT_LP |
アップグレード数LP |
LAG(LYAF.UGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
UGCNT_LP_PCT_CHG |
アップグレード数%変更LP |
LAG_VARIANCE_PERCENT(LYAF.UGCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
UGCNT_YTD |
アップグレード数YTD |
SUM(LYAF.UGCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
UGCNT_YTD_LY |
アップグレード数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 |
アップグレード数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYAF.UGCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
物理名: LYBF
ディメンションおよびロード・レベル
表8-26に、ディメンションおよびロード・レベルの簡単な説明を示します。
集計の順序/演算子
表8-27に、集計の演算子および順序の簡単な説明を示します。
ベース・メジャー
表8-28に、ベース・メジャーの簡単な説明を示します。
表8-28 ロイヤルティ予約ファクト・キューブのベース・メジャー
| 物理名 | 論理名 | 物理列 | 説明 |
|---|---|---|---|
|
LACNT |
ロイヤルティ・アカウント数 |
DWA_DLY_LA_BKG.LYLTY_ACCT_CNT |
ロイヤルティ・アカウント数 |
|
ACCNT |
アクティブ・アカウント数 |
DWA_DLY_LA_BKG.ACTV_CNT |
アクティブ・アカウント数 |
|
PCNT |
乗客数 |
DWA_DLY_LA_BKG.PAX_CNT |
乗客数 |
|
BKCNT |
予約数 |
DWA_DLY_LA_BKG.BKD |
予約数 |
|
CFCNT |
確認済予約数 |
DWA_DLY_LA_BKG.CONFMD_CNT |
確認済予約数 |
|
CLCNT |
キャンセル済予約数 |
DWA_DLY_LA_BKG.CNCLD_CNT |
キャンセル済予約数 |
|
FPCNT |
飛行乗客数 |
DWA_DLY_LA_BKG.FLN_PAX_CNT |
飛行乗客数 |
|
FRAC |
アクティブ・アカウントが寄与した飛行収益 |
DWA_DLY_LA_BKG.FLN_REV_BY_ACTV |
アクティブ・アカウントが寄与した飛行収益 |
|
FLRVN |
飛行収益 |
DWA_DLY_LA_BKG.FLN_REV |
飛行収益 |
|
FTCNT |
フライト数 |
DWA_DLY_LA_BKG.FLT_CNT |
フライト数 |
|
TKAMT |
チケット金額 |
DWA_DLY_LA_BKG.TKT_AMT |
チケット金額 |
導出メジャー
表8-29に、導出メジャーの簡単な説明を示します。
表8-29 ロイヤルティ予約ファクト・キューブの導出メジャー
| 物理名 | 論理名 | 定義 |
|---|---|---|
|
ACCNT_LP |
アクティブ・アカウント数LP |
LAG(LYBF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_LP_PCT_CHG |
アクティブ・アカウント数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.ACCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
ACCNT_YTD |
アクティブ・アカウント数YTD |
SUM(LYBF.ACCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
ACCNT_YTD_LY |
アクティブ・アカウント数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 |
アクティブ・アカウント数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.ACCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
BKCNT_LP |
予約数LP |
LAG(LYBF.BKCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKCNT_LP_PCT_CHG |
予約数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.BKCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
BKCNT_YTD |
予約数YTD |
SUM(LYBF.BKCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
BKCNT_YTD_LY |
予約数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 |
予約数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.BKCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CFCNT_LP |
確認済予約数LP |
LAG(LYBF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_LP_PCT_CHG |
確認済予約数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.CFCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CFCNT_YTD |
確認済予約数YTD |
SUM(LYBF.CFCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CFCNT_YTD_LY |
確認済予約数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 |
確認済予約数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.CFCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
CLCNT_LP |
キャンセル済予約数LP |
LAG(LYBF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_LP_PCT_CHG |
キャンセル済予約数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.CLCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
CLCNT_YTD |
キャンセル済予約数YTD |
SUM(LYBF.CLCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
CLCNT_YTD_LY |
キャンセル済予約数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 |
キャンセル済予約数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.CLCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FLRVN_LP |
飛行収益LP |
LAG(LYBF.FLRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FLRVN_LP_PCT_CHG |
飛行収益%変更LP |
LAG_VARIANCE_PERCENT(LYBF.FLRVN, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FLRVN_YTD |
飛行収益YTD |
SUM(LYBF.FLRVN) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FLRVN_YTD_LY |
飛行収益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 |
飛行収益YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.FLRVN_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FPCNT_LP |
飛行乗客数LP |
LAG(LYBF.FPCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPCNT_LP_PCT_CHG |
飛行乗客数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.FPCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FPCNT_YTD |
飛行乗客数YTD |
SUM(LYBF.FPCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FPCNT_YTD_LY |
飛行乗客数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 |
飛行乗客数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.FPCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FRAC_LP |
アクティブ・アカウントが寄与した飛行収益LP |
LAG(LYBF.FRAC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRAC_LP_PCT_CHG |
アクティブ・アカウントが寄与した飛行収益%変更LP |
LAG_VARIANCE_PERCENT(LYBF.FRAC, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FRAC_YTD |
アクティブ・アカウントが寄与した飛行収益YTD |
SUM(LYBF.FRAC) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FRAC_YTD_LY |
アクティブ・アカウントが寄与した飛行収益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 |
アクティブ・アカウントが寄与した飛行収益YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.FRAC_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
FTCNT_LP |
フライト数LP |
LAG(LYBF.FTCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FTCNT_LP_PCT_CHG |
フライト数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.FTCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
FTCNT_YTD |
フライト数YTD |
SUM(LYBF.FTCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
FTCNT_YTD_LY |
フライト数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 |
フライト数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.FTCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
LACNT_LP |
ロイヤルティ・アカウント数LP |
LAG(LYBF.LACNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LACNT_LP_PCT_CHG |
ロイヤルティ・アカウント数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.LACNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
LACNT_YTD |
ロイヤルティ・アカウント数YTD |
SUM(LYBF.LACNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
LACNT_YTD_LY |
ロイヤルティ・アカウント数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 |
ロイヤルティ・アカウント数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.LACNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
PCNT_LP |
乗客数LP |
LAG(LYBF.PCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PCNT_LP_PCT_CHG |
乗客数%変更LP |
LAG_VARIANCE_PERCENT(LYBF.PCNT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
PCNT_YTD |
乗客数YTD |
SUM(LYBF.PCNT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
PCNT_YTD_LY |
乗客数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 |
乗客数YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.PCNT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
|
TKAMT_LP |
チケット金額LP |
LAG(LYBF.TKAMT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKAMT_LP_PCT_CHG |
チケット金額%変更LP |
LAG_VARIANCE_PERCENT(LYBF.TKAMT, 1) OVER HIERARCHY ("TIME".HTIME) |
|
TKAMT_YTD |
チケット金額YTD |
SUM(LYBF.TKAMT) OVER HIERARCHY ("TIME".HTIME BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL "TIME"."YEAR") |
|
TKAMT_YTD_LY |
チケット金額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 |
チケット金額YTD %変更LY |
LAG_VARIANCE_PERCENT(LYBF.TKAMT_YTD, 1) OVER HIERARCHY ("TIME".HTIME BY ANCESTOR AT LEVEL "TIME".HTIME."YEAR" POSITION FROM BEGINNING) |
