Skip Headers
Oracle® Communications Data Model Reference
11g Release 2 (11.2)

Part Number E15886-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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:

Table 8-1 lists the dimensions.

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