Index

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

Symbols

$$PERIOD

about, 10.2.5.1.8

configuring, 10.2.5.1.9

$$WH_DATASOURCE_NUM_ID

about, 10.2.5.1.8

configuring, 10.2.5.1.9

A

system preferences

action links

about, D.2.6

testing, D.2.7

alignments dimension, configuring, E.6.6.2

ANSI NULL option, setting, 3.6.1

Applications

Oracle Contact Center Telephony Analytics, 8, 12, 13

Oracle Financial Analytics, 9

Oracle HR, 11

Oracle Order Management and Fulfillment Analytics, 10

Oracle Sales Analytics, 12

Oracle Supply Chain Analytics, 8, 12

AR Aging calculations

including UnApplied Payments, 9.2.5.1.1

attributes

historically significant attributes, identifying, 5.8.1

B

browsers

settings, configuring, D.2.10

bulkload mode, error while creating a custom session, I.2

C

calculations

including UnApplied Payments in AR Aging calculations, 9.2.5.1.1

Catalog Manager

using, 2.5

charts

local seed data, importing, C.1.1.1

translation tables, process of maintaining, C.1

W_LOCALIZED_STRING_G table, adding custom translations, C.1.3

Web catalog strings, about translating, C.2

circular hierarchy exceptions, about and example, H.1.6

code lookup

about, 5.10

code mappings, 5.10.2

codes mapplets, 5.10.3

sessions for lookups, configuring, 5.10.4

W_CODES table, 5.10.1

code page

environments, 4.3.3

Communications, Media, and Energy Analytics

dashboards and pages, E.6.4

data requirements, E.6.5, E.6.5

order management analytics, about, E.6.3

predictive scores, developing and deploying, E.5

security settings, 6.5.2.3, 6.5.2.3

complex products defined, E.6.3

configuration steps

all source systems, 7.1

controlling data set

Oracle Contact Center Telephony Analytics, 13

Oracle Financial Analytics, 9, 9.2.5

Oracle Human Resources Analytics, 11

Oracle Procurement and Spend Analytics, 8

Oracle Sales Analytics, 12

source independent, 7

Supply Chain and Order Management Analytics, 10

Oracle BI Repository, 14

Oracle EBS-specific, 7.2

PeopleSoft-specific, 7.3

required before full load

Oracle Contact Center Telephony Analytics, 13

Oracle Financial Analytics, 9

Oracle Human Resources Analytics, 11

Oracle Procurement and Spend Analytics, 8

Oracle Sales Analytics, 12

source independent, 7

Supply Chain and Order Management, 10

configuring, E.6.6.3

DAC client, 4.3.4.5

DAC metadata repository, A.7

email recipients in DAC client, 4.12.2

fiscal calendar, 7.1.1.4.5

Oracle Business Analytics Warehouse database, 4.10

SSE role, 4.3.4.1.1

conformed dimensions

universal source, configuring for, 5.15

Contact Center Telephony Analytics

dashboards and pages, E.6.1

data requirements, E.6.2

Cost List exceptions

D

DAC

configuring metadata repository, A.7

Source System Parameters, 4.15.9

starting and stopping the server, A.2

DAC metadata repository

database, 4.3.4.1

DAC Server

starting and stopping manually, A.2

dashboards

CME dashboards and pages, E.6.4

consumer sector dashboards and pages, E.6.1

customizing, about, D.2.11

exposing dashboards and requests, D.3.1

information, about viewing information, D.3

locating dashboard and page names, D.3.2

viewing a list of, 2.5

views, adding, D.2.14

data import

syndicated data loading, overview, F.3

data loading

Oracle's Siebel Analytics for Life Sciences, issues when loading, F.5

troubleshooting, Informatica and data loading issues, I.2

Data Movement Mode, 4.3.3

data movement mode, 4.3.3

Data Source NUM ID

configuring $$WH_DATASOURCE_NUM_ID, 7.1.2.1

