8 Oracle Communications Data Model OLAP Model Dimensions

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

This chapter includes the following sections:

Introduction to OLAP Architecture
Oracle Communications Data Model OLAP Dimensions

For more information, see Chapter 9, "Oracle Communications Data Model OLAP Model Cubes".

Introduction to OLAP Architecture

Oracle Data Warehouse for Communications (Oracle Communications Data Model Relational) contains the lowest level CDR details, low level combination of base tables and the summary, average, and so on, of Base and Derived data. Oracle Communications Data Model Relational was developed in a relational database.

General Process to Populate the OLAP Module in Oracle Communications Data Model

Oracle Communications Data Model ocdm_sys schema does the following:

Directly maps the leaf level data from the relational table/mv into the OLAP cube.
Cube organized materialized views represent the cube to SQL-based applications as materialized views that you can use for both refresh and query rewrite. With Query Re-write enabled, Oracle will automatically re-write SQL queries targeted against relational tables. to use the Cube-Organized Materialized View. To use this feature the OLAP cubes and relational components are in a single schema (ocdm_sys).
All cubes are available for the end user SQL based Query Tool access through CUBE_TABLE based SQL Views, which are created and maintained automatically during the cube build/update process.
Cubes are built from level 0 DWA materialized views or DWB/DWD tables (which, when a date is present, usually means at the month level).

Using SQL to access the cubes and dimensions is a significant feature of Oracle OLAP because it enables reporting tools that only generate SQL to use all of the powerful features of the analytic workspace. In Oracle Database 11g this is achieved by the use of the CUBE_TABLE function that extracts multidimensional data from a cube in an analytic workspace and presents it to the relational SQL engine in the form of a two dimensional table, such as, a set of rows and columns. It provides a mapping between the cube in the analytic workspace and the rows and columns that the SQL sees.

Query Rewrite to Cube Organized Materialized Views

Oracle Communications Data Model uses SQL to query the relational base tables and the optimizer transparently translates the SQL to access either the table materialized views or the cube materialized views (and hence the analytic workspace cubes and dimensions) depending upon which provides the better performance. This allows all of the benefits of the analytic workspace to be easily available to any product using regular SQL.

Oracle Communications Data Model OLAP Dimensions

The dimensions section describes the detail information for all the dimensions. Each dimension includes the following information:

Levels
Hierarchies
Attributes and Attribute mappings

Table 8-1 lists the dimensions.

Table 8-1 Dimensions

Dimensions
Account Refund Reason: ARRSN
Bank Direct Debit Channel: MOBJTYP
Billing Cycle: BCYCL
Churn Reason: CRNRSN
Collection Agency: CAGNCY
Commission Type: CMTYP
Cost Center: CCK
Currency: CRNCY
Customer: CUST
Customer Segment: CSGMNT
Customer Type: CUSTYP
Debt Aging Band: DAB
Geography: GEO
Handset Model: HSMDL
Invoice Adjustment Reason: IARSN
Invoice Adjustment Type: IATYP
Organization: ORG
Payment Channel: PCK
Payment Method Type: PMTYP
Payment Transaction Type: PTTYP
Peak Offpeak Time: POPT
Product: PROD
Product Offer: POFR
Promotion: PRMTN
Resource: RSCEK
Sales Channel: SLCHNL
Sales Channel Representative: SLR
SKU Item: SKUITEM
Time: TIME
Time Day: TIME_DAY
Time Slot: TSLT

Account Refund Reason: ARRSN

This dimension keeps all the information for the reason why this refund occurs.

Table 8-2 Account Refund Reason (ARRSN) Levels and Hierarchies

Level	Description	Account Refund Reason Hierarchy (HARRSN)
TARRSN	Total Account Refund Reason	TARRSN
ARRSN	Account Refund Reason	ARRSN

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-3 Account Refund Reason Long Description Attribute Mapping

Level	Mapping (Physical Column)
TARRSN	"Total Account Refund Reason"
ARRSN	DWL_ACCT_RFND_RSN.ACCT_RFND_RSN_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-4 Account Refund Reason Short Description Attribute Mapping

Level	Mapping (Physical Column)
TARRSN	"Total Account Refund Reason"
ARRSN	DWL_ACCT_RFND_RSN.ACCT_RFND_RSN_CD

Bank Direct Debit Channel: MOBJTYP

This dimension keeps all the information of media object type.

Table 8-5 Bank Direct Debit Channel (MOBJTYP) Levels and Hierarchies

Level	Description	Bank Direct Debit Channel Hierarchy (HMOBJTYP)
TMOBJTYP	Total bank direct debit channel	TMOBJTYP
MOBJTYP	Bank direct debit channel	MOBJTYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-6 Bank Direct Debit Channel Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMOBJTYP	"Total Bank Direct Debit Channel"
MOBJTYP	DWL_MEDIA_OBJ_TYP.MEDIA_OBJ_TYP_DSCR

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-7 Bank Direct Debit Channel Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMOBJTYP	"Total Bank Direct Debit Channel"
MOBJTYP	DWL_MEDIA_OBJ_TYP.MEDIA_OBJ_TYP_NAME

Billing Cycle: BCYCL

This dimension keeps all the information of the billing cycle.

Table 8-8 Billing Cycle (BCYCL) Levels and Hierarchies

Level	Description	Billing Cycle Hierarchy (HBCYCL)
TBCYCL	Totalbilling cycle	TBCYCL
BCYCL	Billing cycle	BCYCL

This dimension keeps all the information of the billing cycle.

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-9 Billing Cycle Long Description Attribute Mapping

Level	Mapping (Physical Column)
	"Total Billing Cycle"
	DWR_BLLG_CYCL.BLLG_CYCL_DSCR

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-10 Billing Cycle Long Description Attribute Mapping

Level	Mapping (Physical Column)

	DWR_BLLG_CYCL.BLLG_CYCL_NAME

Churn Reason: CRNRSN

This dimension keeps all the information of the Churn Reason. This dimension stores information regarding the reason for subscriber churn. This information is required for churn analysis.

Table 8-11 Churn Reason (CRNRSN) Levels and Hierarchies

