Skip Headers

Oracle® Communications Data Model Reference 11g Release 2 (11.2) Part Number E15886-05 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 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