Index

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

Symbols

$$JDE_RATE_TYPE (JD Edwards), about configuring, 3.5.1.6

$$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

Activity Category, how to configure (Oracle Service Analytics), 11.3.1.7

Activity Priority, how to configure (Oracle Service Analytics), 11.3.1.6

Activity Resolution, how to configure (Oracle Service Analytics), 11.3.1.9

Activity Type, how to configure (Oracle Service Analytics), 11.3.1.8

Address Types for Employee Dimension, how to configure (Oracle HR), 7.2.2.23

Adoption Metrics, about (Sales Analytics), 8.4.2.3.2

Age Band Dimension, how to configure (Oracle HR), 7.2.1.1.2

aging buckets, how to configure (Financial Analytics), 5.3.1.2

Agreement Status, how to configure (Oracle Service Analytics), 11.2.2.4, 11.3.1.4

Alternate Load Plan, how to configure (Contact Center Analytics), 9.2.16

AP Balance ID, how to configure (Financial Analytics), 5.3.2.4

AP invoices, how to configure (Procurement and Spend), 4.2.2.3

AP/AR Aging Tables, how to configure (Financial Analytics), 5.3.1.2

Applications

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

Oracle Financial Analytics, 5

Oracle HR Analytics, 7

Oracle Loyalty Analytics, 13.1, 13.1

Oracle Marketing Analytics, 12, 12, 12.1

Oracle Pharma Analytics, 14

Oracle Price Analytics, 10, 10.1, 10.2, 11.2

Oracle Procurement and Spend Analytics, 4

Oracle Project Analytics, 15

Oracle Project Analytics, configuration steps before a full load, 15.2

Oracle Project Analytics, overview, 15.1

Oracle Sales Analytics, 8, 8

Oracle Service Analytics, 11, 11, 11.1

Oracle Spend Classification, 4.2.1.1

Oracle Supply Chain and Order Management Analytics, 6

AR Adjustments Extract, how to configure (Financial Analytics), 5.3.2.6

AR Aging Calculations

how to configure (Financial Analytics), 5.3.1.1

including Unapplied Payments (Financial Analytics), 5.3.1.1

AR Balance ID, how to configure (Financial Analytics), 5.3.2.5

AR Cash Receipt Application Extract, how to configure (Financial Analytics), 5.3.2.8

AR Credit-Memo Application Extract, how to configure (Financial Analytics), 5.3.2.9

AR Schedules Extract, how to configure (Financial Analytics), 5.3.2.7

Asset Cost Category, how to configure (Oracle Service Analytics), 11.2.2.10

Asset Status, how to configure (Oracle Service Analytics), 11.2.2.3, 11.3.1.3

Attribute Changes in Bookings, tracking (Supply Chain and OM), 6.3.1.1

attributes

historically significant attributes, identifying, 17.9.1

B

Backlog

calculations, adding closed orders (Supply Chain and OM), 6.3.2.13

calculations, how to configure (Supply Chain and OM), 6.3.2.12

History Table, example (Supply Chain and OM), 6.3.1.6

Period Date, how to configure (Supply Chain and OM), 6.3.1.5

Band Dimensions

how to configure (Oracle HR), 7.2.1.1

overview (Oracle HR), 7.2.1.1.1

beginning GL Balances (Financial Analytics), how to configure, 5.2.3.3

Bill Of Materials

data size, 6.2.2, 6.3.2.14

explosion, how to configure (Supply Chain and OM), 6.3.2.14

how to deploy objects in Oracle EBS, 6.2.2.12

how to explode, 6.2.2.12, 6.2.2.12

size restrictions, 6.2.2, 6.2.2, 6.3.2.14, 6.3.2.14

Budget Fact Canonical Date, how to configure (Oracle Project Analytics), 15.2.2.22

Budget Fact for PeopleSoft, how to configure (Oracle Project Analytics), 15.3.2.1

Budget Fact, how to configure (Oracle Project Analytics), 15.2.2.22

Budgets Created in Forms Client, how to configure (Oracle Project Analytics), 15.2.2.22

Budgets for Oracle Profitability Analytics, how to configure (Financial Analytics), 5.3.1.6

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

enabling initialization blocks, 3.1.4.1.1, 5.2.1

enterprise, 3.1.4

how to configure, 3.1.4

setting up multiple calendars, 3.1.4

setup for PeopleSoft, 5.3.3.4

Category Codes (JD Edwards), how to configure, 3.5.1.1

Changing Dimension Behavior, how to configure (Contact Center Analytics), 9.2.18.2

Chart of Accounts, example data configuration, 3.2.1.6.1

Chartfields (PeopleSoft), about, 3.3.1.1

Classification Names for Payroll, how to configure (Oracle HR), 7.2.2.27

Code Dimension (JD Edwards), how to configure, 3.5.1.2

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

Collect FTE, Collect Performance Ratings, and Load User Flex Data, how to configure (Oracle HR), 7.2.3.5

