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 Schema do the following:

Directly map 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, those available for Cube MV based Query Rewrite and otherwise, 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.

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
Churn Reason: CRNRSN
Collection Agency: CAGNCY
Commission Type: CMTYP
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
Mining Churn Type: MNCT
Mining Life Time Survival Band: MNLSB
Mining Life Time Value Band: MNLVB
Mining Sentiment Category: MNSC
Network Element: NELMNT
Organization: ORG
Payment Channel: PCHNL
Payment Method Type: PMTYP
Payment Transaction Type: PTTYP
Peak Offpeak Time: POPT
Product: PROD
Product Market Plan: PMP
Sales Channel: SLCHNL
Time: TIME
Time Slot: TSLT

Account Refund Reason: ARRSN

This dimension keeps all the information of 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

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-5 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-6 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-7 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-8 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-9 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-10 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-11 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-12 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-13 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-14 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-15 Commission Type Short Description Attribute Mapping

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

Customer: CUST

This dimension keeps all the information of individual customers.

Table 8-16 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-17 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-18 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-19 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-20 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-21 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-22 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-23 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-24 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-25 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-26 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-27 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-28 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-29 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-30 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-31 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-32 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-33 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-34 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-35 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-36 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-37 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-38 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-39 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-40 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-41 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

Mining Churn Type: MNCT

This dimension keeps all the information of Mining Churn Type.

Table 8-42 Mining Churn Type (MNCT) Levels and Hierarchies

Level	Description	Mining Churn Type Hierarchy (HMNCT)
TMNCT	Total Mining Churn Type	TMNCT
MNCT	Mining Churn Type	MNCT

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-43 Mining Churn Type Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMNCT	"Total Mining Churn Type"
MNCT	DWL_MNNG_CHRN_TYP.CHRN_TYP_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-44 Mining Churn Type Short Description Attribute Mapping

Level	Mapping (Physical Column)
TMNCT	"Total Mining Churn Type"
MNCT	DWL_MNNG_CHRN_TYP.CHRN_TYP_CD

Mining Life Time Survival Band: MNLSB

This dimension keeps all the information of Mining Life Time Survival Band.

Table 8-45 Mining Life Time Survival Band (MNLSB) Levels and Hierarchies

Level	Description	Mining Life Time Survival Band Hierarchy (HMNLSB)
TMNLSB	Total Mining Life Time Survival Band	TMNLSB
MNLSB	Mining Life Time Survival Band	MNLSB

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-46 Mining Life Time Survival Band Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMNLVB	"Total Mining Life Time Survival Band"
MNLVB	DWL_MNNG_LT_SRVVL_BAND.LT_SRVVL_BAND_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-47 Mining Life Time Survival Band Short Description Attribute Mapping

Level	Mapping (Physical Column)
TMNLVB	"Total Mining Life Time Survival Band"
MNLVB	DWL_MNNG_LT_SRVVL_BAND.LT_SRVVL_BAND_CD

Mining Life Time Value Band: MNLVB

This dimension keeps all the information of Mining Life Time Value Band.

Table 8-48 Mining Life Time Value Band (MNLVB) Levels and Hierarchies

Level	Description	Mining Life Time Value Band Hierarchy (HMNLVB)
TMNLVB	Total Mining Life Time Value Band	TMNLVB
MNLVB	Mining Life Time Value Band	MNLVB

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-49 Mining Life Time Value Band Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMNLVB	"Total Mining Life Time Value Band"
MNLVB	DWL_MNNG_LTV_BAND.LTV_BAND_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-50 Mining Life Time Value Short Description Attribute Mapping

Level	Mapping (Physical Column)
TMNLVB	"Total Mining Life Time Value Band"
MNLVB	DWL_MNNG_LTV_BAND.LTV_BAND_CD

Mining Sentiment Category: MNSC

This dimension keeps all the information of Mining Sentiment Category.

Table 8-51 Mining Sentiment Category (MNSC) Levels and Hierarchies

Level	Description	Mining Sentiment Category Hierarchy (HMNSC)
TMNSC	Total Mining Sentiment Category	TMNSC
MNSC	Mining Sentiment Category	MNSC

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-52 Mining Sentiment Category Long Description Attribute Mapping

Level	Mapping (Physical Column)
TMNSC	"Total Mining Sentiment Category"
MNSC	DWL_MNNG_SNTMNT_CTGRY.SNTMNT_CTGRY_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-53 Mining Sentiment Category Short Description Attribute Mapping

Level	Mapping (Physical Column)
TMNSC	"Total Mining Sentiment Category"
MNSC	DWL_MNNG_SNTMNT_CTGRY.SNTMNT_CTGRY_CD

Network Element: NELMNT

This dimension keeps all the information of Network Element. Network Element is For analytical purpose, derived from "BTS/Switch/Network".

Table 8-54 Network Element (NELMNT) Levels and Hierarchies

Level	Description	Network Element Hierarchy (HNELMNT)
TNELMNT	Total Network Element	TNELMNT
NELMNT	Network Element	NELMNT

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-55 Network Element Long Description Attribute Mapping

Level	Mapping (Physical Column)
TNELMNT	"Total Network Element"
NELMNT	DWR_NTWK_ELMNT.NTWK_ELMNT_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-56 Network Element Short Description Attribute Mapping

Level	Mapping (Physical Column)
TNELMNT	"Total Network Element"
NELMNT	DWR_NTWK_ELMNT.NTWK_ELMNT_CD

Organization: ORG

This dimension keeps all the information of organization

Default Hierarchy: HCHAIN

Table 8-57 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-58 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-59 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-60 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-61 Organization Store Description Attribute Mapping

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

Attribute Name: Store Manager (STORE_MANAGER)

