Index

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

A

system preferences

action links

about, C.2.6

alignments dimension, configuring, D.1.3.2.2

ANSI NULL option, setting, 3.7.1

B

binary sorting, 3.4.2

C

calendars

enabling Init Blocks, 4.16.3

Catalog Manager

using, 2.5

charts

local seed data, importing, B.1.1.2

translation tables, process of maintaining, B.1

W_LOCALIZED_STRING_G table, adding custom translations, B.1.3

Web catalog strings, about translating, B.2

circular hierarchy exceptions, about and example, E.1.6

code page

environments, 4.3.3

Communications, Media, and Energy Analytics

predictive scores, developing and deploying, D.1.2

complex products defined, D.1.3.1

configuring, D.1.3.2.3

email recipients in DAC client, 4.12.2

SSE role, 4.5.1.1

connections

setting up repository, 4.16

Cost List exceptions

D

DAC

DAC Server shell scripts, A.6

DAC Server, setting environment variables on UNIX, A.5.2

DAC Server, setting environment variables on Windows, A.5.1

importing metadata, 4.9.3

installing JDBC drivers, 4.8.4

installing metadata files, 4.8.7

installing on UNIX, 4.8.3

installing platform, 4.8

logging in, 4.9

Source System Parameters, 4.19.2

starting and stopping the server, A.3

starting server, 4.11.3

user account management, A.2

DAC metadata repository

database, 4.5.1

DAC Server

enabling communication with Informatica, A.5

starting and stopping manually, A.3

DAC_HOME

definition, 4.2.1

dashboards

customizing, about, C.2.8

exposing dashboards and requests, C.3.1

information, about viewing information, C.3

locating dashboard and page names, C.3.2

viewing a list of, 2.5

views, adding, C.2.8.3

data movement mode, 4.3.3

data warehouse

database connections, 4.12.3

database

ORA-00942 error, 3.4.2

database connections

transactional, creating, 4.12.3

database connectivity

installing software, 4.5.2.1

database guidelines

IBM DB2 UDB databases, 3.5

IBM DB2 UDB zOS databases, 3.6

Oracle Business Analytics Warehouse databases, 3.1.2

Oracle databases, 3.4

SQL Server databases, 3.7

Teradata databases, 3.8

transactional databases, 3.1.1

database requirements, 4.5.1

DataMovementMode parameter, 4.3.3

DB Library Options setting, modifying, 3.7.2

DB2 databases

DB2CODEPAGE, 4.5.2.3

environment variable, 4.5.2.3

Oracle Business Analytics Warehouse requirements, 3.5

DB2-UDB

creating stored procedures, 4.19.3

deployment

topology example, 4.2

dimensions

alignments dimension, configuring, D.1.3.2.2

pharmaceuticals, configuring dimensions specific to, D.1.3.3

positions dimension, configuring, D.1.3.2.1

product costs, configuring, D.1.3.2.4

products dimension, configuring, D.1.3.2.3

documentation

Repository Documentation feature, 2.5

E

configuring Email in the DAC Server, 4.15.2

EnterpriseBusinessAnalytics.zip

extracting, 4.17

environment variables

DB2CODEPAGE, 4.5.2.3

NLS_LANG, 4.5.2.2

ETL

History view, E.2.5

improve performance using partitioning, 3.2

running with Non-English OLTP Data Source, 3.3.5

exception reports

additional exceptions, list of, E.2.6

circular hierarchy exceptions, about and example, E.1.6

cleansing the data, process and diagram, E.2.1

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

exception report components, list of, E

exception, fixing, E.2.1

exchange rate exceptions, about, E.1.4

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

executing the report, cleansing steps, E.2

invalid hierarchy exceptions, about, E.1.5

List of Values exceptions, E.1.1

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

F

fiscal calendars

Init Blocks required for, 4.16.3

H

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

high-level task list for installation and setup, 4.4

home page

content, customizing, C.2.8.1

customizing, about, C.2.8

path argument, determining, C.2.8.2

Horizontal applications

creating indexes for performance, 3.3.3

I

indexes

creating to improve performance, 3.3.3

S_.* tables, 3.3.3

INFA_HOME

definition, 4.2.1, 4.2.1

Informatica

creating repository administrator, 4.7.6.5

creating Repository Service, 4.7.3, 4.7.4

deploying with JDE World, JDE E1, 4.7

domains file, define path, A.4.1