Commitment Control Budget, 5.2.3.4.1

Compensation Flag and Pension Compensation Flag, how to configure (Oracle HR), 7.2.4.18

Completeness Metrics, about (Sales Analytics), 8.4.2.3.4

configuration steps

all source systems, 3.1, 7.3.1

Common Areas and Dimensions, 3

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.3, 15.3

Oracle Sales Analytics, 8

Oracle Service Analytics, 11

Oracle Supply Chain and Order Management Analytics, 6

source independent, 3

mandatory for Oracle Order Management and Fulfillment Analytics, 6.2.1

optional for Oracle HR Analytics, 7.3

optional for Oracle Order Management and Fulfillment Analytics, 6.3

Oracle BI Repository, 16

Oracle EBS, 7.2.2

Oracle EBS-specific, 3.2

Oracle HR Analytics, all source systems, 7.2.1

Oracle Spend Classification, 4.2.1.1

overview, 2

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, 15.2

Oracle Sales Analytics, 8, 8, 11, 12

Oracle Service Analytics, 11

Oracle Supply Chain and Order Management, 6

source independent, 3

required for full load for Oracle HR Analytics, 7.2

Configure Activity Status, how to configure (Oracle Service Analytics), 11.2.2.2

Configured Product Order, example (Oracle Price Analytics), 10.3.2

Configuring flags, how to configure (Contact Center Analytics), 9.2.13

conformed dimensions

universal source, configuring for, 17.16

Contact Reason Column, about (Contact Center Analytics), 9.2.6

Cost Fact Canonical Date, how to configure (Oracle Project Analytics), 15.2.2.25

Cost Of Goods Extract, how to configure (Financial Analytics), 5.3.2.3

Country Codes in PeopleSoft

how to configure, 3.3.2.4

Coverage Metrics, about (Sales Analytics), 8.4.2.3.5

Create Data Files, how to configure (Oracle Project Analytics), 15.2.4.5

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

Currency Conversion (Procurement and Spend), how to configure, 4.3.4.6

Customer Billable Indicator (Procurement and Spend), how to configure, 4.3.4.3

Customer Costs Lines

about, 5.3.1.4

how to configure (Financial Analytics), 5.3.1.5

Customer Status History Fact table

about, 6.3.1.8

configuring, 6.3.1.9

how to configure (Supply Chain and OM), 6.3.1.7

customization

about configuring loads, 17.8

customizing ETL, 17

examples, 17.3.4

overview, 17.1

Source Adapter mapplet. creating, 17.7.3

types, 17.2.1

D

DAC parameters

HR_WRKFC_SNAPSHOT_DT parameter, 7.2

DAC Parameters, how to configure (Oracle Project Analytics), 15.2.1.2

dashboard

updates

PeopleSoft prompts, 5.3.3.7

updating pages with JD Edwards prompts, 5.3.4.6

data import

syndicated data loading, overview, 14.2

data loading

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

Data Source Numbers, how to configure, 3.1.6.1

Database Partitioning

syndicated data (Oracle Pharma Analytics), 14.4

Default Expense Distribution Percentage (Procurement and Spend), how to configure, 4.3.4.5

Defining Filters on Budget Metrics, how to configure (Oracle Project Analytics), 15.2.2.22

Department Trees (PeopleSoft), about configuring, 3.3.2.2

Deployment Date, about (Sales Analytics), 8.4.2.3.1

Dimension Hierarchies, how to configure (Oracle Project Analytics), 15.2.1.1

Dimension Key Resolution, about (Contact Center Analytics), 9.2.1

dimensions

key resolution, using a lookup, 17.12.1

keys, resolving, 17.12

Domain Value and CSV Worksheet Files

Oracle Price Analytics, 10.2.2

domain values

and customization, 17.13

configuring (Oracle Service Analytics), 11.2.2

domain value set, configuring, 17.15

domain value set, extending, 17.13.3

domainValues_AbsenceEvent_Status_ora.csv, how to configure (Oracle HR), 7.2.2.2

domainValues_Employee_Ethnic_Group_Code_ora.csv, how to configure (Oracle HR), 7.2.2.4

domainValues_Employee_Expense_Status.csv, how to configure, 4.2.2.2.13

domainValues_Employee_Expense_Type_ora11i.csv, how to configure, 4.2.2.2.10

domainValues_Employee_Sex_MF_ora.csv, how to configure (Oracle HR), 7.2.2.6

domainValues_Employee_Veteran_Status_Code_ora.csv, how to configure (Oracle HR), 7.2.2.8

domainValues_Employment_Cat_ora.csv, how to configure (Oracle HR), 7.2.2.3

domainValues_Employment_Status_ora.csv, how to configure (Oracle HR), 7.2.2.7

domainValues_Flsa_ora.csv, how to configure (Oracle HR), 7.2.2.9