data warehouse

database connections, 4.12.3

Data Warehouse Administration Console (DAC)

about, 2.3.1

configuring on UNIX, A.6

configuring the client, 4.3.4.5

setting up system properties, A.7.1

database connections

transactional, creating, 4.12.3

database requirements, 4.3.4.1

DataMovementMode parameter, 4.3.3

DATASOURCE_NUM_ID

about, 7.1.2.1

configuring, 7.1.2.1

DB Library Options setting, modifying, 3.6.2

DB2 databases

DB2CODEPAGE, 4.3.4.2.2

environment variable, 4.3.4.2.2

Oracle Business Analytics Warehouse requirements, 3.3

Oracle Business Analytics Warehouse, cannot connect to, I.1

DB2-UDB

creating stored procedures, 4.15.4

deployment

topology example, 4.1

dimensions

alignments dimension, configuring, E.6.6.2

key resolution, using a lookup, 5.11.1

keys, resolving, 5.11

pharmaceuticals, configuring dimensions specific to, E.6.7

positions dimension, configuring, E.6.6.1

product costs, configuring, E.6.6.4

products dimension, configuring, E.6.6.3

documentation

Repository Documentation feature, 2.5

domain values

domain value conversion process, understanding, 5.12.1

domain value set, configuring, 5.14

domain value set, extending, 5.12.3

importance, understanding, 5.12.2

working with, 5.12

E

configuring Email in the DAC Server, 4.15.7

configuring email recipients in the DAC Client, 4.15.6

notification in Outlook error when sending post session email, I.2

environment variables

DB2CODEPAGE, 4.3.4.2.2

NLS_LANG, 4.3.4.2.1

ETL

error with W_UAEMP_TMP and W_UAPOS_TMP table, I.7

History view, H.2.5

improve performance using partitioning, 3.9

index errors, I.7

running with Non-English OLTP Data Source, 3.8.4

troubleshooting, 12.3.1.1.2, I.7

ETL failure, I.7

Event Types

configuring for PSFT and HR, 11.2.3.21

exception reports

additional exceptions, list of, H.2.6

circular hierarchy exceptions, about and example, H.1.6

cleansing the data, process and diagram, H.2.1

ETL History view, using to view the history of the ETL processes and statuses, H.2.5

exception report components, list of, H

exception, fixing, H.2.1

exchange rate exceptions, about, H.1.4

Exchange Rate view, using to diagnose currency translation issues, H.2.3

executing the report, cleansing steps, H.2

invalid hierarchy exceptions, about, H.1.5

List of Values exceptions, H.1.1

List of Values view, using to compare values with Oracle Business Analytics Warehouse, H.2.2

F

fiscal calendar

configuring, 7.1.1.4.5

fiscal month

configuring, 7.1.1.4.5

fiscal week

configuring, 7.1.1.4.5

H

Healthcare Analytics

security settings, 6.5.2.4

hierarchical relationships, invalid hierarchy exceptions, about, H.1.5

historically significant attributes

identifying, 5.8.1

home page

content, customizing, D.2.12

customizing, about, D.2.11

path argument, determining, D.2.13

Horizontal applications

indexing for performance, 3.8.3

HR Analytics

configuring Event Types for PSFT, 11.2.3.21

I

Incentive Compensation Analytics, turning on, D.2.9

indexing

S_.* tables, 3.8.3.1

to improve performance, 3.8.3

Informatica

default passwords, 4.5.1

fatal errors 11, I.2

fatal errors 3644-1 or 360454, I.2

username and password, 14

Informatica PowerCenter

requirements, 4.3.2

terminology changes in 8.1.1, 4.3.2

Informatica Repository

versioned, J

Informatica repository

database, 4.3.4.1

dropping, A.5

Informatica Server

password, 4.5.1

registering, 4.12.2

infrastructure requirements, 4.3.1

