Index

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

Symbols

$$PERIOD

about, 6.3.1.8

configuring, 6.3.1.9

$$WH_DATASOURCE_NUM_ID

about, 6.3.1.8

configuring, 6.3.1.9

$pmserverLkpFiles

location, 7.2.2.1

A

Applications

Oracle Contact Center Telephony Analytics, 4, 8, 9, 11, 12

Oracle Financial Analytics, 5

Oracle HR, 7

Oracle Loyalty Analytics, 13.1

Oracle Marketing Analytics, 12

Oracle Order Management and Fulfillment Analytics, 6

Oracle Price Analytics, 10

Oracle Project Analytics, 15

Oracle Sales Analytics, 8

Oracle Service Analytics, 11

Oracle Supply Chain Analytics, 4, 8, 11, 12

AR Aging calculations

including Unapplied Payments, 5.3.1.1

attributes

historically significant attributes, identifying, 17.9.1

B

Bill of Materials

size restrictions, 6.2.2, 6.3.2.16

BOM data size, 6.2.2, 6.3.2.16

BOM size restrictions, 6.2.2, 6.3.2.16

C

calculations

including Unapplied Payments in AR Aging calculations, 5.3.1.1

calendars

13 period, 3.1.4

4-4-5, 3.1.4

enterprise, 3.1.4

setting up multiple calendars, 3.1.4

setup for PeopleSoft, 5.3.3.5

code lookup

about, 17.11

code mappings, 17.11.2

codes mapplets, 17.11.3

sessions for lookups, configuring, 17.11.4

W_CODES table, 17.11.1

configuration steps

all source systems, 3.1, 7.2.6.1

controlling data set

Oracle Contact Center Telephony Analytics, 9

Oracle Financial Analytics, 5, 5.3

Oracle Human Resources Analytics, 7

Oracle Loyalty Analytics, 13, 13

Oracle Marketing Analytics, 12

Oracle Pharma Analytics, 14

Oracle Price Analytics, 10

Oracle Procurement and Spend Analytics, 4

Oracle Project Analytics, 15.2.5

Oracle Sales Analytics, 8

Oracle Service Analytics, 11

source independent, 3

Supply Chain and Order Management Analytics, 6

Oracle BI Repository, 16

Oracle EBS, 7.2.2

Oracle EBS-specific, 3.2

Oracle HR Analytics

all source systems, 7.2.1

PeopleSoft, 7.2.4

PeopleSoft-specific, 3.3

required before full load

Oracle Contact Center Telephony Analytics, 9

Oracle Financial Analytics, 5

Oracle Human Resources Analytics, 7

Oracle Loyalty Analytics, 13, 13

Oracle Marketing Analytics, 12

Oracle Pharma Analytics, 14

Oracle Price Analytics, 10

Oracle Procurement and Spend Analytics, 4

Oracle Project Analytics, 15.2

Oracle Sales Analytics, 8, 8, 11, 12

Oracle Service Analytics, 11

source independent, 3

Supply Chain and Order Management, 6

conformed dimensions

universal source, configuring for, 17.16

cross-module configuration, performing

codes lookup, 17.11

conformed dimensions, configuring, 17.16

dimension keys, resolving, 17.12

domain values, working with, 17.13

loads, configuring, 17.8

records, filtering and deleting, 17.8.1

slowly changing dimensions, changing, 17.9

stored lookups, configuring, 17.10

Customer Status History Fact table

about, 6.3.1.8

configuring, 6.3.1.9

customization

customizing ETL, 17

examples, 17.3.4

overview, 17.1

types, 17.2.1

D

data import

syndicated data loading, overview, 14.3

data loading

Oracle's Siebel Analytics for Life Sciences, issues when loading, 14.7

Data Source NUM ID

configuring $$WH_DATASOURCE_NUM_ID, 3.1.5.1

DATASOURCE_NUM_ID

about, 3.1.5.1

configuring, 3.1.5.1