Level	Description	Churn Reason Hierarchy (HCRNRSN)
TCRNRSN	Total Churn Reason	TCRNRSN
CRNRSN	Churn Reason	CRNRSN

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-12 Churn Reason Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCRNRSN	"Total Churn Reason"
CRNRSN	DWL_CHRN_RSN.CHRN_RSN_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-13 Churn Reason Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCRNRSN	"Total Churn Reason"
CRNRSN	DWL_CHRN_RSN.CHRN_RSN_CD

Collection Agency: CAGNCY

This dimension keeps all the information of the collection agency. Commission type is all type of commissions to the sales representatives.

Table 8-14 Collection Agency (CAGNCY) Levels and Hierarchies

Level	Description	Collection Agency Hierarchy (HCAGNCY)
TCAGNCY	Total Collection Agency	TCAGNCY
CAGNCY	Collection Agency	CAGNCY

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-15 Collection Agency Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCAGNCY	"Total Collection Agency"
CAGNCY	DWR_COLLCTN_AGNCY.PRTY_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-16 Collection Agency Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCAGNCY	"Total Collection Agency"
CAGNCY	DWR_COLLCTN_AGNCY.COLLCTN_AGNCY_CD

Attribute Name: Agency Manager(MGR_NAME)

Table 8-17 Collection Agency Agency Manager Attribute Mapping

Level	Mapping (Physical Column)
TCAGNCY
CAGNCY	DWR_COLLCTN_AGNCY.MGR_NAME

Attribute Name: Domestic Indicator(DMSTC_IND)

Table 8-18 Collection Agency Domestic Indicator Attribute Mapping

Level	Mapping (Physical Column)
TCAGNCY
CAGNCY	DWR_COLLCTN_AGNCY.DMSTC_IND

Commission Type: CMTYP

This dimension keeps all the information of the commission type. Commission type is all type of commissions to the sales representatives.

Table 8-19 Commission Type (CMTYP) Levels and Hierarchies

Level	Description	Commission Type Hierarchy (HCMTYP)
TCMTYP	Total Commission Type	TCMTYP
CMTYP	Commission Type	CMTYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-20 Commission Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCMTYP	"Total Commission Type"
CMTYP	DWL_CMISN_TYP.CMISN_TYP_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-21 Commission Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCMTYP	"Total Commission Type"
CMTYP	DWL_CMISN_TYP.CMISN_TYP_NAME

Cost Center: CCK

This dimension keeps all the information of the cost center.

Table 8-22 Cost Center (CCK) Levels and Hierarchies

Level	Description	Customer Hierarchy (HCCK)
TCCK	Totalcost center	TCCK
CCK	Cost center	CCK

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-23 Cost Center Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCCK	"TotalCost Center
CCK	DWR_COST_CNTR.COST_CNTR_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-24 Cost Center Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCCK	"TotalCost Center"
CCK	DWR_COST_CNTR.COST_CNTR_CD

Currency: CRNCY

This dimension keeps all the information of the different currencies.

Table 8-25 Currency (CRNCY) Levels and Hierarchies

Level	Description	Currency Hierarchy (HCRNCY)
TCRNCY	Total currency	TCRNCY
CRNCY	Currency	CRNCY

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-26 Currency Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCRNCY	"Total Currency"
CRNCY	DWL_CRNCY.CRNCY_DSCR

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-27 Currency Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCRNCY	"Total Currency"
CRNCY	DWL_CRNCY.CRNCY_NAME

Customer: CUST

This dimension keeps all the information of individual customers.

Table 8-28 Customer (CUST) Levels and Hierarchies

Level	Description	Customer Hierarchy (HCUST)
TCUST	Total customer	TCUST
CUSTYP	Customer Type	CUSTYP
ICUST	Individual Customer	ICUST

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-29 Customer Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCUST	"Total Customer"
CUSTYP	DWL_CUST_TYP.CUST_TYP_NAME
ICUST	DWR_CUST.NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-30 Customer Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCUST	"Total Customer"
CUSTYP	DWL_CUST_TYP.CUST_TYP_CD
ICUST	DWR_CUST.CUST_CD

Customer Segment: CSGMNT

This dimension keeps all the information of the Customer Segment. The Segments table holds details of all marketing segments. A segment identifies distinct groupings of customers or accounts with similar characteristics. The segments are typically used in marketing campaigns.

Table 8-31 Customer Segment (CSGMNT) Levels and Hierarchies

Level	Description	Customer Segment Hierarchy (HCSGMNT)
TCSGMNT	Total Customer Segment	TCSGMNT
CSGMNT	Customer Segment	CSGMNT

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-32 Customer Segment Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCSGMNT	"Total Customer Segment"
CSGMNT	DWR_CUST_SGMNT.CUST_SGMNT_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-33 Customer Segment Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCSGMNT	"Total Customer Segment"
CSGMNT	DWR_CUST_SGMNT.CUST_SGMNT_CD

Customer Type: CUSTYP

This dimension keeps all the information of customer type

Table 8-34 Customer Type (CUSTYP) Levels and Hierarchies

Level	Description	Customer Type Hierarchy (HCUSTYP)
TCUSTYP	Total Customer Type	TCUSTYP
CUSTYP	Customer Type	CUSTYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-35 Customer Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCUSTYP	"Total Customer Type"
CUSTYP	DWL_CUST_TYP.CUST_TYP_DESC

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-36 Customer Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCUSTYP	"Total Customer Type"
CUSTYP	DWL_CUST_TYP.CUST_TYP_NAME

Debt Aging Band: DAB

This dimension keeps all the information of debt aging band. There are customers who have not paid or partially paid one or more bills. This is called as Aging for the bill payment. Based on the age of unpaid or partial paid bill those amounts are put into different buckets for each customer.

Table 8-37 Debt Aging Band (DAB) Levels and Hierarchies

Level	Description	Debt Aging Band Hierarchy (HDAB)
TDAB	Total Aging Band	TDAB
DAB	Aging Band	DAB

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-38 Debt Aging Band Long Description Attribute Mapping

