Index

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

A

access method logical dimension, 3.1.1

account logical dimension, 3.1.2

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.7

aggregate population scripts for intra-ETL, 7.1

aggregate tables

physical data model, 4.6

application adapters

for Oracle Communications Data Model, 13, 14

arpu band logical dimension, 3.1.8

B

bank direct debit channel logical dimension, 3.1.9

base tables

physical data model, 4.4

ber fer type logical dimension, 3.1.10

Billing and Revenue Management Adapter

Oracle Communications Data Model, 14

billing cycle logical dimension, 3.1.11

billing status type logical dimension, 3.1.12

BRM Adapter, 14

business time logical dimension, 3.1.13

C

calendar population

utility scripts, 11.1

calendar time logical dimension, 3.1.14

call category logical dimension, 3.1.15

call center agent logical dimension, 3.1.16

call center case title logical dimension, 3.1.17

call center logical dimension, 3.1.18

call direction logical dimension, 3.1.19

call other type logical dimension, 3.1.20

call routing type logical dimension, 3.1.21

call service type logical dimension, 3.1.22

call source destination logical dimension, 3.1.23

call success fail type logical dimension, 3.1.24

call type logical dimension, 3.1.25

campaign channel logical dimension, 3.1.26

campaign logical dimension, 3.1.27

cell outage reason logical dimension, 3.1.28

change proposed by type logical dimension, 3.1.29

collection agency logical dimension, 3.1.30

commission type logical dimension, 3.1.31

compressed tables

physical data model, 4.9

conformance certification

Information Framework, 1.6

content type logical dimension, 3.1.32

contract change initiator type logical dimension, 3.1.33

contract change reason logical dimension, 3.1.34

contract logical dimension, 3.1.35

cost and contribution sample reports, 12.1

credit category logical dimension, 3.1.36

customer management sample reports, 12.2

customer revenue band logical dimension, 3.1.37

customer segment logical dimension, 3.1.38

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

dealer logical dimension, 3.1.39

debt age band logical dimension, 3.1.40

derived population scripts for intra-ETL, 7.1

derived tables

physical data model, 4.5

dimensions

Oracle Communications Data Model, 3

direct debit status reason logical dimension, 3.1.41

divert retrieve type logical dimension, 3.1.42

E

employee logical dimension, 3.1.43

entities, Oracle Communications Data Model

logical, 2

entity dictionary, 2.3

event result logical dimension, 3.1.44

event type logical dimension, 3.1.45

external operator logical dimension, 3.1.46

F

fraud profile class logical dimension, 3.1.47

G

geography logical dimension, 3.1.48

give away type logical dimension, 3.1.49

GPRS services logical dimension, 3.1.50

H

handset model logical dimension, 3.1.51

I

IN platform logical dimension, 3.1.52

Information Framework (SID), 1.6

initiative type logical dimension, 3.1.53

interaction channel logical dimension, 3.1.54

internet service provider logical dimension, 3.1.55

intra-ETL, 7

DWC_OLAP_ETL_PARAMETER table, A.2

execution of workflow, 7.1

mapping and value lookup, 7.2

PL/SQL mapping, 7.4

process flows, 7.5

source and target mapping, 7.3

Intra-ETL introduction, 7.1

Intra-ETL scripts

aggregate population, 7.1

derived population, 7.1

invoice adjustment reason logical dimension, 3.1.56

invoice adjustment type logical dimension, 3.1.57

item logical dimension, 3.1.58

L

legal process status type logical dimension, 3.1.59

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 dimension, 3.1.2

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.7

arpu band dimension, 3.1.8

bank direct debit channel dimension, 3.1.9

ber fer type dimension, 3.1.10

billing cycle dimension, 3.1.11

billing status type dimension, 3.1.12

business time dimension, 3.1.13

calendar time dimension, 3.1.14

call category dimension, 3.1.15

call center agent dimension, 3.1.16

call center case title dimension, 3.1.17

call center dimension, 3.1.18

call direction dimension, 3.1.19

call other type dimension, 3.1.20

call routing type dimension, 3.1.21

call service type dimension, 3.1.22

call source destination dimension, 3.1.23

call success fail type dimension, 3.1.24

call type dimension, 3.1.25

campaign channel dimension, 3.1.26

campaign dimension, 3.1.27

cell outage reason dimension, 3.1.28

change proposed by type dimension, 3.1.29

collection agency dimension, 3.1.30

commission type dimension, 3.1.31

content type dimension, 3.1.32

contract change initiator type dimension, 3.1.33

contract change reason dimension, 3.1.34

contract dimension, 3.1.35

credit category dimension, 3.1.36

