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 Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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
account simple entity, 2.1.1
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
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 cycle logical dimension, 3.1.11
billing status type logical dimension, 3.1.12
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.8
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
cost business area entity, 2.2.1
credit category logical dimension, 3.1.36
customer entity, 2.1.2
customer management business area entity, 2.2.2
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.7
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 entity, 2.1.4
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
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
promotion dimension, 3.1.80
promotion result type dimension, 3.1.81
recharge revenue slab dimension, 3.1.82
redemption type dimension, 3.1.83
RF carrier dimension, 3.1.84
roaming type dimension, 3.1.85
sales channel dimension, 3.1.86
sales channel representative dimension, 3.1.87
service coverage area dimension, 3.1.88
subscription dimension, 3.1.89
subsidy type dimension, 3.1.90
switch dimension, 3.1.91
technology type dimension, 3.1.92
time slot dimension, 3.1.93
UMS access type dimension, 3.1.94
value added services dimension, 3.1.95
VAS dimension, 3.1.95
logical dimensions, Oracle Communications Data Model, 3
logical entities, Oracle Communications Data Model, 2
logical entity, 2.1.7
account simple entity, 2.1.1
cost business area entity, 2.2.1
customer entity, 2.1.2
customer management business area entity, 2.2.2
dealer entity, 2.1.3
geography entity, 2.1.4
marketing business area entity, 2.2.3
network business area entity, 2.2.4
organization business unit entity, 2.1.5
partner management business area entity, 2.2.5
party entity, 2.1.6
product entity, 2.1.8
product instance entity, 2.1.9
product management business area entity, 2.2.6
provisioning and service business area entity, 2.2.7
revenue business area entity, 2.2.8
service entity, 2.1.10
subscription entity, 2.1.11
time calendar entity, 2.1.12
vendor entity, 2.1.13
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 business area entity, 2.2.3
marketing sample reports, 12.3
metadata population
utility scripts, 11.2

N

network business area entity, 2.2.4
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.17
ACM_FCST_STTSTC, 9.1.18
ADM, 9.1.1
APM, 9.1.2
ARM, 9.1.3
CCM, 9.1.7
cell statistic cube, 9.1.4
cell statistic forecast cube, 9.1.19
CHRN, 9.1.16
CM, 9.1.6
CMSN, 9.1.5
COM, 9.1.8
commission cube, 9.1.5
contract cube, 9.1.6
cost customer cube, 9.1.7
cost organizational cube, 9.1.8
CSM, 9.1.4
CSM_FCST, 9.1.19
CUST_MNNG_STTSTC, 9.1.10
customer acquisition cube, 9.1.9
customer acquisition forecast cube, 9.1.17
customer acquisition forecast statistic cube, 9.1.18
customer mining statistics cube, 9.1.10
EDCM, 9.1.11
external debt collection cube, 9.1.11
handset stock cube, 9.1.12
handset stock forecast cube, 9.1.20
HSKM, 9.1.12
HSKM_FCST, 9.1.20
IAM, 9.1.13
ICT, 9.1.14
invoice adjustment cube, 9.1.13
invoice customer type cube, 9.1.14
revenue cube, 9.1.15
revenue forecast cube, 9.1.21
RVN, 9.1.15
RVN_FCST, 9.1.21
subscriber churn statistic cube, 9.1.16
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
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 business unit entity, 2.1.5
organization logical dimension, 3.1.70

P

partition definitions
physical data model, 4.9
partner management business area entity, 2.2.5
partner management sample reports, 12.5
partner settlement reason logical dimension, 3.1.71
party entity, 2.1.6
party logical dimension, 3.1.72
party subject area entity, 2.1.7, 2.1.7
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.8
database sequences, 4.7
derived tables, 4.5
lookup tables, 4.3
OLAP cube materialized views, 4.10
partition definitions, 4.9
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
product entity, 2.1.8
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.80
promotion result type logical dimension, 3.1.81
provisioning and service business area entity, 2.2.7
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.82
redemption type logical dimension, 3.1.83
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.84
roaming type logical dimension, 3.1.85

S

sales channel logical dimension, 3.1.86
sales channel representative logical dimension, 3.1.87
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.88
service entity, 2.1.10
source and target mapping for intra-ETL, 7.3
subscription entity, 2.1.11
subscription logical dimension, 3.1.89
subsidy type logical dimension, 3.1.90
switch logical dimension, 3.1.91

T

technology type logical dimension, 3.1.92
time calendar entity, 2.1.12
time slot logical dimension, 3.1.93

U

UMS access type logical dimension, 3.1.94
utility scripts
calendar population, 11.1
metadata population, 11.2
Oracle Communications Data Model, 11

V

value added services logical dimension, 3.1.95
value lookup
for intra-ETL mapping, 7.2
VAS logical dimension, 3.1.95
vendor entity, 2.1.13

W

wireless network entity, 2.1.14