Level	Mapping (Physical Column)
TDAB	"Total Aging Band"
DAB	DWL_DEBT_AGNG_BND.DEBT_AGNG_BND_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-39 Debt Aging Band Short Description Attribute Mapping

Level	Mapping (Physical Column)
TDAB	"Total Aging Band"
DAB	DWL_DEBT_AGNG_BND.DEBT_AGNG_BND_CD

Geography: GEO

This dimension keeps all the geography information.

Table 8-40 Geography (GEO) Levels and Hierarchies

Level	Description	Geography Hierarchy (HGEO)
TGEO	Total Geography	TGEO
WORLD	World	WORLD
REGION	Region	REGION
SUB_REGION	Sub Region	SUB_REGION
COUNTRY	Country	COUNTRY
STATE	State	STATE
CITY	City	CITY
COUNTY	County	COUNTY

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-41 Geography Long Description Attribute Mapping

Level	Mapping (Physical Column)
TGEO	"Total Geography"
WORLD	DWR_GEO_WORLD.WORLD_NAME
REGION	DWR_GEO_RGN.RGN_NAME
SUB_REGION	DWR_GEO_SBRGN.SB_RGN_NAME
COUNTRY	DWR_GEO_CNTRY.CNTRY_NAME
STATE	DWR_GEO_STATE.STATE_NAME
CITY	DWR_GEO_CITY.CITY_NAME
COUNTY	DWR_GEO_CNTY.CNTY_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-42 Geography Short Description Attribute Mapping

Level	Mapping (Physical Column)
TGEO	"Total Geography"
WORLD	DWR_GEO_WORLD.WORLD_CD
REGION	DWR_GEO_RGN.RGN_CD
SUB_REGION	DWR_GEO_SBRGN.SB_RGN_CD
COUNTRY	DWR_GEO_CNTRY.CNTRY_CD
STATE	DWR_GEO_STATE.STATE_CD
CITY	DWR_GEO_CITY.CITY_CD
COUNTY	DWR_GEO_CNTY.CNTY_CD

Attribute Name: County Name(CNTY_NAME)

Table 8-43 Geography County Name Attribute Mapping

Level	Mapping (Physical Column)
TGEO
WORLD
REGION
SUB_REGION
COUNTRY
STATE
CITY
COUNTY	DWR_GEO_CNTY.CNTY_NAME

Attribute Name: County Code(CNTY_CD)

Table 8-44 Geography County Code Attribute Mapping

Level	Mapping (Physical Column)
TGEO
WORLD
REGION
SUB_REGION
COUNTRY
STATE
CITY
COUNTY	DWR_GEO_CNTY.CNTY_CD

Handset Model: HSMDL

This dimension keeps all the information about models of handsets.

Table 8-45 Handset Model (HSMDL) Levels and Hierarchies

Level	Description	Handset Model Hierarchy (HHSMDL)
THSMDL	Total Handset Model	THSMDL
HSMDL	Handset Model	HSMDL

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-46 Handset Model Long Description Attribute Mapping

Level	Mapping (Physical Column)
THSMDL	"Total Handset Model"
HSMDL	DWR_HNDST_MDL.HNDST_MDL_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-47 Handset Model Short Description Attribute Mapping

Level	Mapping (Physical Column)
THSMDL	"Total Handset Model"
HSMDL	DWR_HNDST_MDL.HNDST_MDL_CD

Invoice Adjustment Reason: IARSN

This dimension keeps all the information of invoice adjustment reason. The reason why the adjustment was put on the invoice.

Table 8-48 Invoice Adjustment Reason (IARSN) Levels and Hierarchies

Level	Description	Invoice Adjustment Reason Hierarchy (HIARSN)
TIARSN	Total Invoice Adjustment Reason	TIARSN
IARSN	Invoice Adjustment Reason	IARSN

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-49 Invoice Adjustment Reason Long Description Attribute Mapping

Level	Mapping (Physical Column)
TIARSN	"Total Invoice Adjustment Reason"
IARSN	DWL_INVC_ADJ_RSN.INVC_ADJ_RSN_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-50 Invoice Adjustment Reason Short Description Attribute Mapping

Level	Mapping (Physical Column)
TIARSN	"Total Invoice Adjustment Reason"
IARSN	DWL_INVC_ADJ_RSN.INVC_ADJ_RSN_CD

Invoice Adjustment Type: IATYP

This dimension keeps all the information of invoice adjustment type. The categories of adjustment applied to a Customer Invoices.

Table 8-51 Invoice Adjustment Type (IATYP) Levels and Hierarchies

Level	Description	Invoice Adjustment Type Hierarchy (HIATYP)
TIATYP	Total invoice adjustment type	TIATYP
IATYP	Invoice adjustment type	IATYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-52 Invoice Adjustment Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TIATYP	"Total Invoice Adjustment Type"
IATYP	DWL_INVC_ADJ_TYP.INVC_ADJ_TYP_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-53 Invoice Adjustment Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TIATYP	"Total Invoice Adjustment Type"
IATYP	DWL_INVC_ADJ_TYP.INVC_ADJ_TYP_CD

Organization: ORG

This dimension keeps all the information of organization

Default Hierarchy: HCHAIN

Table 8-54 Organization (ORG) Levels and Hierarchies

Level	Description	Corporation Hierarchy (HCORPORATE)	Banner Hierarchy (HBANNER)	Chain Hierarchy (HCHAIN)
TORG	Organization Total	TORG	TORG	TORG
CORPORATION	Head Office or Parent Company.	CORPORATION	CORPORATION	CORPORATION
COMPANY	Company, it includes branch company or subsidiary company.			COMPANY
DIVISION	The parent level of business unit. It is to organize the organization business units according to their functional role, for example, call center, warehouse, and so on.	DIVISION
BANNER	Holds the information about different organization banners under which product or service are sold.		BANNER
CHAIN	Chain of outlets through which the organization conducts business.			CHAIN
AREA	Areas within a organization chain.			AREA
REGION	Holds region within a company, chain area.			REGION
DISTRICT	Holds districts within a company, chain, area, region.			DISTRICT
BU	Organization Business Unit contains 2 kinds of information -store and branch company. In the higher level is branch company.Some customer cannot belong to a particular store, in that case, they are associated with a branch company. So branch company are put in organization business unit level.	BU	BU	BU

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-55 Organization Long Description Attribute Mapping