customer revenue band dimension, 3.1.37

customer segment dimension, 3.1.38

dealer dimension, 3.1.39

debt age band dimension, 3.1.40

direct debit status reason dimension, 3.1.41

divert retrieve type dimension, 3.1.42

employee dimension, 3.1.43

event result dimension, 3.1.44

event type dimension, 3.1.45

external operator dimension, 3.1.46

fraud profile class dimension, 3.1.47

geography dimension, 3.1.48

give away type dimension, 3.1.49

GPRS services dimension, 3.1.50

handset model dimension, 3.1.51

IN platform dimension, 3.1.52

initiative type dimension, 3.1.53

interaction channel dimension, 3.1.54

internet service provider dimension, 3.1.55

invoice adjustment reason dimension, 3.1.56

invoice adjustment type dimension, 3.1.57

item dimension, 3.1.58

legal process status type dimension, 3.1.59

loyalty program channel dimension, 3.1.60

market area dimension, 3.1.61

network dimension, 3.1.62

network element dimension, 3.1.63

network touchpoint class dimension, 3.1.64

network touchpoint status dimension, 3.1.65

network touchpoint type dimension, 3.1.66

notification type dimension, 3.1.67

NP request type dimension, 3.1.68

on off net dimension, 3.1.69

organization dimension, 3.1.70

partner settlement reason dimension, 3.1.71

party dimension, 3.1.72

payment channel dimension, 3.1.73

payment method dimension, 3.1.74

payment transaction type dimension, 3.1.75

PCU outage reason dimension, 3.1.76

peak offpeak time dimension, 3.1.77

PPA category dimension, 3.1.78

product dimension, 3.1.79, 3.1.80

promotion dimension, 3.1.81

promotion result type dimension, 3.1.82

recharge revenue slab dimension, 3.1.83

redemption type dimension, 3.1.84

RF carrier dimension, 3.1.85

roaming type dimension, 3.1.86

sales channel dimension, 3.1.87

sales channel representative dimension, 3.1.88

service coverage area dimension, 3.1.89

subscription dimension, 3.1.90

subsidy type dimension, 3.1.91

switch dimension, 3.1.92

technology type dimension, 3.1.93

time slot dimension, 3.1.94

UMS access type dimension, 3.1.95

value added services dimension, 3.1.96

VAS dimension, 3.1.96

logical dimensions, Oracle Communications Data Model, 3

logical entities, Oracle Communications Data Model, 2

logical entity

dealer entity, 2.1.3

partner management business area entity, 2.2.5

product instance entity, 2.1.9

product management business area entity, 2.2.6

revenue business area entity, 2.2.8

service entity, 2.1.10

subscription entity, 2.1.11

wireless network entity, 2.1.14

logical to physical mapping

Oracle Communications Data Model, 5

lookup tables

physical data model, 4.3

loyalty program channel logical dimension, 3.1.60

M

market area logical dimension, 3.1.61

marketing sample reports, 12.3

N

NCC Adapter, 13

Network Charging and Control Adapter

Oracle Communications Data Model, 13

network element logical dimension, 3.1.63

network logical dimension, 3.1.62

network sample reports, 12.4

network touchpoint class logical dimension, 3.1.64

network touchpoint status logical dimension, 3.1.65

network touchpoint type logical dimension, 3.1.66

notification type logical dimension, 3.1.67

NP request type logical dimension, 3.1.68

O

OLAP

populating the OLAP module, 8.1.1

OLAP cube

account debt cube, 9.1.1

account payment cube, 9.1.2

account refund cube, 9.1.3

ACM, 9.1.9

ACM_FCST, 9.1.16

ACM_FCST_STTSTC, 9.1.17

ADM, 9.1.1

APM, 9.1.2

ARM, 9.1.3

CCM, 9.1.8

cell statistic cube, 9.1.4

cell statistic forecast cube, 9.1.18

CHRN, 9.1.15

CM, 9.1.6

CMSN, 9.1.5

COM, 9.1.7

commission cube, 9.1.5

contract cube, 9.1.6

cost customer cube, 9.1.8

cost organizational cube, 9.1.7

CSM, 9.1.4

CSM_FCST, 9.1.18

customer acquisition cube, 9.1.9

customer acquisition forecast cube, 9.1.16

customer acquisition forecast statistic cube, 9.1.17

EDCM, 9.1.10

external debt collection cube, 9.1.10

handset stock cube, 9.1.11

handset stock forecast cube, 9.1.19

HSKM, 9.1.11

HSKM_FCST, 9.1.19

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.20

RVN, 9.1.14

RVN_FCST, 9.1.20

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

