Skip Headers
Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Version 7.9.6

Part Number E14217-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

system preferences
action links
about, D.2.6
testing, D.2.7
alignments dimension, configuring, E.1.3.2.2
ANSI NULL option, setting, 3.4.1

B

browsers
settings, configuring, D.2.10

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, G.1.6
code page
environments, 4.3.3
Communications, Media, and Energy Analytics
predictive scores, developing and deploying, E.1.2
complex products defined, E.1.3.1
configuring, E.1.3.2.3
email recipients in DAC client, 4.14.2
Oracle Business Analytics Warehouse database, 4.12
SSE role, 4.4.1.1
Cost List exceptions
See also exception reports
about and example, G.1.2
Cost lists, using to display, G.2.4
products without a cost list, G.1.3
currency, diagnosing translation issues, G.2.3

D

DAC
configuring server, 4.13
creating ODBC connections, 4.9.4
importing metadata, 4.11.2
installing JDBC drivers, 4.9.3
installing metadata files, 4.10
installing on UNIX, 4.9.2
installing platform, 4.9
logging in, 4.11
setting system properties, 4.14.1, A.3
setting up email notification, 4.17
Source System Parameters, 4.18.1
starting and stopping the server, A.4
starting server, 4.13.4
user account management, A.2
DAC metadata repository
database, 4.4.1
DAC Server
enabling communication with Informatica, A.6
starting and stopping manually, A.4
dashboards
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 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
database connections
transactional, creating, 4.14.3
database connectivity
installing software, 4.4.2
database requirements, 4.4.1
DataMovementMode parameter, 4.3.3
DB Library Options setting, modifying, 3.4.2
DB2 databases
DB2CODEPAGE, 4.4.2.2
environment variable, 4.4.2.2
Oracle Business Analytics Warehouse requirements, 3.2
DB2-UDB
creating stored procedures, 4.18.2
deployment
topology example, 4.1
dimensions
alignments dimension, configuring, E.1.3.2.2
pharmaceuticals, configuring dimensions specific to, E.1.3.3
positions dimension, configuring, E.1.3.2.1
product costs, configuring, E.1.3.2.4
products dimension, configuring, E.1.3.2.3
documentation
Repository Documentation feature, 2.5

E

email
configuring Email in the DAC Server, 4.17.2
environment variables
DB2CODEPAGE, 4.4.2.2
NLS_LANG, 4.4.2.1
ETL
History view, G.2.5
running with Non-English OLTP Data Source, 3.8.6
exception reports
additional exceptions, list of, G.2.6
circular hierarchy exceptions, about and example, G.1.6
cleansing the data, process and diagram, G.2.1
ETL History view, using to view the history of the ETL processes and statuses, G.2.5
exception report components, list of, G
exception, fixing, G.2.1
exchange rate exceptions, about, G.1.4
Exchange Rate view, using to diagnose currency translation issues, G.2.3
executing the report, cleansing steps, G.2
invalid hierarchy exceptions, about, G.1.5
List of Values exceptions, G.1.1
List of Values view, using to compare values with Oracle Business Analytics Warehouse, G.2.2
See also Cost List exceptions
exchange rate exceptions, about, G.1.4
Exchange Rate view, using to diagnose currency issues, G.2.3

H

hierarchical relationships, invalid hierarchy exceptions, about, G.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.8.3

I

indexes
creating to improve performance, 3.8.3
S_.* tables, 3.8.3
Informatica
configuring relational connections, 4.15
creating Integration Service, 4.6.4
creating repository administrator, 4.8.4
creating Repository Service, 4.6.3
domains file, define path, A.5.2
installing Client Tools, 4.6.1
installing pmcmd and pmrep, A.5.1
installing PowerCenter, 4.6
native security domain, 4.8.4
setting Integration Services custom properties, 4.8.3
setting relaxes code page validation, 4.8.2
source and lookup files, 4.8.1
Informatica PowerCenter
requirements, 4.3.2
terminology changes in 8.6, 4.3.2
Informatica repository
database, 4.4.1
restoring, 4.7
restoring for non-English OS, 4.7.2
versioned, H
Informatica Server
registering, 4.14.2
infrastructure requirements, 4.3.1
Initialization Blocks, 3.8.2
installation
database connectivity, 4.9.3
JDBC drivers, 4.9.3
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