Level	Mapping (Physical Column)
TORG	'Total Organization'
CORPORATION	DWR_ORG_RGN.RGN_NAME
COMPANY	DWR_ORG_CMPNY.CMPNY_NAME
DIVISION	DWR_ORG_DIV.DIV_NAME
BANNER	DWR_ORG_BNR.BNR_NAME
CHAIN	DWR_ORG_CHAIN.CHAIN_NAME
AREA	DWR_ORG_AREA.AREA_NAME
REGION	DWR_ORG_RGN.RGN_NAME
DISTRICT	DWR_ORG_RGN.RGN_NAME
BU	DWR_ORG_BSNS_UNIT.PRTY_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-56 Organization Short Description Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION	DWR_ORG_CRPRT.CRPRT_CD
COMPANY	DWR_ORG_CMPNY.CMPNY_CD
DIVISION	DWR_ORG_DIV.DIV_CD
BANNER	DWR_ORG_BNR.BNR_CD
CHAIN	DWR_ORG_CHAIN.CHAIN_CD
AREA	DWR_ORG_AREA.AREA_CD
REGION	DWR_ORG_RGN.RGN_CD
DISTRICT	DWR_ORG_DSTRCT.DSTRCT_CD
BU	DWR_ORG_BSNS_UNIT.PRTY_CD

Attribute Name: Store Name (STORE_NAME)

Table 8-57 Organization Store Name Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION
COMPANY
DIVISION
BANNER
CHAIN
AREA
REGION
DISTRICT
BU	DWR_ORG_BSNS_UNIT.PRTY_NAME

Attribute Name: Store Description (STORE_DESC)

Table 8-58 Organization Store Description Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION
COMPANY
DIVISION
BANNER
CHAIN
AREA
REGION
DISTRICT
BU	DWR_ORG_BSNS_UNIT.PRTY_DSCR

Attribute Name: Store Manager (STORE_MANAGER)

Table 8-59 Organization Store Manager Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION
COMPANY
DIVISION
BANNER
CHAIN
AREA
REGION
DISTRICT
BU	DWR_ORG_BSNS_UNIT.MGR_NAME

Attribute Name: Store Open Date (STORE_OPEN_DT)

Table 8-60 Organization Store Open Date Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION
COMPANY
DIVISION
BANNER
CHAIN
AREA
REGION
DISTRICT
BU	DWR_ORG_BSNS_UNIT.VALID_STRT_DT

Attribute Name: Store Close Date (STORE_CLOSE_DT)

Table 8-61 Organization Store Close Date Attribute Mapping

Level	Mapping (Physical Column)
TORG
CORPORATION
COMPANY
DIVISION
BANNER
CHAIN
AREA
REGION
DISTRICT
BU	DWR_ORG_BSNS_UNIT.VALID_END_DT

Payment Channel: PCK

This dimension keeps all the information all the information of the payment channel.

Table 8-62 Payment Channel (PCK) Levels and Hierarchies

Level	Description	Payment Channel Hierarchy (HPCK)
TPCK	Totalpayment channel	TPCK
PCK	Payment channel	PCK

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-63 Payment Channel Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPCK	"TotalPayment Channel"
PCK	DWR_PYMT_CHNL.CHNL_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-64 Payment Channel Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPCK	"TotalPayment Channel"
PCK	DWR_PYMT_CHNL.CHNL_KEY

Payment Method Type: PMTYP

This dimension keeps all the information of the payment method type. Payment method type describes the different methods by which payments may be made. Customers can pay their bills, deposits, other charges by different modes of payment such as: Cash, Check, Inter-bank transfer, Postal order, Wire transfer, Voucher.

Table 8-65 Payment Method Type (PMTYP) Levels and Hierarchies

Level	Description	Payment Method Type Hierarchy (HPMTYP)
TPMTYP	Total Payment Method Type	TPMTYP
PMTYP	Payment Method Type	PMTYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-66 Payment Method Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPMTYP	"Total Payment Method Type"
PMTYP	DWL_PYMT_MTHD_TYP.PYMT_MTHD_TYP_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-67 Payment Method Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPMTYP	"Total Account Payment Method Status Type"
PMTYP	DWL_PYMT_MTHD_TYP.PYMT_MTHD_TYP_CD

Payment Transaction Type: PTTYP

This dimension keeps all the information of the type of transaction.

Table 8-68 Payment Transaction Type (PTTYP) Levels and Hierarchies

Level	Description	Payment Transaction Type Hierarchy (HPTTYP)
TPTTYP	Total Payment Transaction Type	TPTTYP
PTTYP	Payment transaction type	PTTYP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-69 Payment Transaction Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPTTYP	"Total Payment Transaction Type"
PTTYP	DWL_PYMT_TRX_TYP.PYMT_TRX_TYP_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-70 Payment Transaction Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPTTYP	"Total Payment Transaction Type"
PTTYP	DWL_PYMT_TRX_TYP. PYMT_TRX_TYP_CD

Peak Offpeak Time: POPT

This dimension keeps all the information of the peak and offpeak time. Based on the usage or traffic on the network each day is divided into various time slots such as the time when the usage is highest is called as the peak time slot

Table 8-71 Peak Offpeak Time (POPT) Levels and Hierarchies

Level	Description	Peak Offpeak Time Hierarchy (HPOPT)
TPOPT	Total Peak Offpeak Time	TPOPT
POPT	Peak Offpeak Time	POPT

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-72 Peak Offpeak Time Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPOPT	"Total Peak Offpeak Time"
POPT	DWL_PK_OFPK_TIME.PK_OFPK_TIME_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-73 Peak Offpeak Time Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPOPT	"Total Peak Offpeak Time"
POPT	DWL_PK_OFPK_TIME.PK_OFPK_TIME_CD

Attribute Name: Peak Offpeak Start Time(PK_OFPK_STRT)

Table 8-74 Peak Offpeak Time Peak Offpeak Start Time Attribute Mapping