domainValues_HRPosition_Active_Pos_Flg_ora.csv, how to configure (Oracle HR), 7.2.2.10

domainvalues_lkp_transaction_type_codes_jde.csv (Financial Analytics), how to configure, 5.2.4.3

domainValues_Loyalty_Statement_Type.csv, how to configure (Oracle Loyalty Analytics), 13.2.2

domainValues_Loyalty_Tier_movement_Type.csv, how to configure (Oracle Loyalty Analytics), 13.2.5

domainvalues_make_buy_indicator_product_jde.csv (Financial Analytics), how to configure, 5.2.4.4

domainValues_Member_Status.csv, how to configure (Oracle Loyalty Analytics), 13.2.3

domainValues_Pay_Type_Flg_ora.csv, how to configure (Oracle HR), 7.2.2.11

domainValues_Pay_Type_Grp_Code_ora.csv, how to configure (Oracle HR), 7.2.2.12

domainvalues_payment_method_jde.csv (Financial Analytics), how to configure, 5.2.4.2

domainValues_Payment_Method_psft.csv, how to configure, 4.2.3.1.11

domainValues_PaymentType_ora12.csv, how to configure, 4.2.2.4.1

domainValues_perf_nrml_rating_ora.csv, how to configure (Oracle HR), 7.2.2.13

domainValues_PriceWaterfallElement_Name.csv, how to configure (Oracle Price Analytics), 10.2.3

domainValues_Recruitment_Event_Reason_ora.csv, how to configure (Oracle HR), 7.2.2.14

domainValues_Recruitment_Source_Type_ora.csv, how to configure (Oracle HR), 7.2.2.15

domainValues_Requisition_Category_ora.csv, how to configure (Oracle HR), 7.2.2.16

domainValues_ShipmentType_ora12.csv, how to configure, 4.2.2.2.8

domainvalues_src_transaction_type_codes_jde.csv (Financial Analytics), how to configure, 5.2.4.3

domainValues_Status_APInvoice_psft.csv, how to configure, 4.2.3.1.5

domainValues_Status_Expense_psft.csv, how to configure, 4.2.3.1.10

domainValues_Status_Purch_Approve_ora11i.csv, how to configure, 4.2.2.2.2

domainValues_Status_Purch_Approve_psft.csv, how to configure, 4.2.3.1.1

domainValues_Status_Purch_Cycle_ora11i.csv, how to configure, 4.2.2.2.3

domainValues_Status_Purch_Cycle_psft.csv, how to configure, 4.2.3.1.2

domainValues_Status_Recruitment_ora.csv, how to configure (Oracle HR), 7.2.2.17

domainValues_Status_Vacancy_ora.csv, how to configure (Oracle HR), 7.2.2.18

domainValues_Transaction_Status_Types.csv, how to configure (Oracle Loyalty Analytics), 13.2.4

domainValues_Wrkfc_EventType_ora.csv, how to configure (Oracle HR), 7.2.2.19

domainValues_Xact_Source_AP_Invoice_psft.csv, how to configure, 4.2.3.1.6

domainValues_Xact_Types_Expense_psft.csv, how to configure, 4.2.3.1.8

domainValues_Xact_Types_ExpensePay_psft.csv, how to configure, 4.2.3.1.9

domainValues_Xact_Types_PO_Line_Type_CODE1_ora11i.csv, how to configure, 4.2.2.2.7

domainValues_Xact_Types_PO_Line_Type_ora11i.csv, how to configure, 4.2.2.2.6

domainValues_Xact_Types_Procurement_psft.csv, how to configure, 4.2.3.1.3, 4.2.3.1.4

domainValues_Xact_Types_Purch_Orders_ora11i.csv, how to configure, 4.2.2.2.4

domainValues_Xact_Types_Purch_Requisitions_ora11i.csv, how to configure, 4.2.2.2.5

domainValues_Xact_Types_PurchaseRequisition.csv, how to configure, 4.2.2.2.9

file_ap_invoice_config_spend_ora12.csv, how to configure, 4.2.2.3

file_ap_invoice_config_spend_voucher_psft.csv, how to configure, 4.2.3.2.1

file_xact_type_AgreementLeverageType_psft.csv, how to configure, 4.2.3.1.7, 4.2.3.2.2

file_xact_type_AgreementLeverageType.csv, how to configure, 4.2.2.2.11

for Oracle Service Analytics

Siebel CRM, 11.3.1

importance in customization, 17.13.2

understanding conversion process, 17.13.1

Domain Values and CSV Worksheet Files

for Oracle Financial Analytics, 5.2.2.1

for Oracle HR Analytics, 7.2.1.2

for Oracle JD Edwards, 5.2.4.1

for Peoplesoft, 4.2.3.1

for PeopleSoft (Financial Analytics), 5.2.3.1

how to configure (Oracle Loyalty Analytics), 13.2.1

how to configure (Oracle Marketing Analytics), 12.2.1.1