installing Client Tools, 4.7.1

logging into PowerCenter Administration Console, A.7

native security domain, 4.7.6.5

pmrep and pmcmd, verify use with DAC Client, A.4.2

setting Integration Services custom properties, 4.7.6.4

setting relaxes code page validation, 4.7.6.3

source and lookup files, 4.7.6.2

Informatica PowerCenter

deploying with JDE World, JDE E1, 4.7

requirements, 4.3.2

terminology changes in 8.6, 4.3.2

Informatica PowerCenter home

definition, 4.2.1, 4.2.1

Informatica repository

database, 4.5.1

restoring, 4.7.5

restoring for non-English OS, 4.7.5.2

versioned, F

Informatica Server

registering, 4.12.2

infrastructure requirements, 4.3.1

Initialization Blocks

enabling for multi-calendar, 4.16.3

initialization blocks

using with Oracle BI Applications, 3.3.2

installation

database connectivity, 4.8.4

JDBC drivers, 4.8.4

Oracle BI Applications installation process task list, 4.4

installation and configuration

task list, 4.4

installation and setup

roadmap, 4.4

where to start, 4.4

installer

non-English platforms, 4.6, A.8

installer errors

troubleshooting, 4.4

installing

Oracle BI repository, setting up, 4.16

IP address

virtual IP address, creating, C.2.4

virtual IP address, testing, C.2.5

J

JD Edwards

specifying data source connection, 4.12.3.1

JDBC drivers

installation, 4.8.4

JDE World, JDE E1

deploying with Informatica PowerCenter, 4.7

L

large fact tables

partitioning, 3.2

List of Values

exceptions, about and example, E.1.1

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

M

Mappings

SA System Subject Area, 3.3.1

metadata

configuring for Oracle BI Applications, D

externalizing strings, B.1.2

MW_HOME

definition, 4.2.1

N

NLS_LANG environment variable, 4.5.2.2

NLS_LENGTH_SEMANTICS

defining BYTE or CHAR length semantics, 3.4.1

Non-English OLTP Data Source

running an ETL with, 3.3.5

non-English platforms

installing in, 4.6, A.8

nQSError 43059

enabling Init Blocks, 4.16.3

nQSError-16002

workaround, 4.16.3

O

OLAPTBO

session variable, 4.16.3

Operational Applications

dashboards, adding views, C.2.8.3

home page content, customizing, C.2.8.1

home page path argument, determining, C.2.8.2

ORA-00942

avoiding this error, 3.4.2

ORA-00942 errors

workaround for, 3.4.2

Oracle BI Administration Tool

password, 4.17

using to generate Repository Documentation, 2.5

Oracle BI Applications

action links, about, C.2.6

completing initialization, C.2

dashboards, adding views, C.2.8.3

home page and dashboards, about customizing, C.2.8

home page content, customizing, C.2.8.1

initialization blocks, 3.3.2

initialization, completing, C.2

installation and configuration process task list, 4.4

installer, 4.3.1

Optional Analytics Applications, C.2.7

overview, 2.1

roadmap to installing, 2.4

Sales Analytics, turning on options, C.2.7

topologies, 4.2

uninstalling, 4.6

virtual IP address, creating, C.2.4

Web Extension, configuring to work with, C.2.3

Oracle BI Applications, configuring

home page, determining path argument, C.2.8.2

virtual IP address, testing, C.2.5

Oracle BI Charts

metadata strings, externalizing, B.1.2

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

Oracle BI EE

requirements, 4.3.1

Oracle BI Presentation layer

process of maintaining translation tables, B.1

Oracle BI repository

externalizing metadata strings, B.1.2

Oracle BI SE One

requirements, 4.3.1

Oracle BI seed data

updating for non-English locales, B.1.1

Oracle Business Analytics Warehouse

architecture components, 2.3.1

components, 2.3.1

database, 4.5.1

database guidelines, 3.1.2

database parameters and requirements, 3.1

DB2 requirements, 3.5

Oracle requirements, 3.4.1

overview, 2.2

SQL server-specific requirements, 3.7

Teradata requirements, 3.8.2

Oracle database

configuring with *.ora files, 3.4.1

NLS_LENGTH_SEMANTICS, 3.4.1

ORA-00942 error, 3.4.2

Oracle Databases

binary sorting, 3.4.2

Oracle databases

general guidelines, 3.4.1

NLS_LANG, 4.5.2.2