Level	Mapping (Physical Column)
TPOPT
POPT	DWL_PK_OFPK_TIME.PK_OFPK_STRT

Attribute Name: Peak Offpeak End Time(PK_OFPK_END)

Table 8-75 Peak Offpeak Time Peak Offpeak End Time Attribute Mapping

Level	Mapping (Physical Column)
TPOPT
POPT	DWL_PK_OFPK_TIME.PK_OFPK_END

Attribute Name: Holiday Indicator (HOLIDY_IND)

Table 8-76 Peak Offpeak Time Holiday Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPOPT
POPT	DWL_PK_OFPK_TIME.HOLIDY_IND

Attribute Name: Weekend Indicator (WEEKEND_IND)

Table 8-77 Peak Offpeak Time Weekend Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPOPT
POPT	DWL_PK_OFPK_TIME.WKEND_IND

Product: PROD

This dimension keeps all the information of products, services and value added features offering by the telecommunication company.

Table 8-78 Product (PROD) Levels and Hierarchies

Level	Description	Product Hierarchy (HPROD)
TPROD	Total Product	TPROD
PRODTYP	Type of the product	PRODTYP
PROD	The product provided by the carrier.	PROD

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-79 Product Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	"Total Product"
PRODTYP	DWL_PROD_SPEC_TYP.PROD_SPEC_TYP_NAME
PROD	DWR_PROD_SPEC.PROD_SPEC_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-80 Product Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	"Total Product"
PRODTYP	DWL_PROD_SPEC_TYP.PROD_SPEC_TYP_CD
PROD	DWR_PROD_SPEC.PROD_SPEC_CD

Attribute Name: IN Platform Key(IN_PLTFRM_KEY)

Id for IN Platform

Table 8-81 Product IN Platform Key Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PRODTYP
PROD	DWR_PROD_SPEC.IN_PLTFRM_KEY

Product Offer: POFR

This dimension keeps all the information of the product offer.

Table 8-82 Product Offer (ARRSN) Levels and Hierarchies

Level	Description	Product Hierarchy (HPOFR)
TPOFR	Totalproduct offer	TPOFR
POFRTYPE	Product offer type	POFRTYPE
POFR	Product offer	POFR

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-83 Product Offer Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPOFR	Total Product Offer
POFRTYPE	DWL_PROD_OFR_TYP.PROD_OFR_TYP_NAME
POFR	DWL_PROD_OFR_TYP.PROD_OFR_TYP_CD

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-84 Product Offer Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPOFR	Total Product Offer'
POFRTYPE	DWR_CALL_CNTR. CALL_CNTR_CD
POFR	DWR_PROD_OFR.PROD_OFR_CD

Attribute Name: Joint Program Indicator (JP_IND)

Table 8-85 Product Offer Joint Program Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPOFR
POFRTYPE
POFR	DWR_PROD_OFR.JNT_PROG_IND

Attribute Name: Loyalty Program Indicator (LP_IND)

Table 8-86 Product Offer Loyalty Program Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPOFR
POFRTYPE
POFR	DWR_PROD_OFR.LYLTY_PROG_IND

Attribute Name: New Customer Only Indicator (NC_IND)

Table 8-87 Product Offer New Customer Only Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPOFR
POFRTYPE
POFR	DWR_PROD_OFR.NEW_CUST_ONLY_IND

Attribute Name: VAS Indicator (VAS_IND)

Table 8-88 Product Offer VAS Indicator Attribute Mapping

Level	Mapping (Physical Column)
TCCNTR
CCNTR
CCAT	DWR_PROD_OFR.VAS_IND

Promotion: PRMTN

This dimension keeps all the information of the promotion.

Table 8-89 Promotion (PRMTN) Levels and Hierarchies

Level	Description	Promotion Hierarchy (HPRMTN)
TPRMTN	Total promotion	TPRMTN
PRMTNTYP	Promotion type	PRMTNTYP
CCCSTYP	Promotion	CCCSTYP

Table 8-90 Promotion (HCMPGN) Levels and Hierarchies

Level	Description	Promotion Hierarchy (HCMPGN)
TPRMTN	Total promotion	TPRMTN
CMPGN	Campaign	CMPGN
PRMTN	Promotion	PRMTN

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-91 Promotion Long Description Attribute Mapping

Level	Mapping (Physical Column)
TCCC	"Total Promotion"
PRMTNTYP	DWL_PRMTN_TYP.PRMTN_TYP_NAME
CMPGN	DWR_CMPGN.CMPGN_DSCR
PRMTN	DWR_PRMTN.PRMTN_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-92 Promotion Short Description Attribute Mapping

Level	Mapping (Physical Column)
TCCC	"Total Promotion"
PRMTNTYP	DWL_PRMTN_TYP.PRMTN_TYP_CD
CMPGN	DWR_CMPGN.CMPGN_CD
PRMTN	DWR_PRMTN.PRMTN_CD

Resource: RSCEK

This dimension keeps all the information for resources.

Table 8-93 Resource (RSCEK) Levels and Hierarchies

Level	Description	Resource Hierarchy (HRSCEK)
TRSCEK	Total resource	TRSCEK
RSCEK	Resource	RSCEK

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-94 Resource Long Description Attribute Mapping

Level	Mapping (Physical Column)
TRSCEK	"Total Resourc"
RSCEK	DWR_RSCE.RSCE_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-95 Resource Short Description Attribute Mapping

Level	Mapping (Physical Column)
TRSCEK	"Total Resource"
RSCEK	DWR_RSCE.RSCE_CD

Sales Channel: SLCHNL

This dimension keeps all the information of Sales Channel.

Table 8-96 Sales Channel (SLCHNL) Levels and Hierarchies

Level	Description	Sales Channel Hierarchy (HSLCHNL)
TSLCHNL	Total Sales Channel	TSLCHNL
SLCHNL	Sales Channel	SLCHNL

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-97 Sales Channel Long Description Attribute Mapping

Level	Mapping (Physical Column)
TSLCHNL	"Total Sales Channel"
SLCHNL	DWR_SL_CHNL.CHNL_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-98 Sales Channel Short Description Attribute Mapping