how to configure (Oracle Service Analytics), 11.3.1.1

how to configure (Supply Chain and OM), 6.2.2.1

HR for PeopleSoft HCM, 7.2.4.1

Oracle EBS, 7.2.2.1

Oracle Service Analytics, 11.2.2.1

PeopleSoft, 7.2.4.1

Domain Values and CSV Worksheet Files, how to configure (Oracle Project Analytics), 15.2.2.1, 15.2.3.2

domainValues_AbsenceEvent_Status_psft.csv, how to configure (Oracle HR), 7.2.4.21

domainValues_Emp_EventType_EventReason_Code_psft.csv, how to configure (Oracle HR), 7.2.4.12

domainValues_Employee_Ethnic_Group_Code_psft.csv, how to configure (Oracle HR), 7.2.4.2

domainValues_Employee_Sex_MF_psft.csv, how to configure (Oracle HR), 7.2.4.3

domainValues_Employee_Veteran_Status_Code_psft.csv, how to configure (Oracle HR), 7.2.4.4

domainValues_Employment_Category_psft.csv, how to configure (Oracle HR), 7.2.4.5

domainValues_Employment_Full_Time_Flg_psft.csv, how to configure (Oracle HR), 7.2.4.7

domainValues_Employment_Status_psft.csv, how to configure (Oracle HR), 7.2.4.8

domainValues_Flsa_psft.csv, how to configure (Oracle HR), 7.2.4.6

domainValues_GeoCountry_ISO_Country_Codes_psft.csv, 3.3.2.4

domainValues_HRPosition_Active_Pos_Flg_psft.csv, how to configure (Oracle HR), 7.2.4.10

domainValues_Pay_Type_Grp_Code_psft.csv, how to configure (Oracle HR), 7.2.4.11

domainValues_perf_nrml_rating_psft.csv, how to configure (Oracle HR), 7.2.4.19

domainValues_Project_Budget_Time_Phased_Code_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.11

domainValues_Project_CommitmentType_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.13

domainValues_Project_Cost_Transfer_Status_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.10

domainValues_Project_Funding_Category_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.9

domainValues_Project_Funding_Level_code_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.8

domainValues_Project_Invoice_Line_Type_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.7

domainValues_Project_InvoiceRevenue_Status_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.6

domainValues_Project_ResourceClass_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.5

domainValues_Project_ServiceType_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.4

domainValues_Project_Status_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.3

DomainValues_Project_Type_Class_code_oraVersion.csv, how to configure (Oracle Project Analytics), 15.2.2.2

domainValues_Recruitment_Event_Reason_psftVersion.csv, how to configure (Oracle HR), 7.2.4.16

domainValues_Recruitment_Source_Type_psftVersion.csv, how to configure (Oracle HR), 7.2.4.13

domainValues_Requisition_Category_psftVersion.csv (WIP), how to configure (Oracle HR), 7.2.4.14

domainValues_Status_Vacancy_Recruitment_psftVersion.csv, how to configure (Oracle HR), 7.2.4.15

domainValues_Wrkfc_EventType_psft.csv, how to configure (Oracle HR), 7.2.4.9

domainValues_Wrkfc_IntlAssign_psft.csv, how to configure (Oracle HR), 7.2.4.20

Drill Down from GL to Subledger, how to configure (Financial Analytics), 5.3.1.3

Duration Metrics format, viewing (Contact Center Analytics), 9.2.19

E

Early and Late Tolerances for Shipments, how to configure (Supply Chain and OM), 6.3.2.5

editing

CSV Worksheet files, 7.2.1.2

Education Degree Codes, how to configure (Oracle HR), 7.2.2.25

Entry-Level Rep Activity Aggregates, how to configure (Contact Center Analytics), 9.2.15

ETL

troubleshooting, 8.4.2.2

Exchange Rate Types, how to configure, 3.1.3

Expenditure Fact, how to configure (Oracle Project Analytics), 15.2.2.25

extract filter, how to configure for GL (Financial Analytics), 5.3.2.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

file_fin_stmt_item_names_jde.csv (Financial Analytics), how to configure, 5.2.4.5

file_fin_sub_names_jde.csv (Financial Analytics), how to configure, 5.2.4.5

file_glacct_catcodes_segment_config_jde.csv (Financial Analytics), how to configure, 5.2.4.7

file_glacct_segment_config_jde.csv (Financial Analytics), how to configure, 5.2.4.8

file_group_acct_codes_jde.csv (Financial Analytics), how to configure, 5.2.4.6

file_lkp_fiscal_period_Qtr_Config_jde.csv (Financial Analytics), how to configure, 5.2.4.9

file_pension_comp_flg.csv, how to configure (Oracle HR), 7.2.4.17

file_Redeemed_Unit_Cost.csv, how to configure (Oracle Loyalty Analytics), 13.2.6

Financial Resource Dimension, how to configure (Oracle Project Analytics), 15.2.2.16

