Index

A  B  C  D  E  I  L  M  N  O  P  Q  R  S  U 

A

access method logical dimension, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6, 3.1.7, 3.1.8, 3.1.9, 3.1.10, 3.1.11, 3.1.12, 3.1.13, 3.1.14, 3.1.15, 3.1.16, 3.1.17, 3.1.18, 3.1.19, 3.1.20, 3.1.21, 3.1.22, 3.1.23, 3.1.24, 3.1.25, 3.1.26, 3.1.27, 3.2.2, 3.2.3, 3.2.4, 3.2.6, 3.2.7, 3.2.8
aggregate population scripts for intra-ETL, 7.1
aggregate tables
physical data model, 4.6

B

base tables
physical data model, 4.4

C

calendar population
utility scripts, 11.1
CIM, 1.6
CIM Users Group Conformance, 1.6
compressed tables
physical data model, 4.9
cost and contribution sample reports, 12.1, 13.1
customer management sample reports, 12.2

D

data mining in Oracle Utilities Data Model
models. See data mining models, Oracle Utilities Data Model
database sequences
physical data model, 4.8
derived population scripts for intra-ETL, 7.1
dimensions
Oracle Utilities Data Model, 3, 3

E

entities, Oracle Utilities Data Model
logical, 2
entity dictionary, 2.3

I

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

L

logical data model, 2.3
business area entities, 2.2
dimensions, 3, 3
reference entities, 2.1
logical data model, Oracle Utilities Data Model, 2
logical dimension
access method dimension, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6, 3.1.7, 3.1.8, 3.1.9, 3.1.10, 3.1.11, 3.1.12, 3.1.13, 3.1.14, 3.1.15, 3.1.16, 3.1.17, 3.1.18, 3.1.19, 3.1.20, 3.1.21, 3.1.22, 3.1.23, 3.1.24, 3.1.25, 3.1.26, 3.1.27, 3.2.2, 3.2.3, 3.2.4, 3.2.6, 3.2.7, 3.2.8
logical dimensions, Oracle Utilities Data Model, 3, 3
logical entities, Oracle Utilities Data Model, 2
logical to physical mapping
Oracle Utilities Data Model, 5
lookup tables
physical data model, 4.3

M

marketing sample reports, 12.3
metadata management
repository, 14.1.2, 14.2
with Oracle Utilities Data Model, 14.1
metadata repository, 14.1.2
browsing, 14.2
with Oracle Utilities Data Model, 14.2

N

network sample reports, 12.4

O

OLAP
populating the OLAP module, 8.1.1
OLAP cube materialized views, 4.10
OLAP cube views
from oudm_sys schema, 4.10
OLAP dimension
CUST, 8.2.2
customer, 8.2.2
time, 8.2.8
OLAP dimensions, 8.2
OLAP model cubes
Oracle Utilities Data Model, 9
OLAP model dimensions
Oracle Utilities Data Model, 8
Oracle Utilities Data Model, 4, 7
components summary, 1.3
intra-ETL, 7
logical data model, 2, 4
logical data model dimensions, 3, 3
logical to physical mapping, 5
metadata management, 14.1
metadata repository, 14.1.2, 14.2
OLAP dimensions, 8.2
OLAP model cubes, 9
OLAP model dimensions, 8
physical data model partitioning, 6
sample reports, 12, 13
utility scripts, 11

P

partner management sample reports, 12.6
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 Utilities Data Model, 4
physical entities, Oracle Utilities Data Model
physical, 4

Q

query rewrite for cube materialized views, 8.1.2

R

reference tables
physical data model, 4.2
revenue sample reports, 12.5

S

sample reports
cost and contribution, 12.1, 13.1
customer management, 12.2
marketing, 12.3
network, 12.4
Oracle Utilities Data Model, 12, 13
partner management, 12.6
revenue, 12.5
source and target mapping for intra-ETL, 7.2
standards support
CIM, 1.6

U

utility scripts
calendar population, 11.1
Oracle Utilities Data Model, 11