Table 8-62 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-63 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-64 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: PCHNL

This dimension keeps all the information of Channel which customer used to pay for the services.

Table 8-65 Payment Channel (PCHNL) Levels and Hierarchies

Level	Description	Payment Channel Hierarchy (HPCHNL)
TPCHNL	Total Payment Channel	TPCHNL
PCHNLTYP	Type of the payment channel	PCHNLTYP
PCHNL	Channel which customer used to pay for the services.	PCHNL

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-66 Payment Channel Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPCHNL	"Total Payment Channel"
PCHNLTYP	DWL_CHNL_TYP.CHNL_TYP_NAME
PCHNL	DWR_PYMT_CHNL.CHNL_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-67 Payment Channel Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPCHNL	"Total Payment Channel"
PCHNLTYP	DWL_CHNL_TYP.CHNL_TYP_CD
PCHNL	DWR_PYMT_CHNL.PYMNT_CHNL_CD

Attribute Name: Capacity Quantity (CPCTY_QTY):

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

Table 8-68 Payment Channel Capacity Quantity Attribute Mapping

Level	Mapping (Physical Column)
TPCHNL
PCHNLTYP
PCHNL	DWR_PYMT_CHNL.CPCTY_QTY

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-69 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-70 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-71 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-72 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-73 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-74 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-75 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-76 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-77 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-78 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-79 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-80 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-81 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-82 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-83 Product Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	"Total Product"
PRODTYP	DWL_PROD_TYP.PROD_TYP_NAME
PROD	DWR_PROD.PROD_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-84 Product Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPROD	"Total Product"
PRODTYP	DWL_PROD_TYP.PROD_TYP_CD
PROD	DWR_PROD.PROD_CD

Attribute Name: IN Platform Key(IN_PLTFRM_KEY)

Id for IN Platform

Table 8-85 Product IN Platform Key Attribute Mapping

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

Product Market Plan: PMP

The product package was rendered to market through market plan, which usually contains some gifts and discount.

Table 8-86 Product Market Plan (PMP) Levels and Hierarchies

Level	Description	Product Market Plan Hierarchy (HPMP)
TPMP	Total Product Market Plan	TPMP
PMPTYP	Type of the product market plan	PMPTYP
PMP	The product package was rendered to market through market plan.	PMP

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-87 Product Market Plan Long Description Attribute Mapping

Level	Mapping (Physical Column)
TPMP	"Total Product Market Plan"
PMPTYP	DWL_PROD_MKT_PLN_TYP.MKT_PLN_TYP_NAME
PMP	DWR_ PROD_MKT_PLN.MKT_PLN_NAME

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-88 Product Market Plan Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPMP	"Total Product Market Plan"
PMPTYP	DWL_PROD_MKT_PLN_TYP.MKT_PLN_TYP_CD
PMP	DWR_PROD_MKT_PLN.MKT_PLN_CD

Attribute Name: New Customer Only Indicator (NC_IND)

Table 8-89 Product Market Plan New Customer Only Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPMP
PMPTYP
PMP	DWR_PROD_MKT_PLN.NEW_CUST_ONLY_IND

Attribute Name: Joint Program Indicator (JP_IND)

Table 8-90 Product Market Plan Joint Program Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPMP
PMPTYP
PMP	DWR_PROD_MKT_PLN. JNT_PROG_IND

Attribute Name: Loyalty Program Indicator (LP_IND)

Table 8-91 Product Market Plan Loyalty Program Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPMP
PMPTYP
PMP	DWR_PROD_MKT_PLN. LYLTY_PROG_IND

Attribute Name: VAS Indicator (VAS_IND)

Table 8-92 Product Market Plan VAS Indicator Attribute Mapping

Level	Mapping (Physical Column)
TPMP
PMPTYP
PMP	DWR_PROD_MKT_PLN. VAS_IND

Promotion: PRMTN

This dimension keeps one promotion action in the campaign. You can use this dimension to evaluate effectiveness of a campaign. For example, target customer or promotion channel.

Default Hierarchy: HPRMTN

Table 8-93 Promotion (PRMTN) Levels and Hierarchies

Level	Description	Promotion Type Hierarchy (HPRMTN)	Promotion Campaign Hierarchy (HCMPGN)
TPRMTN	Total promotion	TPRMTN	TPRMTN
PRMTNTYP	Type of the promotion	PRMTNTYP
CMPGN	Campaign		CMPGN
PRMTN	Promotion	PRMTN	PRMTN

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-94 Promotion Long Description Attribute Mapping

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

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-95 Promotion Short Description Attribute Mapping

Level	Mapping (Physical Column)
TPRMTN	"Total Promotion"
PRMTNTYP	DWL_PRMTN_TYP.PRMTN_TYP_CD
CMPGN	DWR_CMPGN.CMPGN_CD
PRMTN	DWR_PRMTN.PRMTN_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

Time: TIME

This dimension keeps all the information of time.

Table 8-100 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-101 Time Long Description Attribute Mapping

Level	Mapping (Physical Column)
TTIME	DWR_TIME_TOT.TOT_DESC
BSNS_YR	DWR_BSNS_YR.BSNS_YR_DESC
BSNS_HLF_YR	DWR_BSNS_HLF_YR.BSNS_HLF_YR_DESC
BSNS_QTR	DWR_BSNS_QTR.BSNS_QTR_DESC
BSNS_MO	DWR_BSNS_MO.BSNS_MO_DESC

Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-102 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-103 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-104 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-105 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-106 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 Slot: TSLT

This dimension keeps information for Time Slot.

Default Hierarchy: HTSLT

Table 8-107 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-108 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-109 Time Slot Short Description Attribute Mapping

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