Financial Statement Generator, configuring GL Account Hierarchies with, 3.2.1.6.2

Financial Subject Areas, integration with Oracle Project Analytics, 5.3.2.10

fiscal calendars, 5.3.3.4

how to configure, 3.1.4

initialization blocks required for, 3.1.4.1.1, 5.2.1

setting up, 3.1.4

setup for PeopleSoft, 5.3.3.4

flags, how to configure (Contact Center Analytics), 9.2.13

Flat File Cross-Reference

Data Population Rules, 14.3.12

flat file data

non-Siebel Sources, 10.2.4.2

Siebel Sources, 10.2.4.1

Flexfield Configuration, 7.2.3.1

Flexflelds, how to configure (Oracle HR), 7.2.3

Forecast Fact Canonical Date, how to configure (Oracle Project Analytics), 15.2.2.23

Funding Fact Canonical Date, how to configure (Oracle Project Analytics), 15.2.2.24

Funding Fact, how to configure (Oracle Project Analytics), 15.2.2.24

G

General Ledger Chartfield Hierarchy Extraction, customizing, 5.3.3.3

Account Dimension (PeopleSoft), about, 3.3.1.1

Account Hierarchies (JD Edwards), about configuring, 3.5.1.5

Account Hierarchies with FSG, how to configure, 3.2.1.6.2

Account Hierarchies, about configuring, 3.2.1.6

Accounting Flexfields, about ETL Process for, 3.2.1.6.1

accounting flexfields, how to configure, 3.2.1.6.1

Accounts (JD Edwards), how to configure, 3.5.1.4

Balances in Oracle's JD Edwards, about, 5.3.4.1

Balances, about population (Financial Analytics), 5.3.2.1

Budget Analytics

for PeopleSoft configuration, 5.2.3.4

Data extraction (Financial Analytics), how to configure, 5.2.2.4

Natural Accounts, how to configure, 3.2.1.4

Global Currencies, how to configure, 3.1.2

Group Accounts

about configuring (PeopleSoft), 3.3.1.2

how to configure numbers, 3.2.1.4

H

HCM hr_file_flex_kff_dff_user_config_map.csv, how to configure (Oracle HR), 7.2.3.1

hierarchies

configuring multiple, 3.2.1.1

customizing Product Category Hierarchies, 3.2.1.1.2, 16.4

with GL accounting flexfields, how to configure, 3.2.1.6.1

historically significant attributes

identifying, 17.9.1

I

Initial Extract Date, how to configure, 3.1.1

initialization blocks

enabling for multi-calendar, 3.1.4.1.1, 5.2.1

Integration_Id, how to configure (Contact Center Analytics), 9.2.17

Internal Organization Hierarchy Extraction (PeopleSoft), how to configure, 3.3.2.3

Inventory Monthly Balance Table, how to configure (Supply Chain and OM), 6.3.1.10

Inventory Monthly Balance, how to configure (Supply Chain and OM), 6.3.1.11

Invoice Line Domain Values, how to configure (Oracle Project Analytics), 15.2.3.4

Invoice Status Domain Values, how to configure (Oracle Project Analytics), 15.2.3.9

Invoice Status Domain Values, how to configure (Supply Chain and OM), 6.2.2.7

Invoice Type Domain Values, how to configure (Supply Chain and OM), 6.2.2.2

ISO_Country_Codes (PeopleSoft), how to configure, 3.3.2.4

IVR Menu, how to configure (Contact Center Analytics), 9.2.18

IVR Navigation Profile Tables, 9.2.18

J

Job Dimension, how to configure (Oracle Project Analytics), 15.2.2.19

Job Requisition

Age Band Dimension, how to configure (Oracle HR), 7.2.1.1.3

metrics in Oracle EBS, 7.3.2.3

Job Requisition Metrics, how to configure (Oracle HR), 7.3.2.3

K

Key Flexfields for the Job Dimension, how to configure (Oracle HR), 7.2.3.2

Key Flexfields for the Pay Grade Dimension, how to configure (Oracle HR), 7.2.3.4

L

Lead Quality Codes, how to configure (Oracle Marketing Analytics), 12.2.1.2

Lead Status Codes, how to configure (Oracle Marketing Analytics), 12.2.1.3

Ledger or Set of Books (Financial Analytics), how to configure, 5.2.2.4

Left Bound and Right Bound Calculation Option, how to configure (Supply Chain and OM), 6.3.2.15

Life Sciences, data warehouse overview, 14.1

Loading Bookings at the Schedule Line Level, 6.3.2.4

loading complete data

Oracle HR Analytics, pre-configuration steps, 7.2

Lookup Dates for Currency Conversion (Procurement and Spend), how to configure, 4.3.4.6

LoyaltyTotalRevenueInput.xls, how to configure (Oracle Loyalty Analytics), 13.3.1

M

Make-Buy Indicator, how to configure, 3.2.2.1