CAGNCY, 8.2.3

churn reason, 8.2.2

CMTYP, 8.2.4

collection agency, 8.2.3

commission type, 8.2.4

CRNRSN, 8.2.2

CSGMNT, 8.2.6

CUST, 8.2.5

customer, 8.2.5

customer segment, 8.2.6

customer type, 8.2.7

CUSTYP, 8.2.7

DAB, 8.2.8

debt aging band, 8.2.8

GEO, 8.2.9

geography, 8.2.9

handset model, 8.2.10

HSMDL, 8.2.10

IARSN, 8.2.11

IATYP, 8.2.12

invoice adjustment reason, 8.2.11

invoice adjustment type, 8.2.12

mining churn type, 8.2.13

mining life time survival band, 8.2.14

mining life time value band, 8.2.15

mining sentiment category, 8.2.16

MNCT, 8.2.13

MNLSB, 8.2.14

MNLVB, 8.2.15

MNSC, 8.2.16

NELMNT, 8.2.17

network element, 8.2.17

ORG, 8.2.18

organization, 8.2.18

payment channel, 8.2.19

payment method type, 8.2.20

payment transaction type, 8.2.21

PCHNL, 8.2.19

peak offpeak time, 8.2.22

PMP, 8.2.24

PMTYP, 8.2.20

POPT, 8.2.22

PRMTN, 8.2.25

PROD, 8.2.23

product, 8.2.23

product market plan, 8.2.24

promotion, 8.2.25

PTTYP, 8.2.21

sales channel, 8.2.26

SLCHNL, 8.2.26

time, 8.2.27

time slot, 8.2.28

TSLT, 8.2.28

OLAP dimensions, 8.2

OLAP model cubes

Oracle Communications Data Model, 9

OLAP model dimensions

Oracle Communications Data Model, 8

on off net logical dimension, 3.1.69

Oracle Communications Data Model, 4, 7

Billing and Revenue Management Adapter, 14

components summary, 1.3

intra-ETL, 7

logical data model, 2, 4

logical data model dimensions, 3

logical to physical mapping, 5

Network Charging and Control Adapter, 13

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.70

P

partner management business area entity, 2.2.5

partner management sample reports, 12.5

partner settlement reason logical dimension, 3.1.71

party logical dimension, 3.1.72

payment channel logical dimension, 3.1.73

payment method logical dimension, 3.1.74

payment transaction type logical dimension, 3.1.75

PCU outage reason logical dimension, 3.1.76

peak offpeak time logical dimension, 3.1.77

physical data model, 4

aggregate tables, 4.6

base tables, 4.4

compressed tables, 4.9

database sequences, 4.8

derived tables, 4.5

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

PL/SQL mapping for intra-ETL, 7.4

PPA category logical dimension, 3.1.78

process flows

intra-ETL, 7.5

product dimension logical dimension, 3.1.79, 3.1.80

product instance entity, 2.1.9

product management business area entity, 2.2.6

product management sample reports, 12.6

promotion dimension logical dimension, 3.1.81

promotion result type logical dimension, 3.1.82

provisioning and service sample reports, 12.7

Q

query rewrite for cube materialized views, 8.1.2

R

recharge revenue slab logical dimension, 3.1.83

redemption type logical dimension, 3.1.84

reference tables

physical data model, 4.2

revenue business area entity, 2.2.8

revenue sample reports, 12.8

RF carrier logical dimension, 3.1.85

roaming type logical dimension, 3.1.86

S

sales channel logical dimension, 3.1.87

sales channel representative logical dimension, 3.1.88

sample reports

cost and contribution, 12.1

customer management, 12.2

marketing, 12.3

network, 12.4

Oracle Communications Data Model, 12

partner management, 12.5

product management, 12.6

provisioning and service, 12.7

revenue, 12.8

service coverage area logical dimension, 3.1.89

service entity, 2.1.10

SID

conformance certification, 1.6

Information Framework, 1.6

source and target mapping for intra-ETL, 7.3

standards support

TM Forum SID, 1.6

subscription entity, 2.1.11

subscription logical dimension, 3.1.90

subsidy type logical dimension, 3.1.91

switch logical dimension, 3.1.92

T

technology type logical dimension, 3.1.93

time slot logical dimension, 3.1.94

TM Forum Information Framework, 1.6

U

UMS access type logical dimension, 3.1.95

utility scripts

calendar population, 11.1

Oracle Communications Data Model, 11

V

value added services logical dimension, 3.1.96

value lookup

for intra-ETL mapping, 7.2

VAS logical dimension, 3.1.96

W

wireless network entity, 2.1.14