Level	Mapping (Physical Column)
TSLCHNL	"Total Sales Channel"
SLCHNL	DWR_SL_CHNL.CHNL_CD

Attribute Name: Capacity Quantity (CPCTY_QTY):

The number of transaction that a Channel can handle, at a point of time.

Table 8-99 Sales Channel Capacity Quantity Attribute Mapping

Level	Mapping (Physical Column)
TSLCHNL
SLCHNL	DWR_SL_CHNL.CPCTY_QTY

Sales Channel Representative: SLR

This dimension keeps all the information for the sales channel representative.

Table 8-100 Sales Channel Representative (SLR) Levels and Hierarchies

Level	Description	Sales Channel Representative Hierarchy (HRSCEK)
TSLR	Total sales channelrepresentative	TSLR
SLR	Sales channelrepresentive	SLR

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-101 Sales Channel Representative Long Description Attribute Mapping

Level	Mapping (Physical Column)
TSLR	Total Sale Channel Representative'
SLR	DWR_SL_CHNL_RPRSTV.SL_CHNL_RPRSTV_CD

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-102 Sales Channel Representative Short Description Attribute Mapping

Level	Mapping (Physical Column)
TSLR	Total Sale Channel Representative'
SLR	DWR_SL_CHNL_RPRSTV.SL_CHNL_RPRSTV_CD

SKU Item: SKUITEM

This dimension stores the products as SKU items used in Oracle Communications Data Model.

Default Hierarchy:

Table 8-103 Product Hierarchy and Cluster Hierarchy

Level	Description	Product Hierarchy (HPROD)	Product Cluster Hierarchy (HPCLUSTER)
TPROD	Total Product	TPROD	TPROD
PCLUSTER	Product Cluster		PCLUSTER
COMPANY	Company	COMPANY
DIVISION	Division	DIVISION
GROUP^Foot 1	Group	GROUP
DEPT	Department	DEPT
CLASS	Class	CLASS
SUBCLASS	Sub Class	SUBCLASS
ITEM	Item	ITEM	ITEM
SKU	SKU Item	SKU	SKU

^Footnote 1For Oracle Communications Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Communications Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions.

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-104 Product Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	'Total Product'
PCLUSTER	DWR_ITEM_CLSTR.ITEM_CLSTR_DESC
COMPANY	DWR_ITEM_CMPNY.ITEM_CMPNY_NAME
DIVISION	DWR_ITEM_DIV.ITEM_DIV_NAME
GROUP	DWR_ITEM_GRP.ITEM_GRP_NAME
DEPT	DWR_ITEM_DEPT.ITEM_DEPT_NAME
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_NAME
SUBCLASS	DWR_ITEM_SBC.SBC_NAME
ITEM	DWR_ITEM.ITEM_DESC
SKU	DWR_SKU_ITEM.SKU_ITEM_DESC

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-105 Product Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	'Total Product'
PCLUSTER	DWR_ITEM_CLSTR.ITEM_CLSTR_CD
COMPANY	DWR_ITEM_CMPNY.ITEM_CMPNY_CD
DIVISION	DWR_ITEM_DIV.ITEM_DIV_CD
GROUP	DWR_ITEM_GRP.ITEM_GRP_CD
DEPT	DWR_ITEM_DEPT.ITEM_DEPT_CD
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_CD
SUBCLASS	DWR_ITEM_SBC.SBC_CD
ITEM	DWR_ITEM.ITEM_NAME
SKU	DWR_SKU_ITEM.SKU_ITEM_NAME

Attribute Name: Buyer Code (BUYER_CODE)

Table 8-106 Product Buyer Code Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION	DWR_ITEM_DIV.ITEM_DIV_BYR_CD
GROUP	DWR_ITEM_GRP.ITEM_GRP_BYR_CD
DEPT	DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD
SUBCLASS	DWR_ITEM_SBC.SBC_BYR_CD
ITEM
SKU

Attribute Name: Buyer Name (BUYER_NAME)

Table 8-107 Product Buyer Name Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION	DWR_ITEM_DIV.ITEM_DIV_BYR_NAME
GROUP	DWR_ITEM_GRP.ITEM_GRP_BYR_NAME
DEPT	DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME
SUBCLASS	DWR_ITEM_SBC.SBC_BYR_NAME
ITEM
SKU

Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)

Table 8-108 Product Item Conv Type Code Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION
GROUP
DEPT
CLASS
SUBCLASS
ITEM	DWR_ITEM.CONVBL_TYP_CD
SKU

Attribute Name: Item Discount Indicator (ITEM_DISC_IND)

Table 8-109 Product Item Discount Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION
GROUP
DEPT
CLASS
SUBCLASS
ITEM	DWR_ITEM.DISC_IND
SKU

Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)

Table 8-110 Product Item Display Unit Type Code Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION
GROUP
DEPT
CLASS
SUBCLASS
ITEM	DWR_ITEM.DSPLY_UNIT_TYP_CD
SKU

Attribute Name: Item Number (ITEM_NBR)

Table 8-111 Product Item Number Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION
GROUP
DEPT
CLASS
SUBCLASS
ITEM	DWR_ITEM.ITEM_NBR
SKU

Attribute Name: Merchandiser Code (MERC_CODE)

Table 8-112 Product Merchandiser Code Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION	DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD
GROUP	DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD
DEPT	DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD
SUBCLASS	DWR_ITEM_SBC.SBC_MRCHNDSR_CD
ITEM
SKU

Attribute Name: Merchandiser Name (MERC_NAME)

Table 8-113 Product Merchandiser Name Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION	DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME
GROUP	DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME
DEPT	DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME
CLASS	DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME
SUBCLASS	DWR_ITEM_SBC.SBC_MRCHNDSR_NAME
ITEM
SKU

Attribute Name: SKU Item Number (SKU_ITEM_NBR)

Table 8-114 Product SKU Item Number Attribute Mapping

Level	Mapping (Physical Column)
TPROD
PCLUSTER
COMPANY
DIVISION
GROUP
DEPT
CLASS
SUBCLASS
ITEM
SKU	DWR_SKU_ITEM.SKU_ITEM_NBR