Master Inventory Organization in Product Dimension, how to configure, 3.2.1.3

Metric Definitions and Variables, about (Sales Analytics), 8.4.2.3

metrics

job requisition, 7.3.2.3

Movement Types Domain Values, how to configure (Supply Chain and OM), 6.2.2.9

Multi Calendar Support, how to configure (Oracle Project Analytics), 15.3.1.1

Multi Currency Support, how to configure (Oracle Project Analytics), 15.3.1.2

Multiple Attribute Changes, tracking (Supply Chain and OM), 6.3.1.1

multiple product hierarchies, 3.2.1.1

N

Nonbooked Orders

including in Sales Order Lines Tables, 6.3.2.2

non-Siebel Sources

flat file data, 10.2.4.2

nQSError 43059

enabling initialization blocks, 3.1.4.1.1, 5.2.1

Number of Days based Metrics (PeopleSoft), 5.3.3.6

Number of Days based Metrics, how to configure (Financial Analytics), 5.3.4.5

O

Operating Unit Based Security, how to configure (Oracle Project Analytics), 15.2.2.20

Operating Unit Based Security, with PeopleSoft (Oracle Project Analytics), 15.2.3.13

Operating Unit Org-based security, about (Oracle Service Analytics), 11.2.3

Opportunity Updates Metrics, about (Sales Analytics), 8.4.2.3.3

Oracle Business Intelligence Applications

overview of configuration steps, 2

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

deleting records from Fact Tables, 9.2.11

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 Employee Expense Analytics

how to configure (Procurement and Spend), 4.2.2.4.2

Oracle Financial Analytics

configuration steps before full load, 5.2

Domain Values and CSV Worksheet Files, 5.2.2.1

enabling initialization blocks for multi-calendar, 3.1.4.1.1, 5.2.1

overview, 5.1

Oracle HR Analytics, 7.3.1.1

about domain values and CSV worksheet files, 7.2.1.2

configuration steps for full load, 7.2

HR_WRKFC_SNAPSHOT_DT parameter, 7.2, 7.2

optional configuration steps, 7.3

overview, 7.1

Oracle Loyalty Analytics

Configuration steps before a full load, 13.2

configuration steps before full load, 13.2

overview, 13.1, 13.1

roles, 13.1.1

Oracle Marketing Analytics

configuration steps before a full load, 12.2.1

overview, 12.1

Oracle Order Management and Fulfillment Analytics

mandatory configuration steps, 6.2.1

optional configuration steps, 6.3

overview, 6.1

Oracle Payables Analytics, how to configure (Financial Analytics), 5.3.2.4

Oracle Pharma Analytics

Data Loading Issues, 14.6

Data Types Supported, 14.2.2

data warehouse overview, 14.1

database partitioning, 14.4

database partitioning Database Partition Components, 14.4.2

database partitioning overview, 14.4.1

database partitioning Partition Name and Value, 14.4.3

database partitioning, disabling, 14.4.7

database partitioning, enabling, 14.4.6

database partitioning, how to create Partition Table, 14.4.4

database partitioning, supported platforms, 14.4.8

database partitioning, with flat files, 14.4.5

Enable Restartability Feature, 14.5.2

Importing Syndicated Data, 14.2

Incremental Updates, 14.7

Loading Syndicated Data, 14.2.3

loading Syndicated Data from flat file, 14.2.3.1

loading Syndicated Market data from staging tables, 14.2.3.2

Restartability Feature, disabling, 14.5.3

Syndicated Data and Market Load, restartability, 14.5

Syndicated Data Fact Tables, known issues, 14.6.1

syndicated data flat file formats, 14.3

Syndicated Loading Definitions, 14.2.1

W_ALIGNMT_DH, incremental updates, 14.7.1

W_ALIGNVER_DH, incremental updates, 14.7.2

Oracle Price Analytics

configuration steps before a full load, 10.2

overview, 10.1

Oracle Procurement and Spend Analytics

about configuring for Universal Source, 4.3.4.1

configuration steps before full load, 4.2

configuration steps for PeopleSoft, 4.2.3

domain values and CSV worksheet files, 4.2.2.2

integration with Oracle Project Analytics, 4.3.2.2

overview, 4.1

universal source, configuring expenses, 4.3.4.1

Oracle Profitability Analytics

Customer Costs Lines, 5.3.1.4

how to configure Budgets, 5.3.1.6

Transaction Extracts, how to configure (Financial Analytics), 5.3.2.2

Oracle Project Analytics

configuration required before a full load, 15.2

configuration steps before a full load, 15.2

configuration steps before full load, 15.2

how to enable with Oracle Procurement and Spend, 4.3.3.1

integration with Financial Analytics, 15.4.1.2

integration with Financial Subject Areas (EBS), 5.3.2.10

integration with Financial Subject Areas (PeopleSoft), 5.3.3.5

integration with Procurement and Spend Analytics, 15.4.1.1

