7 Oracle Airlines Data Model OLAP Model Dimensions

Describes the data flow between the fact tables of Oracle Airlines Data Model.

• Oracle Airlines Data Model Introduction to OLAP Dimensions
  
• Oracle Airlines Data Model OLAP Dimensions
  Contains descriptions of the Dimension tables.

Oracle Airlines Data Model Introduction to OLAP Dimensions

Oracle Airlines Data Model contains low level combination of base tables and summary, average, and so on, of Base and Derived data. Each dimension includes the following information:

• Levels

• Hierarchies

• Attributes and Attribute mappings

Oracle Airlines Data Model OLAP Dimensions

Contains descriptions of the Dimension tables.

• Booking Class: BKCLS
  Describes the information of the Booking Class Dimension.
• Booking Office: BKOFC
  Describes the information of the Booking Office Dimension.
• Geography: GEO
  Describes the information of the Geography Dimension.
• Interaction Reason: IRSN
  Describes the information of the Interaction Reason Dimension.
• Loyalty Level: LOYLV
  Describes the information in the Loyalty Level Dimension.
• Operating Flight: OPFLT
  Describes the information of the Operating Flight Dimension.
• Operating Segment: OPSMT
  Describes the information of the Operating Segment Dimension.
• Route: ROUTE
  Describes the information of the Route Dimension.
• Service: SRVC
  Describes the information of the Service Dimension.
• Time: TIME
  Describes the information of the Time Dimension.

Booking Class: BKCLS

Describes the information of the Booking Class Dimension.

Table 7-1 Booking Class (BKCLS) Levels and Hierarchies

Level	Description	Booking Class Hierarchy (HBKCLS)
TBKCLS	Total Booking Class	TBKCLS
SVCLS	Service Class	SVCLS
BKCLS	Booking Class	BKCLS

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-2 Booking Class Long Description Attribute Mapping

Level	Mapping (Physical Column)
TBKCLS	Total Booking Class
SVCLS	DWR_BKG_CLS_TYP.SRVC_CLS_DSCR
BKCLS	DWR_BKG_CLS_TYP.SRVC_CLS_DSCR

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-3 Booking Class Short Description Attribute Mapping

Level	Mapping (Physical Column)
TBKCLS	Total Booking Class
SVCLS	DWR_BKG_CLS_TYP.SRVC_CLS_CD
BKCLS	DWR_BKG_CLS_TYP.SRVC_CLS_CD

Booking Office: BKOFC

Describes the information of the Booking Office Dimension.

Table 7-4 Booking Office (HBKOFC) Levels and Hierarchies

Levels	Description	Booking Office Hierarchy (HBKOFC)	Channel Type Hierarchy (HCNTYP)
TBKOFC	Total Booking Office	TBKOFC	TBKOFC
ACNTNT	Agent Continent	ACNTNT	No value
ACUNTRY	Agent Country	ACUNTRY	No value
ARGN	Agent Region	ARGN	No value
ACITY	Agent City	ACITY	No value
BKOFC	Booking Office	BKOFC	No value
CNTYP	Channel Type	No value	CNTYP
AGNT	Agent	AGNT	AGNT

Hierarchy of HBKOFC

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-5 Booking Office HBKOFC Long Description Attribute Mapping

Levels	Mapping (Physical Column)
TBKOFC	Total Booking Office
ACNTNT	DWR_BKG_OFFC.AGNT_CONT
ACUNTRY	DWR_BKG_OFFC.AGNT_CTRY
ARGN	DWR_BKG_OFFC.AGNT_REGN
ACITY	DWR_BKG_OFFC.AGNT_CITY
BKOFC	DWR_BKG_OFFC.OFF_NM
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-6 Booking Office HBKOFC Short Description Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	Total Booking Office
ACNTNT	DWR_BKG_OFFC.AGNT_CONT_CD
ACUNTRY	DWR_BKG_OFFC.AGNT_CTRY_CD
ARGN	DWR_BKG_OFFC.AGNT_REGN_CD
ACITY	DWR_BKG_OFFC.AGNT_CITY_CD
BKOFC	DWR_BKG_OFFC.OFF_NM
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Agent Status (ASTUS)

