Skip Headers

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

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 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
  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.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
    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
    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
  metadata population
    utility scripts, 11.2

## N

  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.11
  OLAP cube views
    from ocdm_sys schema, 4.11
  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.4
    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.70

## P

  partition definitions
    physical data model, 4.10
  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.11
    partition definitions, 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
  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 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
  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.89
  subsidy type logical dimension, 3.1.90
  switch logical dimension, 3.1.91

## T

  technology type logical dimension, 3.1.92
  time slot logical dimension, 3.1.93
  TM Forum Information Framework, 1.6

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

## W

  wireless network entity, 2.1.14