Index

A B C D E F G H I L M N O P Q R S T U V

A

access method logical dimension, 3.1.1

account payment method status type logical dimension, 3.1.3

account refund reason logical dimension, 3.1.4

address location logical dimension, 3.1.5

age band logical dimension, 3.1.6

age on net band logical dimension, 3.1.8

aggregate population scripts for intra-ETL, 7.1

aggregate tables

physical data model, 4.6

arpu band logical dimension, 3.1.9

B

bank direct debit channel logical dimension, 3.1.12

base tables

physical data model, 4.4

ber fer type logical dimension, 3.1.13

billing status type logical dimension, 3.1.15

business time logical dimension, 3.1.16

C

calendar population

utility scripts, 11.1

calendar time logical dimension, 3.1.17

call category logical dimension, 3.1.18

call center agent logical dimension, 3.1.19

call center case title logical dimension, 3.1.20

call center logical dimension, 3.1.21

call direction logical dimension, 3.1.22

call other type logical dimension, 3.1.23

call routing type logical dimension, 3.1.24

call service type logical dimension, 3.1.25

call source destination logical dimension, 3.1.26

call success fail type logical dimension, 3.1.27

call type logical dimension, 3.1.28

campaign channel logical dimension, 3.1.30

cell outage reason logical dimension, 3.1.32

collection agency logical dimension, 3.1.36

commission type logical dimension, 3.1.37

compressed tables

physical data model, 4.9

content type logical dimension, 3.1.41

contract change initiator type logical dimension, 3.1.42

contract change reason logical dimension, 3.1.43

cost and contribution sample reports, 12.7

credit category logical dimension, 3.1.45

customer management sample reports, 12.1

customer revenue band logical dimension, 3.1.49

customer segment logical dimension, 3.1.50

D

data mining in Oracle Communication Data Model

models. See data mining models, Oracle Communication Data Model

database sequences

physical data model, 4.8

dealer entity, 2.1.3, 2.1.4, 2.1.5, 2.1.6, 2.1.8, 2.1.9, 2.1.10, 2.1.11, 2.1.12, 2.1.13, 2.1.14, 2.1.15, 2.1.16, 2.1.17, 2.1.18, 2.1.19, 2.1.20, 2.1.21, 2.1.22, 2.1.23, 2.1.24, 2.1.25, 2.1.26, 2.1.27, 2.1.28

dealer logical dimension, 3.1.51

debt age band logical dimension, 3.1.52

derived population scripts for intra-ETL, 7.1

dimensions

Oracle Communications Data Model, 3

direct debit status reason logical dimension, 3.1.53

divert retrieve type logical dimension, 3.1.54

E

employee logical dimension, 3.1.55

entities, Oracle Communications Data Model

logical, 2

entity dictionary, 2.3

event result logical dimension, 3.1.58

event type logical dimension, 3.1.59

F

fraud profile class logical dimension, 3.1.61

G

geography logical dimension, 3.1.62

give away type logical dimension, 3.1.63

GPRS services logical dimension, 3.1.64

H

handset model logical dimension, 3.1.65

I

IN platform logical dimension, 3.1.66

Information Framework (SID), 1.6, C

initiative type logical dimension, 3.1.67

interaction channel logical dimension, 3.1.68

intra-ETL, 7

DWC_OLAP_ETL_PARAMETER table, A.2

source and target mapping, 7.2

Intra-ETL introduction, 7.1

Intra-ETL scripts

aggregate population, 7.1

derived population, 7.1

invoice adjustment reason logical dimension, 3.1.71

invoice adjustment type logical dimension, 3.1.72

L

legal process status type logical dimension, 3.1.76

logical data model, 2.3

business area entities, 2.2

dimensions, 3

reference entities, 2.1

logical data model, Oracle Communications Data Model, 2

logical dimension

access method dimension, 3.1.1

account payment method status type dimension, 3.1.3

account refund reason dimension, 3.1.4

address location dimension, 3.1.5

age band dimension, 3.1.6

age on net band dimension, 3.1.8

arpu band dimension, 3.1.9

bank direct debit channel dimension, 3.1.12

ber fer type dimension, 3.1.13

billing status type dimension, 3.1.15

business time dimension, 3.1.16

calendar time dimension, 3.1.17

call category dimension, 3.1.18

call center agent dimension, 3.1.19

call center case title dimension, 3.1.20

call center dimension, 3.1.21

call direction dimension, 3.1.22

call other type dimension, 3.1.23

call routing type dimension, 3.1.24

call service type dimension, 3.1.25

call source destination dimension, 3.1.26