Initialization Blocks, 3.8.2

installation

database connectivity, 4.8.1

Java SDK, 4.3.4.5

JDBC drivers, 4.8.1

Oracle BI Applications installation process task list, 4.2

installation and configuration

task list, 4.2

installing

Oracle BI repository, setting up, 14.2

Insurance Analytics family of products

security settings, 6.5.2.4

IP address

virtual IP address, creating, D.2.4

virtual IP address, testing, D.2.5

J

Java JDK

requirements, 4.3.4.5

Java SDK

installation, 4.3.4.5

JDBC drivers

installation, 4.8.1

L

large fact tables

partitioning, 3.9

List of Values

exceptions, about and example, H.1.1

view, using to compare values with the Oracle Business Analytics Warehouse, H.2.2

loads, configuring

about, 5.7

Source Adapter mapplet. creating, 5.6.3

M

Mappings

SA System Subject Area, 3.8.1

metadata

externalizing strings, C.1.2

object level security, repository groups, 6.4

Web Catalog group security, 6.4.1.2

Web Catalog security, 6.4.1.2

metadata object level security

repository groups, 6.4.1

Microsoft Outlook

closes when finishing ETL process, probable cause, I.2

error when sending post session email, I.2

Migrating Seed Data from Siebel OLTP Source Systems, 4.15.10

N

NLS_LANG environment variable, 4.3.4.2.1

Non-English OLTP Data Source

running an ETL with, 3.8.4

O

OPB_OBJECT_LOCKS Informatica session deadlocked, probable cause, I.2

Operational Applications

dashboards, adding views, D.2.14

home page content, customizing, D.2.12

home page path argument, determining, D.2.13

Oracle

mappings hang, probable cause, I.2

Oracle BI Administration Tool

using to generate Repository Documentation, 2.5

Oracle BI Applications

action links, about, D.2.6

action links, testing, D.2.7

browser settings, configuring, D.2.10

completing initialization, D.2

dashboards, adding views, D.2.14

home page and dashboards, about customizing, D.2.11

home page content, customizing, D.2.12

Incentive Compensation Analytics, turning on, D.2.9

initialization, completing, D.2

installation and configuration process task list, 4.2

operational applications, about integrating within, D.2.8

Optional Analytics Applications, D.2.9

virtual IP address, creating, D.2.4

Web Extension, configuring to work with, D.2.3

Oracle BI Applications, configuring

home page, determining path argument, D.2.13

virtual IP address, testing, D.2.5

Oracle BI Charts

metadata strings, externalizing, C.1.2

Oracle BI seed data, updating for non-English locales, C.1.1

Oracle BI EE

requirements, 4.3.1

Oracle BI Presentation layer

process of maintaining translation tables, C.1

Oracle BI repository

externalizing metadata strings, C.1.2

repository groups, security, 6.4

Oracle BI SE One

requirements, 4.3.1

Oracle BI seed data

updating for non-English locales, C.1.1

Oracle BI Supply Chain Analytics

domain values and CSV worksheet files, 8.2.2.2

universal source, configuring expenses, 8.2.5.4.1

Oracle Business Analytics Warehouse

architecture components, 2.3.1

database, 4.3.4.1

database parameters and requirements, 3.2

database, configuring, 4.10

DB2 requirements, 3.3

operating system, driver, connectivity requirements, 3.1

SQL server-specific requirements, 3.6

tables, creating, 4.10.1

Teradata requirements, 3.7.1

Oracle Contact Center Telephony Analytics

Benchmarks and Targets table, setting up, 13.2.10

Contact Representative Snapshot table, setting up, 13.2.9

Contact Status Type columns, about configuring for, 13.2.7

dates and times, configuring, 13.2.12

dimension key resolution, 13.2.1

dimension table, loading, 13.2.2

Event Type columns, about configuring for, 13.2.5

fact table, loading, 13.2.3

overview, 13.1