Time: TIME

This dimension keeps all the information of time.

Table 8-115 Time (TIME) Levels and Hierarchies

Level	Description	Time Business Hierarchy (HTBSNS)
TTIME	Time Total	TTIME
BSNS_YR	Business Year	BSNS_YR
BSNS_HLF_YR	Business Half Year	BSNS_HLF_YR
BSNS_QTR	Business Quarter	BSNS_QTR
BSNS_MO	Business Month	BSNS_MO

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-116 Time Long Description Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_DSCR
BSNS_YR	DWR_BSNS_YR.BSNS_YR_DSCR
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_DSCR
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_DSCR
BSNS_MO	DWR_BSNS_MO.BSNS_MO_DSCR

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-117 Time Short Description Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_CD
BSNS_YR	DWR_BSNS_YR.BSNS_YR_CD
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_CD
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_CD
BSNS_MO	DWR_BSNS_MO.BSNS_MO_CD

Attribute Name: Time Number(TIME_NBR)

Table 8-118 Time Time Number Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_NBR
BSNS_YR	DWR_BSNS_YR.BSNS_YR_NBR
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_NBR
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_NBR
BSNS_MO	DWR_BSNS_MO.BSNS_MO_NBR

Attribute Name: Time Span(TIME_SPAN)

Table 8-119 Time Time Span Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_TIMESPN
BSNS_YR	DWR_BSNS_YR.BSNS_YR_TIMESPN
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_TIMESPN
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_TIMESPN
BSNS_MO	DWR_BSNS_MO.BSNS_MO_TIMESPN

Attribute Name: Start Date(START_DATE)

Table 8-120 Time Start Date Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_STRT_DT
BSNS_YR	DWR_BSNS_YR.BSNS_YR_STRT_DT
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_STRT_DT
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_ STRT_DT
BSNS_MO	DWR_BSNS_MO.BSNS_MO_STRT_DT

Attribute Name: End Date(END_DATE)

Table 8-121 Time End Date Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_END_DT
BSNS_YR	DWR_BSNS_YR.BSNS_YR_END_DT
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_END_DT
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_END_DT
BSNS_MO	DWR_BSNS_MO.BSNS_MO_END_DT

Time Day: TIME_DAY

This dimension stores Time related data used in Oracle Communications Data Model.

Default Hierarchy: HTBSNS

Table 8-122 Time Levels and Hierarchies

Level	Description	Time Business Hierarchy (HTBSNS)	Time Calendar Hierarchy (HTCLNDR)	Time Calendar Week Hierarchy (HTCLNDRWK)
TTIME	Total Time	TTIME	TTIME	TTIME
CLNDR_YR	Calendar Year		CLNDR_YR
CLNDR_HLF_YR	Calendar Half Year		CLNDR_HLF_YR
CLNDR_QTR	Calendar Quarter		CLNDR_QTR
CLNDR_MO	Calendar Month		CLNDR_MO
CLNDR_HLF_MO	Calendar Half Month		CLNDR_HLF_MO
CLNDR_WK	Calendar Week		CLNDR_WK	CLNDR_WK
BSNS_YR	Business Year	BSNS_YR
BSNS_HLF_YR	Business Half Year	BSNS_HLF_YR
BSNS_QTR	Business Quarter	BSNS_QTR
BSNS_MO	Business Month	BSNS_MO
BSNS_HLF_MO	Business Half Month	BSNS_HLF_MO
BSNS_WK	Business Week	BSNS_WK
DAY	Day	DAY	DAY	DAY

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-123 Time Long Description Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TOT_TIME.TOT_DSCR
CLNDR_YR	DWR_CLNDR_YR.YR_DSCR
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.HLF_YR_DSCR
CLNDR_QTR	DWR_CLNDR_QTR.QTR_DSCR
CLNDR_MO	DWR_CLNDR_MO.MO_DSCR
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.HLF_MO_DSCR
CLNDR_WK	DWR_CLNDR_WK.WK_DSCR
BSNS_YR	DWR_BSNS_YR.YR_DSCR
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_DSCR
BSNS_QTR	DWR_BSNS_QTR.QTR_DSCR
BSNS_MO	DWR_BSNS_MO.MO_DSCR
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_DSCR
BSNS_WK	DWR_BSNS_WK.WK_DSCR
DAY	DWR_DAY.BSNS_DT_DSCR

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-124 Time Short Description Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TOT_TIME.TOT_CD
CLNDR_YR	DWR_CLNDR_YR.YR_CD
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.HLF_YR_CD
CLNDR_QTR	DWR_CLNDR_QTR.QTR_CD
CLNDR_MO	DWR_CLNDR_MO.MO_CD
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.HLF_MO_CD
CLNDR_WK	DWR_CLNDR_WK.WK_CD
BSNS_YR	DWR_BSNS_YR.YR_CD
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_CD
BSNS_QTR	DWR_BSNS_QTR.QTR_CD
BSNS_MO	DWR_BSNS_MO.MO_CD
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_CD
BSNS_WK	DWR_BSNS_WK.WK_CD
DAY	DWR_DAY.BSNS_DT_DSCR

Attribute Name: End Date (END_DATE)

Table 8-125 Time End Date Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TOT_TIME.END_DATE
CLNDR_YR	DWR_CLNDR_YR.YR_END_DT
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.HLF_YR_END_DT
CLNDR_QTR	DWR_CLNDR_QTR.QTR_END_DT
CLNDR_MO	DWR_CLNDR_MO.MO_END_DT
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.HLF_MO_END_DT
CLNDR_WK	DWR_CLNDR_WK.WK_END_DT
BSNS_YR	DWR_BSNS_YR.YR_END_DT
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_END_DT
BSNS_QTR	DWR_BSNS_QTR.QTR_END_DT
BSNS_MO	DWR_BSNS_MO.MO_END_DT
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_END_DT
BSNS_WK	DWR_BSNS_WK.WK_END_DT
DAY	DWR_DAY.BSNS_END_DT

Attribute Name: Time Span (TIME_SPAN)