call success fail type dimension, 3.1.27

call type dimension, 3.1.28

campaign channel dimension, 3.1.30

cell outage reason dimension, 3.1.32

collection agency dimension, 3.1.36

commission type dimension, 3.1.37

content type dimension, 3.1.41

contract change initiator type dimension, 3.1.42

contract change reason dimension, 3.1.43

credit category dimension, 3.1.45

customer revenue band dimension, 3.1.49

customer segment dimension, 3.1.50

dealer dimension, 3.1.51

debt age band dimension, 3.1.52

direct debit status reason dimension, 3.1.53

divert retrieve type dimension, 3.1.54

employee dimension, 3.1.55

event result dimension, 3.1.58

event type dimension, 3.1.59

fraud profile class dimension, 3.1.61

geography dimension, 3.1.62

give away type dimension, 3.1.63

GPRS services dimension, 3.1.64

handset model dimension, 3.1.65

IN platform dimension, 3.1.66

initiative type dimension, 3.1.67

interaction channel dimension, 3.1.68

invoice adjustment reason dimension, 3.1.71

invoice adjustment type dimension, 3.1.72

legal process status type dimension, 3.1.76

loyalty program channel dimension, 3.1.78

market area dimension, 3.1.80

network dimension, 3.1.82

network touchpoint class dimension, 3.1.84

network touchpoint status dimension, 3.1.85

network touchpoint type dimension, 3.1.86

notification type dimension, 3.1.88

NP request type dimension, 3.1.89

organization dimension, 3.1.94

partner settlement reason dimension, 3.1.96

party dimension, 3.1.97

payment channel dimension, 3.1.98

payment method dimension, 3.1.99

payment transaction type dimension, 3.1.100

PCU outage reason dimension, 3.1.101

peak offpeak time dimension, 3.1.102

PPA category dimension, 3.1.103

product dimension, 3.1.104

promotion dimension, 3.1.108

promotion result type dimension, 3.1.109

recharge revenue slab dimension, 3.1.112

redemption type dimension, 3.1.113

RF carrier dimension, 3.1.115

roaming type dimension, 3.1.116

sales channel dimension, 3.1.117

sales channel representative dimension, 3.1.118

service coverage area dimension, 3.1.120

subsidy type dimension, 3.1.123

switch dimension, 3.1.124

technology type dimension, 3.1.125

time slot dimension, 3.1.127

UMS access type dimension, 3.1.128

value added services dimension, 3.1.129

VAS dimension, 3.1.129

logical dimensions, Oracle Communications Data Model, 3

logical entities, Oracle Communications Data Model, 2

logical entity

partner management business area entity, 2.2.5

product management business area entity, 2.2.6

revenue business area entity, 2.2.8

logical to physical mapping

Oracle Communications Data Model, 5

lookup tables

physical data model, 4.3

loyalty program channel logical dimension, 3.1.78

M

market area logical dimension, 3.1.80

marketing sample reports, 12.6

N

network logical dimension, 3.1.82

network sample reports, 12.5

network touchpoint class logical dimension, 3.1.84

network touchpoint status logical dimension, 3.1.85

network touchpoint type logical dimension, 3.1.86

notification type logical dimension, 3.1.88

NP request type logical dimension, 3.1.89

O

OLAP

populating the OLAP module, 8.1.1

OLAP cube

account debt cube, 9.1.1

account payment cube, 9.1.2

ACM, 9.1.8

ACM_FCST, 9.1.16

ACM_FCST_STTSTC, 9.1.17

ADM, 9.1.1

APM, 9.1.2

CCM, 9.1.7

cell statistic cube, 9.1.4

cell statistic forecast cube, 9.1.18

CHRN, 9.1.15

CM, 9.1.3

CMSN, 9.1.5

COM, 9.1.6

commission cube, 9.1.5

contract cube, 9.1.3

cost customer cube, 9.1.7

cost organizational cube, 9.1.6

CSM, 9.1.4

CSM_FCST, 9.1.18

customer acquisition cube, 9.1.8

customer acquisition forecast cube, 9.1.16

customer acquisition forecast statistic cube, 9.1.17

IAM, 9.1.12

ICT, 9.1.13

invoice adjustment cube, 9.1.12

invoice customer type cube, 9.1.13

revenue cube, 9.1.14

revenue forecast cube, 9.1.19

RVN, 9.1.14

RVN_FCST, 9.1.19

subscriber churn statistic cube, 9.1.15

OLAP cube materialized views, 4.10

OLAP cube views

from ocdm_sys schema, 4.10

OLAP dimension

account refund reason, 8.2.1