JD Edwards
specifying data source connection, 4.14.3.1
JDBC drivers
installation, 4.9.3

L

List of Values
exceptions, about and example, G.1.1
view, using to compare values with the Oracle Business Analytics Warehouse, G.2.2

M

Mappings
SA System Subject Area, 3.8.1
metadata
externalizing strings, C.1.2
Migrating Seed Data from Siebel OLTP Source Systems, 4.18.3.1

N

NLS_LANG environment variable, 4.4.2.1
Non-English OLTP Data Source
running an ETL with, 3.8.6

O

Operational Applications
dashboards, adding views, D.2.14
home page content, customizing, D.2.12
home page path argument, determining, D.2.13
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
initialization blocks, 3.8.2
initialization, completing, D.2
installation and configuration process task list, 4.2
installer, 4.5
operational applications, about integrating within, D.2.8
Optional Analytics Applications, D.2.9
overview, 2.1
roadmap to installing, 2.4
Sales Analytics, turning on options, D.2.9
topologies, 4.1
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
components, 2.3.1
database, 4.4.1
database parameters and requirements, 3.1
database, configuring, 4.12
DB2 requirements, 3.2
general guidelines for setting up, 3.1
Oracle requirements, 3.6
overview, 2.2
SQL server-specific requirements, 3.4
tables, creating, 4.12.1
Teradata requirements, 3.5.2
Oracle databases
NLS_LANG, 4.4.2.1
Oracle EBS
creating custom indexes, 3.8.4
Human Resources performance change capture, 3.8.4.3
Oracle Financial Analytics
logical table sources, updating, E.1.1, E.1.1
updating logical table sources, E.1.1, E.1.1
Oracle's Siebel Industry Applications
alignments dimension, configuring, E.1.3.2.2
Analytics applications, about metadata requirements, E.1.3
dimensions, configuring specific to pharmaceuticals, E.1.3.3
Pharma sales effectiveness, configuring subject area, E.1.3.3.1
product costs dimension, configuring, E.1.3.2.4
Oracle's Siebel Industry applications
alignments dimension, configuring, E.1.3.2.2
Analytics applications, about metadata requirements, E.1.3
dimensions, configuring specific to pharmaceuticals, E.1.3.3
Pharma medical education effectiveness, configuring subject area, E.1.3.3.4
Pharma product categories, configuring subject area, E.1.3.3.2
Pharma promotional effectiveness, configuring subject area, E.1.3.3.3
Pharma Sales Analytics, about metadata requirements, E.1.3.2
Pharma sales effectiveness, configuring subject area, E.1.3.3.1
positions dimension, configuring, E.1.3.2.1
predictive scores, developing and deploying, E.1.2
product costs dimension, configuring, E.1.3.2.4
Oracle's Siebel Operational Applications
integration with
data types, D
integration with Industry Applications, D.1

P

