Index

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

A

aggregate entities, Oracle Retail Data Model, 2.1.5

aggregate population scripts for intra-ETL, 6.1

aggregate tables, Oracle Retail Data Model, 3.6

B

base entities

Oracle Retail Data Model, 2.1.3

base tables, Oracle Retail Data Model, 3.4

business areas, 2.2

C

calendar population

utility scripts, 11.1

control and configuration tables, Oracle Retail Data Model, 3.7

control tables, A

D

data mining in Oracle Retail Data Model, 10

database sequences, Oracle Retail Data Model, 3.9

derived entities, Oracle Retail Data Model, 2.1.4

derived population scripts for intra-ETL, 6.1

derived tables, Oracle Retail Data Model, 3.5, 6.2

E

entities, Oracle Retail Data Model

aggregate, 2.1.5

base, 2.1.3

derived, 2.1.4

logical, 2

lookup, 2.1.2

mapping to tables, 4

entity dictionary, 2.4, 2.4

ETL, Oracle Retail Data Model

intra-ETL, 6.1

intra-ETL scripts, 6.2, 6.3

introduction to, 6.1

source-ETL, 6.1

I

intra-ETL

DWC_OLAP_ETL_PARAMETER table, A.2

execution of workflow, 6.1, 6.6

Intra-ETL scripts

aggregate population, 6.1

derived population, 6.1

intra-ETL, Oracle Retail Data Model

scripts, 6.2

L

logical data model, 2.4

business areas, 2.2

subject areas, 2.2

logical data model, Oracle Retail Data Model, 2

logical entities, Oracle Retail Data Model, 2

logical to physical mapping, Oracle Retail Data Model, 4

lookup entities, Oracle Retail Data Model, 2.1.2

lookup tables, Oracle Retail Data Model, 3.3

M

mappings, Oracle Retail Data Model

logical to physical, 4

materialized views, Oracle Retail Data Model

intra-ETL scripts, 6.3

metadata tables, Oracle Retail Data Model, 3.8

O

OLAP model cubes

Oracle Retail Data Model, 9

OLAP model dimensions

Oracle Retail Data Model, 8

Oracle Retail Data Model

about, 1.1

logical data model, 2

OLAP model cubes, 9

OLAP model dimensions, 8

physical data model, 3.1

physical data model partitioning, 5

reports, 12, 13

utility scripts, 11

ORDM_INTRA_ETL_FLW

process flow, 6.1, 6.6, 6.6

ordm_sys schema, 3.1

P

physical data model

partitioning, 5

physical data model, Oracle Retail Data Model, 3.1

PKG_INTRA_ETL_PROCESS package, 6.2.27, A.1

PKG_INTRA_ETL_UTL package, 6.2.28

PL/SQL packages

PKG_INTRA_ETL_PROCESS, 6.2.27, A.1

PKG_INTRA_ETL_UTIL, 6.2.28

process flow

ORDM_INTRA_ETL_FLW, 6.1, 6.6, 6.6

R

reference entities

Oracle Retail Data Model, 2.1.1

reference tables.

tables

Oracle Retail Data Model, 3.2

reports, 12, 13

S

schemas, Oracle Retail Data Model, 3.1

subject areas, 2.2

T

tables, Oracle Retail Data Model

aggregate, 3.6

base, 3.4

control and configuration, 3.7

database sequences, 3.9

derived, 3.5, 6.2

lookup, 3.3

mapped from logical entities, 4

metadata, 3.8

reference, 3.2

U

utility scripts

calendar population, 11.1

Oracle Retail Data Model, 11