Index

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

Symbols

$$PERIOD

about, 6.2.5.1.8

configuring, 6.2.5.1.9

$$WH_DATASOURCE_NUM_ID

about, 6.2.5.1.8

configuring, 6.2.5.1.9

A

Applications

Oracle Contact Center Telephony Analytics, 4, 8, 9

Oracle Financial Analytics, 5

Oracle HR, 7

Oracle Order Management and Fulfillment Analytics, 6

Oracle Sales Analytics, 8

Oracle Supply Chain Analytics, 4, 8

AR Aging calculations

including UnApplied Payments, 5.2.5.1.1

attributes

historically significant attributes, identifying, 11.8.1

C

calculations

including UnApplied Payments in AR Aging calculations, 5.2.5.1.1

code lookup

about, 11.10

code mappings, 11.10.2

codes mapplets, 11.10.3

sessions for lookups, configuring, 11.10.4

W_CODES table, 11.10.1

configuration steps

all source systems, 3.1

controlling data set

Oracle Contact Center Telephony Analytics, 9

Oracle Financial Analytics, 5, 5.2.5

Oracle Human Resources Analytics, 7

Oracle Procurement and Spend Analytics, 4

Oracle Sales Analytics, 8

source independent, 3

Supply Chain and Order Management Analytics, 6

Oracle BI Repository, 10

Oracle EBS-specific, 3.2

PeopleSoft-specific, 3.3

required before full load

Oracle Contact Center Telephony Analytics, 9

Oracle Financial Analytics, 5

Oracle Human Resources Analytics, 7

Oracle Procurement and Spend Analytics, 4

Oracle Sales Analytics, 8

source independent, 3

Supply Chain and Order Management, 6

conformed dimensions

universal source, configuring for, 11.15

cross-module configuration, performing

codes lookup, 11.10

conformed dimensions, configuring, 11.15

dimension keys, resolving, 11.11

domain values, working with, 11.12

loads, configuring, 11.7

records, filtering and deleting, 11.7.1

slowly changing dimensions, changing, 11.8

stored lookups, configuring, 11.9

Customer Status History Fact table

about, 6.2.5.1.8

configuring, 6.2.5.1.9

D

Data Source NUM ID

configuring $$WH_DATASOURCE_NUM_ID, 3.1.6.1

DATASOURCE_NUM_ID

about, 3.1.6.1

configuring, 3.1.6.1

dimensions

key resolution, using a lookup, 11.11.1

keys, resolving, 11.11

domain values

domain value conversion process, understanding, 11.12.1

domain value set, configuring, 11.14

domain value set, extending, 11.12.3

importance, understanding, 11.12.2

working with, 11.12

E

ETL

troubleshooting, 8.3.1.1.2

Event Types

configuring for PSFT and HR, 7.2.3.21

extracts, configuring

extracting additional data, about, 11.6.1

extracting data from new source table, 11.6.1.2

extracting new data from existing source table, 11.6.1.1

H

historically significant attributes

identifying, 11.8.1

HR Analytics

configuring Event Types for PSFT, 7.2.3.21

I

Informatica

username and password, 10

installing

Oracle BI repository, setting up, 10.2

L

loads, configuring

about, 11.7

Source Adapter mapplet. creating, 11.6.3

O

Oracle BI Supply Chain Analytics

domain values and CSV worksheet files, 4.2.2.2

universal source, configuring expenses, 4.2.5.4.1

Oracle Contact Center Telephony Analytics

Benchmarks and Targets table, setting up, 9.2.10

Contact Representative Snapshot table, setting up, 9.2.9

Contact Status Type columns, about configuring for, 9.2.7

dates and times, configuring, 9.2.12

dimension key resolution, 9.2.1

dimension table, loading, 9.2.2

Event Type columns, about configuring for, 9.2.5

fact table, loading, 9.2.3

overview, 9.1

Representative Activities table, setting up, 9.2.8

Oracle Financial Analytics

configuration steps before full load, 5.2

overview, 5.1

Oracle HR Analytics, 7.2.5.1.1

domain values and CSV worksheet files, 7.2.2.1

overview, 7.1

Oracle Order Management and Fulfillment Analytics

options, 6

overview, 6.1

Oracle Procurement and Spend Analytics

configuration steps before full load, 4.2

overview, 4.1

OracleBIAnalyticsApps.rpd

Informatica username and password, 10

Order Management and Fulfillment Analytics

multiple products, about tracking, 6.2.5.1.3

P

password

OracleBIAnalyticsApps.rpd, 10

Payroll table, about aggregating, 7.2.5.1.1

PeopleSoft Trees

configuring department trees, 7.2.3.22

primary extract and delete mapping

delete and primary extract sessions, enabling, 11.7.3.2

source-archived records, deletion configuration, 11.7.3.1

working with, 11.7.3

R

records

source-archived records, deletion configuration, 11.7.3.1

records, filtering and deleting

about, 11.7.1

primary extract and delete mappings, understanding, 11.7.2

primary extract and delete mappings, working with, 11.7.3

repository

Oracle BI repository, setting up, 10.2

repository, setting up, 10.2

responsibilities

in Usage Accelerator, 8.3.1.1.2

S

slowly changing dimensions, configuring

about, 11.8

effective dates, 11.8.2.3

historically significant attributes, identifying, 11.8.1

Type I changing dimension, 11.8.2

Type II slowly changing dimension, 11.8.2.2

Source Adapter mapplet

creating, 11.6.3

source-archived records

deletion configuration, 11.7.3.1

stored lookups

configuring, 11.9

T

troubleshooting

ETL failure, 8.3.1.1.2

U

UnApplied Payments

Using in AR Aging calculations, 5.2.5.1.1

Universal Adapter

conformed dimensions, configuring, 11.15

Oracle BI Supply Chain Analytics, configuring expenses, 4.2.5.4.1

Usage Accelerator

ETL failure, 8.3.1.1.2

username

OracleBIAnalyticsApps.rpd, 10