optimizing performance, 3.4.2

Oracle EBS

creating custom indexes, 3.3.4

Oracle Financial Analytics

enabling Init Blocks for multi-calendar, 4.16.3

logical table sources, updating, D.1.1, D.1.1

updating logical table sources, D.1.1, D.1.1

Oracle Middleware Home

definition, 4.2.1

Oracle parameter template files

configuring, 3.4.1

Oracle's Siebel Industry Applications

alignments dimension, configuring, D.1.3.2.2

Analytics applications, about metadata requirements, D.1.3

dimensions, configuring specific to pharmaceuticals, D.1.3.3

Pharma sales effectiveness, configuring subject area, D.1.3.3.1

product costs dimension, configuring, D.1.3.2.4

Oracle's Siebel Industry applications

alignments dimension, configuring, D.1.3.2.2

Analytics applications, about metadata requirements, D.1.3

dimensions, configuring specific to pharmaceuticals, D.1.3.3

Pharma medical education effectiveness, configuring subject area, D.1.3.3.4

Pharma product categories, configuring subject area, D.1.3.3.2

Pharma promotional effectiveness, configuring subject area, D.1.3.3.3

Pharma Sales Analytics, about metadata requirements, D.1.3.2

Pharma sales effectiveness, configuring subject area, D.1.3.3.1

positions dimension, configuring, D.1.3.2.1

predictive scores, developing and deploying, D.1.2

product costs dimension, configuring, D.1.3.2.4

Oracle's Siebel Operational Applications

integration with

data types, C

integration with Industry Applications, C.1

ORACLE_HOME

definition, 4.2.1

ORACLE_INSTANCE

definition, 4.2.1

OracleBIAnalyticsApps.rpd

OOTB password, 4.17

password, 4.17

P

page names, locating and dashboards, C.3.2

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

partitioning, 3.2

Partitioning Guidelines, 3.2

password

for RPD, 4.17

OOTB p/w for OracleBIAnalyticsApps.rpd, 4.17

Oracle BI Administration Tool, 4.17

PerfIndex_Horizontal.sql, 3.3.3

PerfIndex_Industry.sql, 3.3.3

performance

components configured to optimize performance, 3.7.3

implementing indexes on Oracle sources to improve, 3.3.4

implementing indexes on Siebel sources to improve, 3.3.3

partitioning large fact tables, 3.2

Pharma objectives achievement

configuring subject area, D.1.3.3.5

medical education effectiveness, configuring subject area, D.1.3.3.4

Pharma product categories

configuring subject area, D.1.3.3.2

Pharma promotional effectiveness, configuring subject area, D.1.3.3.3

Pharma Sales Analytics

alignments dimension, configuring, D.1.3.2.2

dimensions, configuring specific to pharmaceuticals, D.1.3.3

medical education effectiveness, configuring subject area, D.1.3.3.4

metadata requirements, about, D.1.3.2

objectives achievement, configuring subject area, D.1.3.3.5

Pharma medical education effectiveness, configuring subject area, D.1.3.3.4

Pharma objectives achievement, configuring subject area, D.1.3.3.5

Pharma product categories, configuring subject area, D.1.3.3.2

Pharma promotional effectiveness, configuring subject area, D.1.3.3.3

Pharma Sales effectiveness, configuring subject area, D.1.3.3.1

positions dimension, configuring, D.1.3.2.1

product categories, configuring subject area, D.1.3.3.2

product costs dimension, configuring, D.1.3.2.4

products dimension, configuring, D.1.3.2.3

promotional effectiveness, configuring subject area, D.1.3.3.3

sales effectiveness, configuring subject area, D.1.3.3.1

Pharma Sales Analytics applications

dimensions, configuring specific to pharmaceuticals, D.1.3.3

metadata requirements, about, D.1.3.2

Pharma medical education effectiveness, configuring subject area, D.1.3.3.4

Pharma objectives achievement, configuring subject area, D.1.3.3.5

Pharma product categories, configuring subject area, D.1.3.3.2

Pharma promotional effectiveness, configuring subject area, D.1.3.3.3

Pharma Sales effectiveness, configuring subject area, D.1.3.3.1

positions dimension, configuring, D.1.3.2.1

product costs dimension, configuring, D.1.3.2.4

products dimension, configuring, D.1.3.2.3

Pharma Sales Analytics, about metadata requirements, D.1.3.2

positions dimension, configuring, D.1.3.2.1

