Index

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

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.5.1

B

browsers

settings, configuring, D.2.10

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

C

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

complex products defined, E.6.3

configuring, E.6.6.3

DAC client, 4.3.4.5

DAC metadata repository, A.8

email recipients in DAC client, 4.14.2

Oracle Business Analytics Warehouse database, 4.11

SSE role, 4.3.4.1.1

Contact Center Telephony Analytics

dashboards and pages, E.6.1

data requirements, E.6.2

Cost List exceptions

D

DAC

configuring metadata repository, A.8

Source System Parameters, 4.18.1

starting and stopping the server, A.3

DAC metadata repository

database, 4.3.4.1

DAC Server

starting and stopping manually, A.3

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 warehouse

database connections, 4.14.3

Data Warehouse Administration Console (DAC)

configuring on UNIX, A.7

configuring the client, 4.3.4.5

setting up system properties, A.8.1

database connections

transactional, creating, 4.14.3

database requirements, 4.3.4.1

DataMovementMode parameter, 4.3.3

DB Library Options setting, modifying, 3.5.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.18.2

deployment

topology example, 4.1

dimensions

alignments dimension, configuring, E.6.6.2

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

E

configuring Email in the DAC Server, 4.17.2

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.10

index errors, I.7

running with Non-English OLTP Data Source, 3.9.5

troubleshooting, I.7

ETL failure, I.7

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

H

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

home page

content, customizing, D.2.12

customizing, about, D.2.11

path argument, determining, D.2.13

Horizontal applications

creating indexes for performance, 3.9.3

I

Incentive Compensation Analytics, turning on, D.2.9

indexes

creating to improve performance, 3.9.3

S_.* tables, 3.9.3

Informatica

default passwords, 4.5.1

fatal errors 11, I.2

fatal errors 3644-1 or 360454, I.2

Informatica PowerCenter

requirements, 4.3.2

terminology changes in 8.1.1, 4.3.2

Informatica repository

database, 4.3.4.1

dropping, A.6

versioned, J

Informatica Server

password, 4.5.1

registering, 4.14.2

infrastructure requirements, 4.3.1

Initialization Blocks, 3.9.2

installation

database connectivity, 4.9.2

Java SDK, 4.3.4.5

JDBC drivers, 4.9.2

Oracle BI Applications installation process task list, 4.2

installation and configuration

task list, 4.2

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.9.2

L

large fact tables

partitioning, 3.10

List of Values

exceptions, about and example, H.1.1

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

M

Mappings

SA System Subject Area, 3.9.1

metadata

externalizing strings, C.1.2

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.18.3.1

N

NLS_LANG environment variable, 4.3.4.2.1

Non-English OLTP Data Source

running an ETL with, 3.9.5

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

Oracle BI SE One

requirements, 4.3.1

Oracle BI seed data

updating for non-English locales, C.1.1

Oracle Business Analytics Warehouse

architecture components, 2.3.1

database, 4.3.4.1

database parameters and requirements, 3.2

database, configuring, 4.11

DB2 requirements, 3.3

operating system, driver, connectivity requirements, 3.1

Oracle requirements, 3.7

SQL server-specific requirements, 3.5

tables, creating, 4.11.1

Teradata requirements, 3.6.2

Oracle databases

NLS_LANG, 4.3.4.2.1

Oracle Financial Analytics

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

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

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

consumer sector dashboards and pages, E.6.1

consumer sector data requirements, E.6.2

dimensions, configuring specific to pharmaceuticals, E.6.7

Pharma sales effectiveness, configuring subject area, E.6.7.1

product costs dimension, configuring, E.6.6.4

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

order management analytics, about, E.6.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.10

password

Informatica administrator, 4.5.1

PerfIndex_Horizontal.sql, 3.9.3

PerfIndex_Industry.sql, 3.9.3

performance

components configured to optimize performance, 3.5.3

implementing indexes on Oracle sources to improve, 3.9.4

implementing indexes on Siebel sources to improve, 3.9.3

partitioning large fact tables, 3.10

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

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

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.10

R

RDBMS error message, probable cause, I.2

repository

versioned, J

Repository Documentation

generating, 2.5

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, I.7

S

S_.* tables

indexes on, 3.9.3

SA System Subject Area

mapping, 3.9.1

schema definitions

transactional database, updating, 4.18.3.2

SDEINC_RecordExtractStart session fails, probable cause, I.2

security

initialization blocks, 3.9.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.8.2

avoiding arithmetic overflows, 3.6.2

code page file property, setting, 4.18.4.1

configuration checklist, Windows, 4.18.4.4

creating and dropping tables, 4.11.2

data warehouse requirements, 3.6.2

database hints, 3.6.2

general guidelines, 3.6.2

Hosts file, setting up, 4.18.4.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, 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

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

for CRM Analytics, B.1

URL

dashboards, configuring for, D.2.14

home page, configuring for, D.2.12

Usage Accelerator

ETL failure, I.7

V

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

versioned Informatica repository, J

versioned objects

Informatica repository, J

Vertical applications

creating indexes for performance, 3.9.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 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