Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.2

E28440-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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