Table 7-7 Booking Office HBKOFC Agent Status Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
ACNTNT	No value
ACUNTRY	No value
ARGN	No value
ACITY	No value
BKOFC	No value
AGNT	DWR_BKG_OFFC.STAT_CD

Attribute Name: Agent Name (ANM)

Table 7-8 Booking Office HBKOFC Agent Name Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
ACNTNT	No value
ACUNTRY	No value
ARGN	No value
ACITY	No value
BKOFC	No value
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Agent IATA Code (AITCD)

Table 7-9 Booking Office HBKOFC Agent IATA Code Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
ACNTNT	No value
ACUNTRY	No value
ARGN	No value
ACITY	No value
BKOFC	No value
AGNT	DWR_BKG_OFFC.IATA_CD

Hierarchy of HCNTYP

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-10 Booking Office HCNTYP Long Description Mapping

Level	Mapping (Physical Column)
TBKOFC	Total Booking Office
CNTYP	DWR_BKG_OFFC.CHNL_TYP
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-11 Booking Office HCNTYP Short Description Mapping

Level	Mapping (Physical Column)
TBKOFC	Total Booking Office
CNTYP	DWR_BKG_OFFC.CHNL_TYP
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Agent IATA Code (AITCD))

Table 7-12 Booking Office HCNTYP IATA Code Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
CNTYP	No value
AGNT	DWR_BKG_OFFC.IATA_CD

Attribute Name: Agent Name (ANM)

Table 7-13 Booking Office HCNTYP Agent Name Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
CNTYP	No value
AGNT	DWR_BKG_OFFC.AGNT_NM

Attribute Name: Agent Status (ASTUS)

Table 7-14 Booking Office HCNTYP Agent Status Attribute Mapping

Level	Mapping (Physical Column)
TBKOFC	No value
CNTYP	No value
AGNT	DWR_BKG_OFF.C. STAT_CD

Geography: GEO

Describes the information of the Geography Dimension.

Table 7-15 Geography (HGEO) Levels and Hierarchies

Level	Description	Geography Hierarchy (HGEO)
TGEO	Total Geography	TGEO
CONT	Continent	CONT
COUNTRY	Country	COUNTRY
CITY	City	CITY

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-16 Geography Long Description Attribute Mapping

Level	Mapping (Physical Column)
TGEO	Total Geography
CONT	DWR_GEO.CONTINENT_NAME
COUNTRY	DWR_GEO.CNTRY_NAME
CITY	DWR_GEO.CITY_NAME

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-17 Geography Short Description Attribute Mapping

Level	Mapping (Physical Column)
TGEO	Total Geography
CONT	DWR_GEO.CONTINENT_SURNAME
COUNTRY	DWR_GEO.CNTRY_SURNAME
CITY	DWR_GEO.CITY_NAME

Interaction Reason: IRSN

Describes the information of the Interaction Reason Dimension.

Table 7-18 Interaction Reason (HIRSN) Levels and Hierarchies

Level	Description	Interaction Reason Hierarchy (HIRSN)
TIRSN	Total Interaction Reason	TIRSN
IRSN	Interaction Reason	IRSN

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-19 Interaction Reason Long Description Attribute Mapping

Level	Mapping (Physical Column)
TIRSN	Total Interaction Reason
IRSN	DWR_INTRACN_RSN. INTRACN_RSN_NAME

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-20 Interaction Reason Short Description Attribute Mapping

Level	Mapping (Physical Column)
TIRSN	Total Interaction Reason
IRSN	DWR_INTRACN_RSN. INTRACN_RSN_DSCR

Loyalty Level: LOYLV

Describes the information in the Loyalty Level Dimension.

Table 7-21 Loyalty Level (HLOYLY) Levels and Hierarchies