predictive analytics metadata

predictive scores, developing and deploying, D.1.2

Presentation Catalog, 2.5

viewing, 2.5

Presentation Catalog for BI Apps

installing, 4.17

Presentation Catalog, administering

dashboards, about viewing information, C.3

dashboards, exposing and requests, C.3.1

dashboards, locating and page names, C.3.2

product costs dimension, configuring, D.1.3.2.4

products dimension, configuring, D.1.3.2.3, D.1.3.2.3

Q

query performance

improve using partitioning, 3.2

R

repository

Oracle BI repository, setting up, 4.16

setting up connections, 4.16

versioned, F

Repository Documentation

generating, 2.5

repository password for RPD file, 4.17

requests

exposing dashboards and requests, C.3.1

requirements

database, 4.5.1

Informatica PowerCenter, 4.3.2

infrastructure, 4.3.1

Oracle BI EE, 4.3.1

Oracle BI SE One, 4.3.1

roadmap

installation and setup, 4.4

RPD

password, 4.17

S

S_.* tables

indexes on, 3.3.3

SA System Subject Area

mapping, 3.3.1

Sales Analytics, turning on options, C.2.7

schema definitions

transactional database, updating, 4.19.4.1

security

enabling Init Blocks, 4.16.3

initialization blocks, 3.3.2

seed data

importing, B.1.1.2

seed data, importing, C.1

Siebel Applications

creating customer indexes, 3.3.3

mapping for SA System subject area, 3.3.1

reapplying customized style sheets, C.2.2

setting up metadata, D.1

viewing dashboards, C.2

Siebel Industry Applications

importing seed data, C.1

Siebel Web Extension

configuring, C.2.3

creating virtual IP address, C.2.4

testing virtual IP configuration, C.2.5

SiebelUnicodeDB

requirement for setting property, 4.3.3

simple products defined, D.1.3.1

sorting

binary, 3.4.2

Source System Parameters

about, 4.19.2

setting, 4.19.2

Source System Parameters (also known as DAC ETL Preferences), 4.19.2

SQL Server

DB Library Options setting, modifying, 3.7.2

OLAPTBO session variable, 4.16.3

Oracle Business Analytics Warehouse requirements, 3.7

recommended database parameter settings, 3.7.3

SSE role

creating, 4.5.1.1

requirements, 4.5.1.1

starting the DAC Server, A.3

stored procedures for DB2-UDB

creating, 4.19.3

string translations

adding for metadata, B.1.3.1

SWSE

See Siebel Web Server Extension

system preferences

T

Task List

installation and configuration, 4.4

Teradata

avoiding arithmetic overflows, 3.8.2

best practices for deployments, 3.8.3

code page file property, setting, 4.19.5.1

configuration checklist, Windows, 4.19.5.4

data warehouse requirements, 3.8.2

database hints, 3.8.2

general guidelines, 3.8.2

Hosts file, setting up, 4.19.5.2

JDBC driver requirement, 3.8.1

LEFT OUTER JOIN issue, 3.8.3.2

terminology

changes in Informatica PowerCenter 8.6, 4.3.2

topology

deploying Oracle BI Applications, 4.2

example, 4.2

Transactional database

Cost lists, displaying, E.2.4

importing locale seed data, B.1.1.2

translation tables

process of maintaining, B.1

troubleshoot installer error, 4.4

U

Unicode

configuring SiebelUnicodeDB custom property, 4.14

local seed data, importing, B.1.1.2

metadata strings, externalizing, B.1.2

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

string translations, adding for metadata, B.1.3.1

translation tables, process of maintaining, B.1

W_LOCALIZED_STRING_G table, adding custom translations, B.1.3

Web catalog strings, about translating, B.2

uninstalling Oracle BI Applications, 4.6

URL

dashboards, configuring for, C.2.8.3

home page, configuring for, C.2.8.1

V

versioned Informatica repository, F

versioned objects

Informatica repository, F

Vertical applications

creating indexes for performance, 3.3.3

views, adding to dashboards, C.2.8.3

virtual IP address

creating, C.2.4

testing, C.2.5

W

W_LOCALIZED_STRING_G table, adding custom translations, B.1.3

Web Catalog strings

about translating, B.2

Web Extension

configuring to work with, C.2.3

virtual IP address, creating, C.2.4

virtual IP address, testing, C.2.5

What's New

What's New in This Release, 1.1