dimensions

key resolution, using a lookup, 17.12.1

keys, resolving, 17.12

domain values

domain value conversion process, understanding, 17.13.1

domain value set, configuring, 17.15

domain value set, extending, 17.13.3

importance, understanding, 17.13.2

working with, 17.13

domain values and CSV worksheet files

Oracle EBS, 7.2.2.1

PeopleSoft, 7.2.4.1

E

editing

CSV Worksheet files, 7.2.1.2

ETL

troubleshooting, 8.4.1.1.2

extracts, configuring

extracting additional data, about, 17.7.1

extracting data from new source table, 17.7.1.2

extracting new data from existing source table, 17.7.1.1

F

fiscal calendars

setting up, 3.1.4

setup for PeopleSoft, 5.3.3.5

H

Hierarchies

customizing Product Category Hierarchies, 3.2.1.1.2, 16.6

hierarchies

configuring multiple, 3.2.1.1

historically significant attributes

identifying, 17.9.1

I

Informatica

username and password, 16

installing

Oracle BI repository, setting up, 16.2

L

loading complete data

Oracle HR Analytics

pre-configuration steps, 7.2

loads, configuring

about, 17.8

Source Adapter mapplet. creating, 17.7.3

M

multiple product hierarchies, 3.2.1.1

O

Oracle BI Supply Chain Analytics

domain values and CSV worksheet files, 4.2.2.2

universal source, configuring expenses, 4.3.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.6.1.1

about domain values and CSV worksheet files, 7.2.1.2

overview, 7.1

Oracle Loyalty Analytics

configuration steps before full load, 13.2

overview, 13.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

Oracle Project Analytics

configuration steps before full load, 15.2

overview, 15.1

Oracle's Siebel Life Sciences

data loading issues, 14.7

OracleBIAnalyticsApps.rpd

Informatica username and password, 16

Order Management and Fulfillment Analytics

multiple products, about tracking, 6.3.1.3

overview

job requisition metrics in Oracle EBS, 7.2.6.2.2

P

password

OracleBIAnalyticsApps.rpd, 16

Payroll table, about aggregating, 7.2.6.1.1

PeopleSoft Trees

configuring department trees, 3.3.2.3

performance tuning

PeopleSoft HCM HR Analytics payroll table, 7.2.6.3.1

primary extract and delete mapping

delete and primary extract sessions, enabling, 17.8.3.2

source-archived records, deletion configuration, 17.8.3.1

working with, 17.8.3

Product Category Hierarchies

customizing, 3.2.1.1.2, 16.6

product hierarchies, 3.2.1.1

R

records

source-archived records, deletion configuration, 17.8.3.1

records, filtering and deleting

about, 17.8.1

primary extract and delete mappings, understanding, 17.8.2

primary extract and delete mappings, working with, 17.8.3

repository

Oracle BI repository, setting up, 16.2

repository, setting up, 16.2

responsibilities

in Usage Accelerator, 8.4.1.1.2

S

slowly changing dimensions, configuring

about, 17.9

effective dates, 17.9.2.3

historically significant attributes, identifying, 17.9.1

Type I changing dimension, 17.9.2

Type II slowly changing dimension, 17.9.2.2

Source Adapter mapplet

creating, 17.7.3

source-archived records

deletion configuration, 17.8.3.1

stored lookups

configuring, 17.10

Supply Chain BOM Items

size restrictions, 6.2.2, 6.3.2.16

syndicated data

importing, overview, 14.3

T

troubleshooting

ETL failure, 8.4.1.1.2

U

Unapplied Payments

Using in AR Aging calculations, 5.3.1.1

Universal Adapter

conformed dimensions, configuring, 17.16

Oracle BI Supply Chain Analytics, configuring expenses, 4.3.4.1

UNSPSC codes

assigning to products, 3.2.1.2

Usage Accelerator

ETL failure, 8.4.1.1.2

username

OracleBIAnalyticsApps.rpd, 16