integration with Procurement and Spend, how to enable, 4.3.2.2

integration with Project Analytics for PeopleSoft, 15.4.2

overview, 15.1, 15.1

Oracle Receivables Analytics

how to configure (Financial Analytics), 5.3.2.5

Oracle Service Analytics

Activity Category, how to configure, 11.2.2.7

Activity Priority, how to configure, 11.2.2.6

Activity Resolution, how to configure, 11.2.2.9

Activity Status, how to configure, 11.3.1.2

Activity Type, how to configure, 11.2.2.8

configuration steps before a full load, 11.2

DAC parameters for, 11.2.1

overview, 11.1

RPD configuration, 11.2.3

Oracle Spend Classification

configuration steps, 4.2.1.1

how to deploy, 4.2.1.1.4

how to remove metadata, 4.2.1.1.3

Oracle Supply Chain and Order Management Analytics

aggregating tables, 6.3.1.2

tracking multiple products, 6.3.1.3

Oracle's Siebel Life Sciences

data loading issues, 14.6

Order Lines Execution Plan, how to configure (Supply Chain and OM), 6.3.2.8

Order Management and Fulfillment Analytics

multiple products, about tracking, 6.3.1.3

Order Overall Status Domain Values, how to configure (Supply Chain and OM), 6.2.2.8

Order Types Domain Values, how to configure (Supply Chain and OM), 6.2.2.4

Original Job Requisition Status, how to configure (Oracle HR), 7.3.2.2

P

parameterfileDW.txt

editing, 4.3.1.2, 6.3.1.2

parameters

HR_WRKFC_SNAPSHOT_DT parameter, 7.2

Pay Method Domain Values, how to configure (Supply Chain and OM), 6.2.2.6

Pay Type Dimension, how to configure (Oracle HR), 7.2.2.26

Payroll table, about aggregating, 7.3.1.1

Payroll Table, how to configure (Oracle HR), 7.3.1.1

PeopleSoft, 5.3.3.4

about configuring Department Trees, 3.3.2.2

configuring Country Codes, 3.3.2.4

Prompts, dashboard updates, 5.3.3.7

Tree Data Structures, 5.3.3.1

Tree for Commitment Control Budget, 5.2.3.4.1

Trees

configuring department trees, 3.3.2.2

Trees, about, 5.3.3.2

PeopleSoft, setting up Fiscal Calendars, 5.3.3.4

Performance Band Dimension, how to configure (Oracle HR), 7.2.1.1.4

Performance for the Payroll Table, how to configure (Oracle HR), 7.3.3.2

performance tuning

PeopleSoft HCM HR Analytics payroll table, 7.3.3.2

Period of Work Band Dimension, how to configure (Oracle HR), 7.2.1.1.5

Persisted Stage, how to configure (Oracle Project Analytics), 15.2.3.1

Phone Types for HR Profile, how to configure (Oracle HR), 7.2.2.24

Pick Status Domain Values, how to configure (Supply Chain and OM), 6.2.2.5

Pick Types Domain Values, how to configure (Supply Chain and OM), 6.2.2.3

Preferred Merchant Flag (Procurement and Spend), how to configure, 4.3.4.2

Price Waterfall, Element Sample Data, 10.3

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

primary extract and delete mappings, understanding, 17.8.2

primary extract and delete mappings, working with, 17.8.3

Product Category Hierarchies

customizing, 3.2.1.1.2, 16.4

Product Costs Lines

about, 5.3.1.4

Product Costs Lines, how to configure (Financial Analytics), 5.3.1.5

product hierarchies

configuration, 3.2.1.1

how to configure, 3.2.1.1

Product Order, example (Oracle Price Analytics), 10.3.1

Product Transaction Aggregate Table, how to configure (Supply Chain and OM), 6.3.1.12, 6.3.1.13

Project Budget, how to configure (Oracle Project Analytics), 15.2.3.10

Project Classification Dimension, how to configure (Oracle Project Analytics), 15.2.2.17

Project Cost Aggregate Table, how to configure (Oracle Project Analytics), 15.2.1.3

Project Cost, how to configure (Oracle Project Analytics), 15.2.3.11

Project Dimension, how to configure (Oracle Project Analytics), 15.2.2.14

Project Dimensions, how to disable (Supply Chain and OM), 6.2.1.1

Project Funding Fact, how to configure (Oracle Project Analytics), 15.2.3.14

Project Retention Fact, how to configure (Oracle Project Analytics), 15.2.3.15

Project Status Domain Values, how to configure (Oracle Project Analytics), 15.2.3.6

Project Type Class Code Domain Values, how to configure (Oracle Project Analytics), 15.2.3.5

Purchase Cycle Line (Procurement and Spend), how to configure, 4.2.2.1

Purchase Cycle Lines Aggregate Table (Procurement and Spend), about configuring, 4.3.1.3

Purchase Cycle Lines Aggregate Table (Procurement and Spend), how to configure, 4.3.1.4