ARRSN, 8.2.1

bank direct debit channel, 8.2.2

BCYCL, 8.2.3

billing cycle, 8.2.3

CAGNCY, 8.2.5

CCK, 8.2.7

churn reason, 8.2.4

CMTYP, 8.2.6

collection agency, 8.2.5

commission type, 8.2.6

cost center, 8.2.7

CRNCY, 8.2.8

CRNRSN, 8.2.4

CSGMNT, 8.2.10

currency, 8.2.8

CUST, 8.2.9

customer, 8.2.9

customer segment, 8.2.10

customer type, 8.2.11

CUSTYP, 8.2.11

DAB, 8.2.12

debt aging band, 8.2.12

GEO, 8.2.13

geography, 8.2.13

handset model, 8.2.14

HSMDL, 8.2.14

IARSN, 8.2.15

IATYP, 8.2.16

invoice adjustment reason, 8.2.15

invoice adjustment type, 8.2.16

MOBJTYP, 8.2.2

ORG, 8.2.17

organization, 8.2.17

payment channel, 8.2.18

payment method type, 8.2.19

payment transaction type, 8.2.20

PCK, 8.2.18

peak offpeak time, 8.2.21

PMTYP, 8.2.19

POFR, 8.2.23

POPT, 8.2.21

PRMTN, 8.2.24

PROD, 8.2.22

product, 8.2.22

product offer, 8.2.23

promotion, 8.2.24

PTTYP, 8.2.20

resource, 8.2.25

RSCEK, 8.2.25

sales channel, 8.2.26

sales channel representative, 8.2.27

SLCHNL, 8.2.26

SLR, 8.2.27

time, 8.2.29

time day, 8.2.30, 8.2.30

time slot, 8.2.31

TSLT, 8.2.31

OLAP dimensions, 8.2

OLAP model cubes

Oracle Communications Data Model, 9

OLAP model dimensions

Oracle Communications Data Model, 8

Oracle Communications Data Model, 4, 7

components summary, 1.3

intra-ETL, 7

logical data model, 2, 4

logical data model dimensions, 3

logical to physical mapping, 5

OLAP dimensions, 8.2

OLAP model cubes, 9

OLAP model dimensions, 8

physical data model partitioning, 6

sample reports, 12

utility scripts, 11

organization logical dimension, 3.1.94

P

partner management business area entity, 2.2.5

partner management sample reports, 12.8

partner settlement reason logical dimension, 3.1.96

party logical dimension, 3.1.97

payment channel logical dimension, 3.1.98

payment method logical dimension, 3.1.99

payment transaction type logical dimension, 3.1.100

PCU outage reason logical dimension, 3.1.101

peak offpeak time logical dimension, 3.1.102

physical data model, 4

aggregate tables, 4.6

base tables, 4.4

compressed tables, 4.9

database sequences, 4.8

lookup tables, 4.3

OLAP cube materialized views, 4.10

partitioning, 6

reference tables, 4.2

physical data model, Oracle Communications Data Model, 4

physical entities, Oracle Communications Data Model

physical, 4

PPA category logical dimension, 3.1.103

product dimension logical dimension, 3.1.104

product management business area entity, 2.2.6

product management sample reports, 12.3

promotion dimension logical dimension, 3.1.108

promotion result type logical dimension, 3.1.109

provisioning and service sample reports, 12.4

Q

query rewrite for cube materialized views, 8.1.2

R

recharge revenue slab logical dimension, 3.1.112

redemption type logical dimension, 3.1.113

reference tables

physical data model, 4.2

revenue business area entity, 2.2.8

revenue sample reports, 12.2

RF carrier logical dimension, 3.1.115

roaming type logical dimension, 3.1.116

S

sales channel logical dimension, 3.1.117

sales channel representative logical dimension, 3.1.118

sample reports

cost and contribution, 12.7

customer management, 12.1

marketing, 12.6

network, 12.5

Oracle Communications Data Model, 12

partner management, 12.8

product management, 12.3

provisioning and service, 12.4

revenue, 12.2

service coverage area logical dimension, 3.1.120

SID

Information Framework, 1.6, C

source and target mapping for intra-ETL, 7.2

subsidy type logical dimension, 3.1.123

switch logical dimension, 3.1.124

T

technology type logical dimension, 3.1.125

time slot logical dimension, 3.1.127

TM Forum Information Framework, 1.6, C

U

UMS access type logical dimension, 3.1.128

utility scripts

calendar population, 11.1

Oracle Communications Data Model, 11

V

value added services logical dimension, 3.1.129

VAS logical dimension, 3.1.129