Level	Description	Loyalty Level Hierarchy (HLOYLY)
TLOYLY	Total Loyalty Level	TLOYLY
LOYLY	Loyalty Level	LOYLY

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-22 Loyalty Level Long Description Attribute Mapping

Level	Mapping (Physical Column)
TLOYLY	Total Loyalty Level
LOYLY	DWR_LYLTY_LVL. LYLTY_LVL_NAME

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-23 Loyalty Level Short Description Attribute Mapping

Level	Mapping (Physical Column)
TLOYLY	Total Loyalty Level
LOYLY	DWR_LYLTY_LVL. LYLTY_LVL_NAME

Attribute Name: Level Qualifying Start Points (LVL_STPN)

Table 7-24 Loyalty Level Qualifying Start Points Attribute Mapping

Level	Mapping (Physical Column)
TLOYLY
LOYLY	DWR_LYLTY_LVL. LVL_QLFYNG_STRT_PTS

Operating Flight: OPFLT

Describes the information of the Operating Flight Dimension.

Table 7-25 Operating Flight (OPFLT) Levels and Hierarchies

Level	Description	Operating Flight Hierarchy (HOPFLT)
TOPFLT	Total Operating Flight	TOPFLT
OPFLT	Operating Flight	OPFLT

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-26 Operating Flight Long Description Attribute Mapping

Level	Mapping (Physical Column)
TOPFLT	Total Operating Flight
OPFLT	DWR_FLT.FLT_TXT_DSCR

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 7-27 Operating Flight Short Description Attribute Mapping

Level	Mapping (Physical Column)
TOPFLT	Total Operating Flight
OPFLT	DWR_FLT.FLT_NBR

Operating Segment: OPSMT

Describes the information of the Operating Segment Dimension.

Table 7-28 Operating Segment (OPSMT) Levels and Hierarchies

Level	Description	Operating Segment Hierarchy (HOPSMT)
TOPSMT	Total Operating Segment	TOPSMT
TFRGN	Traffic Region	TFRGN
OPSMT	Operating Segment	OPSMT

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-29 Operating Segment Long Description Attribute Mapping

Level	Mapping (Physical Column)
TOPSMT	Total Operating Segment
TFRGN	DWR_SEG.OFPNT_CONT
OPSMT	DWR_SEG.OFPNT_AIP_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-30 Operating Segment Short Description Attribute Mapping

Level	Mapping (Physical Column)
TOPSMT	Total Operating Segment
TFRGN	DWR_SEG. OFFPOINT_CONTINENT
OPSMT	DWR_SEG. BRD_ARPRT_NAME

Attribute Name: Segment Pair (SEG_PAIR)

Table 7-31 Operating Segment Pair Attribute Mapping

Level	Mapping (Physical Column)
TOPSMT	No value
TFRGN	No value
OPSMT	DWR_SEG. OFFPOINT_ARPRT_NAME || DWR_SEG. BRD_ARPRT_NAME

Route: ROUTE

Describes the information of the Route Dimension.

Table 7-32 Route (ROUTE) Levels and Hierarchies

Level	Description	Route Hierarchy (HROUTE)
TROUTE	Total Route	TROUTE
ROUTE	Route	ROUTE

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-33 Route Long Description Attribute Mapping

Level	Mapping (Physical Column)
TROUTE	Total Route
ROUTE	ROUTE LD

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-34 Route Short Description Attribute Mapping

Level	Mapping (Physical Column)
TROUTE	Total Route
ROUTE	ROUTE SD

Service: SRVC

Describes the information of the Service Dimension.

Table 7-35 Service (SRVC) Levels and Hierarchies

Level	Description	Service Hierarchy (HSRVC)
SVTYP	Service Type	SVTYP
SRVC	Service	SRVC

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-36 Service Long Description Attribute Mapping

Level	Mapping (Physical Column)
SVTYP	DWR_SRVC. SRVC_NAME
SRVC	DWR_SRVC. SRVC_TYP_DSCR

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-37 Service Short Description Attribute Mapping

