Index

A C D E F H I J K L M N O P Q R S T

A

access layer, 2.1

customizing, 3, 3.1

Oracle Retail Data Model, 2.1, 3

As Is reports, 5.6.1

As Was reports, 5.6.1

C

compression

in Oracle Retail Data Model, 2.4.2, 2.4.2.1, 2.4.2.1.1

materialized views, 3.4.4

configuring Oracle Retail Data Model warehouse, A.2

conventions

when customizing physical model, 2.2.2

cubes

adding materialized view capabilities to, 3.3.3.2

changing the dimensions of, 3.3.6

changing the measures of, 3.3.6

customizing, 3.3.4

data maintenance methods, 3.3.9

forecast, 3.3.7

in Oracle Retail Data Model, 3.3.4, 3.3.5

partitioning, 3.3.8

customizing

access layer, 3

cubes, 3.3.4

Oracle Retail Data Model, 1.2

physical data model, 2

D

dashboards, Oracle Retail Data Model, 5.2, 5.7

data governance committee, responsibilities of, 1.3.2

data mining models

customizing, 3.2.2

derived tables

in Oracle Retail Data Model, 3.2

dimensional components, Oracle Retail Data Model, 3.3

E

error handling

during intra-ETL execution, 4.6

ETL for Oracle Retail Data Model, 4.1

F

fit-gap analysis for Oracle Retail Data Model, 1.5

forecast cube in Oracle Retail Data Model, 3.3.7

foundation layer

defined, 2.1

Oracle Retail Data Model, 2.1

foundation layer of Oracle Retail Data Model

common change scenarios, 2.3.1

H

HCC, 2.4.2.1.3

hybrid columnar compression

and Oracle Retail Data Model, 2.4.2.1.3

I

implementers of Oracle Retail Data Model

prerequisite knowledge, 1.3.1

implementing

Oracle Retail Data Model, 1.2

indexes

in Oracle Retail Data Model, 2.4.5

materialized views, 3.4.2

partitioning, 2.4.5

integrity constraints

in Oracle Retail Data Model, 2.4.4

intra-ETL

managing errors, 4.6

monitoring execution of, 4.6.1

Oracle Retail Data Model, 4.1

recovery, 4.6.2

troubleshooting, 4.6.3

intra-ETL, Oracle Retail Data Model

executing, 4.4.1.2.1

J

join performance, improving, 2.4.6.3

K

keys, surrogate

in Oracle Retail Data Model, 2.4.3

L

loading Oracle Retail Data Model data, 4.4

M

materialized views, 3.4.1

compressing, 3.4.4

in Oracle Retail Data Model, 3.4

indexing, 3.4.2

partition change tracking, 3.4.3

partitioning, 3.4.3

refresh options

refreshing, 3.4.1

Metadata Dependency Manager

with Oracle Retail Data Model, 1.4.5

metadata management

repository, 1.4.2, 1.4.3, 6.2

with Oracle Retail Data Model, 1.4

metadata repository, 1.4.2

browsing, 1.4.3, 6.2

with Oracle Retail Data Model, 1.4.3, 6.2

N

naming conventions

for physical model of Oracle Retail Data Model, 2.2.2

O

Oracle data mining models

Oracle Retail Data Model, 3.2.2.1

Oracle Retail Data Model

access layer, 2.1, 3

components of, 1.1.1

customizing, 1.2

customizing physical model, 2.1, 2.2, 2.2.1, 2.2.2, 2.4

dashboards, 5.2

data governance, 1.3.2

described, 1.1

dimensional components, 3.3

ETL, 4.1

fit-gap analysis, 1.5

foundation layer, 2.1

implementing, 1.2

intra-ETL, 4.1

loading, 4.4

Metadata Dependency Manager, 1.4.5

metadata management, 1.4

metadata repository, 1.4.2, 1.4.3, 6.2

Oracle products used by, 1.1.2

Oracle Warehouse Builder, using with, 1.4.5

physical layers of, 2.1

pre-implementation tasks, 1.3

querying, 5.3

refreshing data, 4.5

reporting, 5.1, 5.3

sample reports, 5.2

source-ETL, 4.1, 4.2, 4.2.2, 4.2.3, 4.2.4, 4.2.5

staging layer, 2.1

tablespaces, design recommendations, 2.4.1

Oracle Retail Data Model implementers

prerequisite knowledge for, 1.3.1

Oracle Retail Data Model warehouse

configuring, A.2

sizing, A.1

Oracle Warehouse Builder

with Oracle Retail Data Model, 1.4.5

P

parallel execution

enabling for a session, 2.4.7.1

enabling for DML operations, 2.4.7.2

in Oracle Retail Data Model, 2.4.7

partition change tracking, 3.4.3

partition exchange load, 4.2.7.5

partitioned indexes in Oracle Retail Data Model, 2.4.5

partitioning

cubes, 3.3.8

for join performance, 2.4.6.3

for manageability, 2.4.6.1

for source-ETL, 4.2.7.5

indexes, 2.4.5

materialized views, 3.4.3

tables, 2.4.6

partitions, changing, 2.4.1

physical model of Oracle Retail Data Model

characteristics of, 2.1, 2.2, 2.2.1

customizing, 2.2.2

general recommendations for, 2.4

Q

querying Oracle Retail Data Model, 5.3

R

refreshing

Oracle Retail Data Warehouse, 4.5

reporting

Oracle Retail Data Model, 5.1, 5.3

reports

approaches to, 5.1

As Is, 5.6.1

As Was, 5.6.1

troubleshooting performance, 5.5

reports, Oracle Retail Data Model

creating new, 5.8

S

sample reports

customizing, 5.2

sizing

Oracle Retail Data Model warehouse, A.1

source-ETL

exception handling, 4.2.6

jobs control, 4.2.5

loading considerations, 4.2.7

Oracle Retail Data Model, 4.1, 4.2, 4.2.2, 4.2.3, 4.2.4, 4.2.5, 4.2.7

parallel direct path load, 4.2.7.4

partitioning for, 4.2.7.5

workflow, 4.2.5

staging layer, 2.1

Oracle Retail Data Model, 2.1

star queries, optimizing, 5.4

surrogate keys

in Oracle Retail Data Model, 2.4.3

T

tables

compressing, 2.4.2, 2.4.2.1, 2.4.2.1.1

derived, 3.2

partitioning, 2.4.6

tablespace in Oracle Retail Data Model, 2.4.1