Table 8-126 Time Time Span Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TOT_TIME.TOT_TIME_SPAN
CLNDR_YR	DWR_CLNDR_YR.YR_TIMESPN
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.HLF_YR_TIMESPN
CLNDR_QTR	DWR_CLNDR_QTR.QTR_TIMESPN
CLNDR_MO	DWR_CLNDR_MO.MO_TIMESPN
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.HLF_MO_TIMESPN
CLNDR_WK	DWR_CLNDR_WK.WK_TIMESPN
BSNS_YR	DWR_BSNS_YR.YR_TIMESPN
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_TIMESPN
BSNS_QTR	DWR_BSNS_QTR.QTR_TIMESPN
BSNS_MO	DWR_BSNS_MO.MO_TIMESPN
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_TIMESPN
BSNS_WK	DWR_BSNS_WK.WK_TIMESPN
DAY	DWR_DAY.BSNS_DAY_TIMESPAN

Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)

Table 8-127 Time Business Holiday Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.BSNS_HOLIDY_IND

Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)

Table 8-128 Time Business Weekend Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.BSNS_WEEKEND_IND

Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)

Table 8-129 Time Business Working Day Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.BSNS_WRKING_DAY_IND

Attribute Name: Number (NBR)

Table 8-130 Time Number Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR	TO_NUMBER(DWR_CLNDR_YR.YR_NBR)
CLNDR_HLF_YR	TO_NUMBER(DWR_CLNDR_HLF_YR.HLF_YR_NBR)
CLNDR_QTR	TO_NUMBER(DWR_CLNDR_QTR.QTR_NBR)
CLNDR_MO	TO_NUMBER(DWR_CLNDR_MO.MO_NBR)
CLNDR_HLF_MO	TO_NUMBER(DWR_CLNDR_HLF_MO.HLF_MO_NBR)
CLNDR_WK	TO_NUMBER(DWR_CLNDR_WK.WK_NBR)
BSNS_YR	TO_NUMBER(DWR_BSNS_YR.YR_NBR)
BSNS_HLF_YR	TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR)
BSNS_QTR	TO_NUMBER(DWR_BSNS_QTR.QTR_NBR)
BSNS_MO	TO_NUMBER(DWR_BSNS_MO.MO_NBR)
BSNS_HLF_MO	TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR)
BSNS_WK	TO_NUMBER(DWR_BSNS_WK.WK_NBR)
DAY	TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR)

Attribute Name: Calendar Holiday Indicator (CLNDR_HLDY_IND)

Table 8-131 Time Calendar Holiday Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.CLNDR_HOLIDY_IND

Attribute Name: Calendar Weekend Indicator (CLNDR_WEND_IND)

Table 8-132 Time Calendar Weekend Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.CLNDR_WEEKEND_IND

Attribute Name: Calendar Working Day Indicator (CLNDR_WRK_IND)

Table 8-133 Time Calendar Working Day Indicator Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR
CLNDR_HLF_YR
CLNDR_QTR
CLNDR_MO
CLNDR_HLF_MO
CLNDR_WK
BSNS_YR
BSNS_HLF_YR
BSNS_QTR
BSNS_MO
BSNS_HLF_MO
BSNS_WK
DAY	DWR_DAY.CLNDR_WRKING_DAY_IND

Attribute Name: Identifier (ID)

Table 8-134 Time Identifier Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TOT_TIME.TOT_KEY
CLNDR_YR	DWR_CLNDR_YR.CLNDR_YR_KEY
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.CLNDR_HLF_YR_KEY
CLNDR_QTR	DWR_CLNDR_QTR.CLNDR_QTR_KEY
CLNDR_MO	DWR_CLNDR_MO.CLNDR_MO_KEY
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.CLNDR_HLF_MO_KEY
CLNDR_WK	DWR_CLNDR_WK.CLNDR_WK_KEY
BSNS_YR	DWR_BSNS_YR.BSNS_YR_KEY
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_KEY
BSNS_QTR	DWR_BSNS_QTR.QTR_KEY
BSNS_MO	DWR_BSNS_MO.MO_KEY
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_KEY
BSNS_WK	DWR_BSNS_WK.WK_KEY
DAY	DWR_DAY.DAY_KEY

Attribute Name: Start Date (START_DATE)

Table 8-135 Time Start Date Attribute Mapping

Level	Mapping (Physical Column)
TTIME
CLNDR_YR	DWR_CLNDR_YR.YR_STRT_DT
CLNDR_HLF_YR	DWR_CLNDR_HLF_YR.HLF_YR_STRT_DT
CLNDR_QTR	DWR_CLNDR_QTR.QTR_STRT_DT
CLNDR_MO	DWR_CLNDR_MO.MO_STRT_DT
CLNDR_HLF_MO	DWR_CLNDR_HLF_MO.HLF_MO_STRT_DT
CLNDR_WK	DWR_CLNDR_WK.WK_STRT_DT
BSNS_YR	DWR_BSNS_YR.YR_STRT_DT
BSNS_HLF_YR	DWR_BSNS_HLF_YR.HLF_YR_STRT_DT
BSNS_QTR	DWR_BSNS_QTR.QTR_STRT_DT
BSNS_MO	DWR_BSNS_MO.MO_STRT_DT
BSNS_HLF_MO	DWR_BSNS_HLF_MO.HLF_MO_STRT_DT
BSNS_WK	DWR_BSNS_WK.WK_STRT_DT
DAY	DWR_DAY.BSNS_STRT_DT

Time Slot: TSLT

This dimension keeps information for Time Slot.

Default Hierarchy: HTSLT

Table 8-136 Time Slot (TSLT) Levels and Hierarchies

Level	Description	Time Slot Hierarchy (HTSLT)
TTSLT	Total Time Slot	TTSLT
TSLT	Time Slot	TSLT

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-137 Time Slot Long Description Attribute Mapping

Level	Mapping (Physical Column)
TTSLT	"Total Time Slot"
TSLT	DWR_TIME_SLT.TIME_SLT_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-138 Time Slot Short Description Attribute Mapping

Level	Mapping (Physical Column)
TTSLT	"Total Time Slot"
TSLT	DWR_TIME_SLT.TIME_SLT_CD