Representative Activities table, setting up, 13.2.8

Oracle databases

NLS_LANG, 4.3.4.2.1

Oracle Financial Analytics

configuration steps before full load, 9.2

disabling logical table sources, E.4, E.4

externalizing metadata translation strings, E.3, E.3

logical table sources, disabling, E.4, E.4

logical table sources, updating, E.2, E.2

metadata translation strings, externalizing, E.3, E.3

overview, 9.1

updating logical table sources, E.2, E.2

Oracle HR Analytics, 11.2.5.1.1

domain values and CSV worksheet files, 11.2.2.1

overview, 11.1

Oracle Order Management and Fulfillment Analytics

options, 10

overview, 10.1

Oracle Partner Analytics

role-based analytics dashboard mapping, 6.5.2.1

Oracle Pharma Sales Analytics applications

security settings, 6.5.2.5

Oracle Procurement and Spend Analytics

configuration steps before full load, 8.2

overview, 8.1

Oracle's Siebel Industry Applications

alignments dimension, configuring, E.6.6.2

Analytics applications, about metadata requirements, E.6

CME dashboards and CME Analytics applications

dashboards and pages, E.6.4

CME data requirements, E.6.5

CME security settings, 6.5.2.3

consumer sector dashboards and pages, E.6.1

consumer sector data requirements, E.6.2

consumer sector security settings, 6.5.2.2

dimensions, configuring specific to pharmaceuticals, E.6.7

Oracle Pharma Sales Analytics security settings, 6.5.2.5

Oracle's Siebel Financial Services security settings, 6.5.2.4

Pharma sales effectiveness, configuring subject area, E.6.7.1

product costs dimension, configuring, E.6.6.4

Usage Accelerator Analytics security settings, 6.5.2.6

Oracle's Siebel Industry applications

alignments dimension, configuring, E.6.6.2

Analytics applications, about metadata requirements, E.6

CME dashboards and pages, E.6.4

CME data requirements, E.6.5

consumer sector dashboards and pages, E.6.1

consumer sector data requirements, E.6.2

dimensions, configuring specific to pharmaceuticals, E.6.7

Pharma medical education effectiveness, configuring subject area, E.6.7.4

Pharma product categories, configuring subject area, E.6.7.2

Pharma promotional effectiveness, configuring subject area, E.6.7.3

Pharma Sales Analytics, about metadata requirements, E.6.6

Pharma sales effectiveness, configuring subject area, E.6.7.1

positions dimension, configuring, E.6.6.1

predictive scores, developing and deploying, E.5

product costs dimension, configuring, E.6.6.4

Oracle's Siebel Life Sciences

data loading issues, F.5

Oracle's Siebel Operational Applications

integration with

data types, D

integration with Industry Applications, D.1

Oracle Partner Analytics security settings, 6.5.2.1

security

OracleBIAnalyticsApps.rpd

Informatica username and password, 14

order management analytics, about, E.6.3

Order Management and Fulfillment Analytics

multiple products, about tracking, 10.2.5.1.3

Outlook

closes when finishing ETL process, probable cause, I.2

error when sending post session email, I.2

P

page names, locating and dashboards, D.3.2

parent-child relationship, circular hierarchy exceptions, H.1.6

partitioning, 3.9

password

Informatica administrator, 4.5.1

OracleBIAnalyticsApps.rpd, 14

Payroll table, about aggregating, 11.2.5.1.1

PeopleSoft Trees, 9.2.5.3.1

PerfIndex_Horizontal.sql, 3.8.3.1

PerfIndex_Industry.sql, 3.8.3.1

performance

components configured to optimize performance, 3.6.3

implementing indexes to improve, 3.8.3

partitioning large fact tables, 3.9

Pharma objectives achievement

configuring subject area, E.6.7.5

medical education effectiveness, configuring subject area, E.6.7.4

Pharma product categories

configuring subject area, E.6.7.2