Purchase Order Records (Procurement and Spend), how to extract, 4.3.2.1

Purchase Receipts Aggregate Table (Procurement and Spend), about configuring, 4.3.1.1

Purchase Receipts Aggregate Table (Procurement and Spend), how to configure, 4.3.1.2

Q

Quantity Types for Product Transactions, how to configure (Supply Chain and OM), 6.2.2.11

Quarters for a Fiscal Pattern (JD Edwards), how to configure, 3.5.1.3

R

Receipts Indicator (Procurement and Spend), how to configure, 4.3.4.4

records

filtering and deleting, 17.8.2, 17.8.3

filtering and deleting, about, 17.8.1

source-archived records, deletion configuration, 17.8.3.1

Representative Data

excluding, how to configure (Contact Center Analytics), 9.2.14

Request Severity Code, how to configure (Oracle Service Analytics), 11.2.2.11, 11.3.1.10

Resource Class Domain Values, how to configure (Oracle Project Analytics), 15.2.3.3

responsibilities

in Usage Accelerator, 8.4.2.2

Revenue Status Domain Values, how to configure (Oracle Project Analytics), 15.2.3.8

S

Sales Invoice Extract, how to configure (Supply Chain and OM), 6.3.2.7

Sales Invoice Lines

Data Storage, how to configure (Supply Chain and OM), 6.3.2.6

Sales Order Lines

Data Storage, how to configure (Supply Chain and OM), 6.3.2.1

Sales Order Lines Tables

including Nonbooked Orders, 6.3.2.2

Sales Schedule Lines Data Storage, how to configure (Supply Chain and OM), 6.3.2.3

Sample Source Files, how to configure (Oracle Project Analytics), 15.2.4.3

security

enabling initialization blocks, 3.1.4.1.1, 5.2.1

Service Request Area Code, how to configure (Oracle Service Analytics), 11.2.2.12, 11.3.1.11

Service Request Status, how to configure (Oracle Service Analytics), 11.2.2.5, 11.3.1.5

Siebel

8.1.1, Oracle Marketing Analytics, 12.2.1

CRM, domain values for Oracle Service Analytics, 11.3.1

sources, populating flat file data, 10.2.4.1

Siebel Responsibilities, 8.4.2.2

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

Snapshot Frequency, how to deploy (Sales Analytics), 8.3.1

Source Adapter mapplet

creating, 17.7.3

source-archived records

deletion configuration, 17.8.3.1

stored lookups

configuring, 17.10

Stored Procedures, how to deploy (Sales Analytics), 8.2.1

Supply Chain BOM Items

size restrictions, 6.2.2, 6.3.2.14

syndicated data

importing, overview, 14.2

Syndicated Data Flat File

Direct Sales Data, 14.3.1

for Weekly Early View Data, 14.3.6

Formats for Oracle Pharma Analytics, 14.3

Indirect Sales Data, 14.3.2

Physician Plan Level Rx Data, 14.3.5, 14.3.5

Plan Level Rx Data, 14.3.4

Prescription Data, 14.3.3

Syndicated Market Flat File

Indirect Sales Data, 14.3.7

Physician Plan Level Rx Data, 14.3.10

Plan Level Rx Data, 14.3.9

Prescription Data, 14.3.8

Weekly Early View Data, 14.3.11

T

Targeted Users, how to track (Sales Analytics), 8.4.2.1

Task Dimension, how to configure (Oracle Project Analytics), 15.2.2.15

Tracking Attribute Changes in Bookings, 6.3.2.10

Transaction Types (Financial Analytics), how to configure, 5.2.2.2, 5.2.2.3

Transfer Status Domain Values, how to configure (Oracle Project Analytics), 15.2.3.7

Tree Data Structures, PeopleSoft, 5.3.3.1

troubleshooting

ETL failure, 8.4.2.2

U

Unapplied Payments

how to configure (Financial Analytics), 5.3.1.1

Using in AR Aging calculations, 5.3.1.1

Universal Adapter

conformed dimensions, configuring, 17.16

for CRM Analytics, A.1

Oracle BI Supply Chain Analytics, configuring expenses, 4.3.4.1

Universal Adapter, how to configure (Oracle Project Analytics), 15.2.4.1

Universal Source

about configuring, 5.3.1.6.1

configuring with Oracle Procurement and Spend, 4.3.4.1

how to configure (Oracle Price Analytics), 10.2.4

UNSPSC Codes

assigning to products, 3.2.1.2

how to configure, 3.2.1.2

Usage Accelerator

ETL failure, 8.4.2.2

Siebel Responsibilities, 8.4.2.2

what is?, 8.4.1

Usage Accelerator Execution Plan, about, 8.4.3

Usage Accelerator, how to deploy (Sales Analytics), 8.4, 8.4.2

W

Work Type Dimension, how to configure (Oracle Project Analytics), 15.2.2.18