page names, locating and dashboards, D.3.2
parent-child relationship, circular hierarchy exceptions, G.1.6
PeopleSoft Enterprise Applications
creating custom indexes, 3.8.5
PerfIndex_Horizontal.sql, 3.8.3
PerfIndex_Industry.sql, 3.8.3
performance
components configured to optimize performance, 3.4.3
implementing indexes on Oracle sources to improve, 3.8.4
implementing indexes on PeopleSoft sources to improve, 3.8.5
implementing indexes on Siebel sources to improve, 3.8.3
Pharma objectives achievement
configuring subject area, E.1.3.3.5
medical education effectiveness, configuring subject area, E.1.3.3.4
Pharma product categories
configuring subject area, E.1.3.3.2
Pharma promotional effectiveness, configuring subject area, E.1.3.3.3
Pharma Sales Analytics
alignments dimension, configuring, E.1.3.2.2
dimensions, configuring specific to pharmaceuticals, E.1.3.3
medical education effectiveness, configuring subject area, E.1.3.3.4
metadata requirements, about, E.1.3.2
objectives achievement, configuring subject area, E.1.3.3.5
Pharma medical education effectiveness, configuring subject area, E.1.3.3.4
Pharma objectives achievement, configuring subject area, E.1.3.3.5
Pharma product categories, configuring subject area, E.1.3.3.2
Pharma promotional effectiveness, configuring subject area, E.1.3.3.3
Pharma Sales effectiveness, configuring subject area, E.1.3.3.1
positions dimension, configuring, E.1.3.2.1
product categories, configuring subject area, E.1.3.3.2
product costs dimension, configuring, E.1.3.2.4
products dimension, configuring, E.1.3.2.3
promotional effectiveness, configuring subject area, E.1.3.3.3
sales effectiveness, configuring subject area, E.1.3.3.1
Pharma Sales Analytics applications
dimensions, configuring specific to pharmaceuticals, E.1.3.3
metadata requirements, about, E.1.3.2
Pharma medical education effectiveness, configuring subject area, E.1.3.3.4
Pharma objectives achievement, configuring subject area, E.1.3.3.5
Pharma product categories, configuring subject area, E.1.3.3.2
Pharma promotional effectiveness, configuring subject area, E.1.3.3.3
Pharma Sales effectiveness, configuring subject area, E.1.3.3.1
positions dimension, configuring, E.1.3.2.1
product costs dimension, configuring, E.1.3.2.4
products dimension, configuring, E.1.3.2.3
Pharma Sales Analytics, about metadata requirements, E.1.3.2
positions dimension, configuring, E.1.3.2.1
predictive analytics metadata
predictive scores, developing and deploying, E.1.2
predictive scores, developing and deploying, E.1.2
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.1.3.2.4
products dimension, configuring, E.1.3.2.3, E.1.3.2.3

R

repository
versioned, H
Repository Documentation
generating, 2.5
requests
exposing dashboards and requests, D.3.1
requirements
database, 4.4.1
Informatica PowerCenter, 4.3.2
infrastructure, 4.3.1
Oracle BI EE, 4.3.1
Oracle BI SE One, 4.3.1

S

S_.* tables
indexes on, 3.8.3
SA System Subject Area
mapping, 3.8.1
Sales Analytics, turning on options, D.2.9
schema definitions
transactional database, updating, 4.18.3.2
security
initialization blocks, 3.8.2
seed data
importing, C.1.1.1
seed data, importing, D.1
server components, installation requirements
See also server component software
Siebel Applications
creating customer indexes, 3.8.3
mapping for SA System subject area, 3.8.1
setting up metadata, E.1
simple products defined, E.1.3.1
Source System Parameters
about, 4.18.1
setting, 4.18.1
Source System Parameters (also known as DAC ETL Preferences), 4.18.1
SQL Server
DB Library Options setting, modifying, 3.4.2
Oracle Business Analytics Warehouse requirements, 3.4
SSE role
creating, 4.4.1.1
requirements, 4.4.1.1
starting the DAC Server, A.4
stored procedures for DB2-UDB
creating, 4.18.2
string translations
adding for metadata, C.1.3.1
SWE
See Web Extension
system preferences
See also exception reports

T

Task List
installation and configuration, 4.2
Teradata
activating join indexes, 4.13.5
avoiding arithmetic overflows, 3.5.2
code page file property, setting, 4.18.4.1
configuration checklist, Windows, 4.18.4.4
creating and dropping tables, 4.12.2
data warehouse requirements, 3.5.2
database hints, 3.5.2
general guidelines, 3.5.2
Hosts file, setting up, 4.18.4.2
terminology
changes in Informatica PowerCenter 8.6, 4.3.2
topology
deploying Oracle BI Applications, 4.1
example, 4.1
Transactional database
Cost lists, displaying, G.2.4
importing locale seed data, C.1.1.1
translation tables
process of maintaining, C.1

U

Unicode
configuring SiebelUnicodeDB custom property, 4.16
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

V

versioned Informatica repository, H
versioned objects
Informatica repository, H
Vertical applications
creating indexes 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
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
What's New
What's New in This Release, 1.1