Pharma promotional effectiveness, configuring subject area, E.6.7.3

Pharma Sales Analytics

alignments dimension, configuring, E.6.6.2

dimensions, configuring specific to pharmaceuticals, E.6.7

medical education effectiveness, configuring subject area, E.6.7.4

metadata requirements, about, E.6.6

objectives achievement, configuring subject area, E.6.7.5

Pharma medical education effectiveness, configuring subject area, E.6.7.4

Pharma objectives achievement, configuring subject area, E.6.7.5

Pharma product categories, configuring subject area, E.6.7.2

Pharma promotional effectiveness, configuring subject area, E.6.7.3

Pharma Sales effectiveness, configuring subject area, E.6.7.1

positions dimension, configuring, E.6.6.1

product categories, configuring subject area, E.6.7.2

product costs dimension, configuring, E.6.6.4

products dimension, configuring, E.6.6.3

promotional effectiveness, configuring subject area, E.6.7.3

sales effectiveness, configuring subject area, E.6.7.1

security settings, 6.5.2.5

Pharma Sales Analytics applications

dimensions, configuring specific to pharmaceuticals, E.6.7

metadata requirements, about, E.6.6

Pharma medical education effectiveness, configuring subject area, E.6.7.4

Pharma objectives achievement, configuring subject area, E.6.7.5

Pharma product categories, configuring subject area, E.6.7.2

Pharma promotional effectiveness, configuring subject area, E.6.7.3

Pharma Sales effectiveness, configuring subject area, E.6.7.1

positions dimension, configuring, E.6.6.1

product costs dimension, configuring, E.6.6.4

products dimension, configuring, E.6.6.3

Pharma Sales Analytics, about metadata requirements, E.6.6

positions dimension, configuring, E.6.6.1

predictive analytics metadata

predictive scores, developing and deploying, E.5

Presentation Catalog, administering

dashboards, about viewing information, D.3

dashboards, exposing and requests, D.3.1

dashboards, locating and page names, D.3.2

Presentation Services Catalog

viewing, 2.5

primary extract and delete mapping

delete and primary extract sessions, enabling, 5.7.3.2

source-archived records, deletion configuration, 5.7.3.1

working with, 5.7.3

PRM Analytics

data-level visibility, 6.5.2.1.5

portal-based analytics dashboard mapping, 6.5.2.1.2

subject area mapping, 6.5.2.1.3

subject area visibility, 6.5.2.1.4

product costs dimension, configuring, E.6.6.4

products dimension, configuring, E.6.6.3, E.6.6.3

Q

Query Analyzer, can not open after installing ODBC driver, I.1

query performance

improve using partitioning, 3.9

R

RDBMS error message, probable cause, I.2

records

source-archived records, deletion configuration, 5.7.3.1

records, filtering and deleting

about, 5.7.1

primary extract and delete mappings, understanding, 5.7.2

primary extract and delete mappings, working with, 5.7.3

repository

Oracle BI repository, setting up, 14.2

versioned, J

Repository Documentation

generating, 2.5

repository, setting up, 14.2

requests

exposing dashboards and requests, D.3.1

requirements

database, 4.3.4.1

Informatica PowerCenter, 4.3.2

infrastructure, 4.3.1

Java SDK, 4.3.4.5

Oracle BI EE, 4.3.1

Oracle BI SE One, 4.3.1

responsibilities

in Usage Accelerator, 12.3.1.1.2, I.7

S

S_.* tables

indexing, 3.8.3.1

SA System Subject Area

mapping, 3.8.1

schema definitions

transactional database, updating, 4.15.3

SDEINC_RecordExtractStart session fails, probable cause, I.2

security

CME security settings, 6.5.2.3

CME settings, 6.5.2.3

Communications, Media, and Energy Analytics, 6.5.2.3

consumer sector security settings, 6.5.2.2

data-level security, about, 6.6.1

data-level security, implementing, 6.6.2