Level	Mapping (Physical Column)
SVTYP	DWR_SRVC. SRVC_NAME
SRVC	DWR_SRVC. SRVC_TYP_NAME

Time: TIME

Describes the information of the Time Dimension.

Table 7-38 Time (TIME) Levels and Hierarchies

Level	Description	Time Hierarchy (HTIME)
TIME	Total Time	TIME
YEAR	Year	YEAR
HLFY	Half Year	HLFY
QTR	Quarter	QTR
MONTH	Month	MONTH
WEEK	Week	WEEK
DAY	Day	DAY

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 7-39 Time Long Description Attribute Mapping

Level	Mapping (Physical Column)
TIME	Total Time
YEAR	DWR_CLNDR.CLNDR_YR_DSCR
HLFY	DWR_CLNDR.CLNDR_HLF_YR_DSCR
QTR	DWR_CLNDR.CLNDR_QTR
MONTH	DWR_CLNDR.CLNDR_MO_NM
WEEK	DWR_CLNDR.CLNDR_WK_DSCR
DAY	DWR_CLNDR.CLNDR_DT_DSCR

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 7-40 Time Short Description Attribute Mapping

Level	Mapping (Physical Column)
TIME	Total Time
YEAR	DWR_CLNDR.CLNDR_YR_CD
HLFY	DWR_CLNDR.CLNDR_HLF_YR_CD
QTR	DWR_CLNDR.CLNDR_QTR_CD
MONTH	DWR_CLNDR.CLNDR_MO_CD
WEEK	DWR_CLNDR.CLNDR_WK_CD
DAY	DWR_CLNDR.CLNDR_DT_DSCR

Attribute Name: End Date (END_DATE)

Table 7-41 Time End Date Attribute Mapping

Level	Mapping (Physical Column)
TIME	DWR_CLNDR.CLNDR_YR_END_DT
YEAR	DWR_CLNDR.CLNDR_YR_END_DT
HLFY	DWR_CLNDR.CLNDR_HLF_YR_END_DT
QTR	DWR_CLNDR.CLNDR_QTR_END_DT
MONTH	DWR_CLNDR.CLNDR_MO_END_DT
WEEK	DWR_CLNDR.CLNDR_WK_END_DT
DAY	DWR_CLNDR.CLNDR_DT

Attribute Name: Time Span (TIME_SPAN)

Table 7-42 Time Span Attribute Mapping

Level	Mapping (Physical Column)
TIME	DWR_CLNDR.CLNDR_YR_TIMESPN
YEAR	DWR_CLNDR.CLNDR_YR_TIMESPN
HLFY	DWR_CLNDR.CLNDR_HLF_YR_TIMESPN
QTR	DWR_CLNDR.CLNDR_QTR_TIMESPN
MONTH	DWR_CLNDR.CLNDR_MO_TIMESPN
WEEK	DWR_CLNDR.CLNDR_WK_TIMESPN
DAY	1

Attribute Name: Calendar Week Number In Year (CWIY)

Table 7-43 Time Calendar Week Number in Year Attribute Mapping

Level	Mapping (Physical Column)
TIME
YEAR
HLFY
QTR
MONTH
WEEK	DWR_CLNDR.CLNDR_WK_NBR_IN_YR
DAY	DWR_CLNDR.CLNDR_WK_NBR_IN_YR

Attribute Name: Day of Week Number (DOWN)

Table 7-44 Time Day of Week Number Attribute Mapping

Level	Mapping (Physical Column)
TIME	No value
YEAR	No value
HLFY	No value
QTR	No value
MONTH	No value
WEEK	No value
DAY	DWR_CLNDR.DAY_OF_WK_NBR

Attribute Name: Day of Week Name (DOWNM)

Table 7-45 Time Day of Week Name Attribute Mapping

Level	Mapping (Physical Column)
TIME	No value
YEAR	No value
HLFY	No value
QTR	No value
MONTH	No value
WEEK	No value
DAY	DWR_CLNDR.DAY_OF_WK_NAME