default security settings, 6.1.3

embedded analytics support for changing positions (Siebel App), 6.5.4

employee/position based security, about, 6.5.1

initialization blocks, 3.8.2

integrating data security with EBS, 6.2

integrating data security with Oracle's PeopleSoft Enterprise Apps, 6.3

metadata object level security (repository groups), about, 6.4, 6.4.1

operational applications security

Oracle Financial Analytics settings, 6.5.2.4

Oracle Partner Analytics security settings, 6.5.2.1

Oracle Pharma Sales Analytics security settings, 6.5.2.5

Oracle's Siebel Usage Accelerator Analytics security settings, 6.5.2.6

primary position based security for CRM vertical applications, about, 6.5.2

security categories, about, 6.1

team based visibility, 6.5.3

team based visibility, DAC metadata, 6.5.3.7

types of security, about, 6.1

user responsibilities, checking, 6.1.1

Web Catalog security, 6.4.1.2

seed data

importing, C.1.1.1

seed data, importing, D.1

server components, installation requirements

T

Task List

installation and configuration, 4.2

Teradata

activating join indexes, A.7.2

avoiding arithmetic overflows, 3.7.1

code page file property, setting, 4.15.1

configuration checklist, Windows, 4.15.5

creating and dropping tables, 4.10.2

data warehouse requirements, 3.7.1

database hints, 3.7.1

general guidelines, 3.7.1

Hosts file, setting up, 4.15.2

terminology

changes in Informatica PowerCenter 8.1.1, 4.3.2

topology

deploying Oracle BI Applications, 4.1

example, 4.1

Transactional database

connection error, I.1

Cost lists, displaying, H.2.4

importing locale seed data, C.1.1.1

translation tables

process of maintaining, C.1

troubleshooting

ETL error, I.2, I.7

ETL failure, 12.3.1.1.2, I.7

general, I

Informatica and data loading issues, I.2

Oracle Business Analytics Warehouse installation, I.1

Unicode, I.3, I.6, I.7

UNIX installation, I.4

W_UAEMP_TMP, I.7

W_UAPOS_TMP, I.7

U

UnApplied Payments

Using in AR Aging calculations, 9.2.5.1.1

Unicode

local seed data, importing, C.1.1.1

metadata strings, externalizing, C.1.2

Oracle BI seed data, updating for non-English locales, C.1.1

string translations, adding for metadata, C.1.3.1

translation tables, process of maintaining, C.1

W_LOCALIZED_STRING_G table, adding custom translations, C.1.3

Web catalog strings, about translating, C.2

Universal Adapter

conformed dimensions, configuring, 5.15

for CRM Analytics, B.1

Oracle BI Supply Chain Analytics, configuring expenses, 8.2.5.4.1

URL

dashboards, configuring for, D.2.14

home page, configuring for, D.2.12

Usage Accelerator

ETL failure, 12.3.1.1.2, I.7

Usage Accelerator Analytics security settings, 6.5.2.6

username

OracleBIAnalyticsApps.rpd, 14

V

verifying schema changes in Oracle's Siebel (CRM) and EBS, 4.15.3.4

versioned Informatica Repository, J

versioned objects

Informatica Repository, J

Vertical applications

indexing for performance, 3.8.3

views, adding to dashboards, D.2.14

virtual IP address

creating, D.2.4

testing, D.2.5

W

W_LOCALIZED_STRING_G table, adding custom translations, C.1.3

W_UAEMP_TMP

ETL errors, I.7

W_UAPOS_TMP

ETL errors, I.7

Web Catalog groups

Analytics applications, security in, 6.4.1.2

Web Catalog strings

about translating, C.2

Web Extension

configuring to work with, D.2.3

virtual IP address, creating, D.2.4

virtual IP address, testing, D.2.5

workflows

error message when executing on the Informatica Server Manager, probable cause, I.2

Server Manager error message, probable cause, I.2