Skip Headers
Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Release 7.9.6.3

Part Number E19038-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
PDF · Mobi · ePub

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

B

binary sorting, 3.7

C

calendars
enabling Init Blocks, 4.15.3
Catalog Manager
using, 2.5
charts
local seed data, importing, B.1.1.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
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.11.2
Oracle Business Analytics Warehouse database, 4.9
SSE role, 4.4.1.1
connections
setting up repository, 4.15
Cost List exceptions
See also exception reports
about and example, E.1.2
Cost lists, using to display, E.2.4
products without a cost list, E.1.3
currency, diagnosing translation issues, E.2.3

D

DAC
configuring server, 4.10
creating ODBC connections, 4.7.4
DAC Server shell scripts, A.7
DAC Server, setting environment variables on UNIX, A.6.2
DAC Server, setting environment variables on Windows, A.6.1
importing metadata, 4.8.2
installing JDBC drivers, 4.7.3
installing metadata files, 4.7.6
installing on UNIX, 4.7.2
installing platform, 4.7
logging in, 4.8
setting system properties, 4.11.1, A.3
setting up email notification, 4.14
Source System Parameters, 4.18.2
starting and stopping the server, A.4
starting server, 4.10.3
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
DAC_HOME
definition, 4.1.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.11.3
database
ORA-00942 error, 3.7
database connections
transactional, creating, 4.11.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.3
deployment
topology example, 4.1
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

email
configuring Email in the DAC Server, 4.14.2
EnterpriseBusinessAnalytics.zip
extracting, 4.16
environment variables
DB2CODEPAGE, 4.4.2.2
NLS_LANG, 4.4.2.1
ETL
History view, E.2.5
improve performance using partitioning, 3.8
running with Non-English OLTP Data Source, 3.9.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
See also Cost List exceptions
exchange rate exceptions, about, E.1.4
Exchange Rate view, using to diagnose currency issues, E.2.3

F

fiscal calendars
Init Blocks required for, 4.15.3

H

hierarchical relationships, invalid hierarchy exceptions, about, E.1.5
high-level task list for installation and setup, 4.2
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.9.3

I

indexes
creating to improve performance, 3.9.3
S_.* tables, 3.9.3
INFA_HOME
definition, 4.1.1, 4.1.1
Informatica
configuring relational connections, 4.12
creating repository administrator, 4.6.6.5
creating Repository Service, 4.6.3, 4.6.4
deploying with JDE World, JDE E1, 4.6
domains file, define path, A.5.1
installing Client Tools, 4.6.1
installing PowerCenter, 4.6
logging into PowerCenter Administration Console, A.8
native security domain, 4.6.6.5
pmrep and pmcmd, verify use with DAC Client, A.5.2
setting Integration Services custom properties, 4.6.6.4
setting relaxes code page validation, 4.6.6.3
source and lookup files, 4.6.6.2
Informatica PowerCenter
deploying with JDE World, JDE E1, 4.6
requirements, 4.3.2
terminology changes in 8.6, 4.3.2
Informatica PowerCenter home
definition, 4.1.1, 4.1.1
Informatica repository
database, 4.4.1
restoring, 4.6.5
restoring for non-English OS, 4.6.5.2
versioned, F
Informatica Server
registering, 4.11.2
infrastructure requirements, 4.3.1
Initialization Blocks
enabling for multi-calendar, 4.15.3
initialization blocks
using with Oracle BI Applications, 3.9.2
installation
database connectivity, 4.7.3
JDBC drivers, 4.7.3
Oracle BI Applications installation process task list, 4.2
installation and configuration
task list, 4.2
installation and setup
roadmap, 4.2
where to start, 4.2
installer
non-English platforms, 4.5
installer errors
troubleshooting, 4.2
installing
Oracle BI repository, setting up, 4.15
IP address
virtual IP address, creating, C.2.4
virtual IP address, testing, C.2.5

J

JD Edwards
specifying data source connection, 4.11.3.1
JDBC drivers
installation, 4.7.3
JDE World, JDE E1
deploying with Informatica PowerCenter, 4.6

L

large fact tables
partitioning, 3.8
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.9.1
metadata
configuring for Oracle BI Applications, D
externalizing strings, B.1.2
MW_HOME
definition, 4.1.1

N

NLS_LANG environment variable, 4.4.2.1
Non-English OLTP Data Source
running an ETL with, 3.9.5
non-English platforms
installing in, 4.5
nQSError 43059
enabling Init Blocks, 4.15.3
nQSError-16002
workaround, 4.15.3

O

OLAPTBO
session variable, 4.15.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.7
ORA-00942 errors
workaround for, 3.7
Oracle BI Administration Tool
password, 4.16
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.9.2
initialization, completing, C.2
installation and configuration process task list, 4.2
installer, 4.3.1
Optional Analytics Applications, C.2.7
overview, 2.1
preinstallation tasks, 4.4
roadmap to installing, 2.4
Sales Analytics, turning on options, C.2.7
topologies, 4.1
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.4.1
database parameters and requirements, 3.1
database, configuring, 4.9
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.9.1
Teradata requirements, 3.5.2
Oracle database
ORA-00942 error, 3.7
Oracle Databases
binary sorting, 3.7
Oracle databases
general guidelines, 3.6
NLS_LANG, 4.4.2.1
optimizing performance, 3.7
Oracle EBS
creating custom indexes, 3.9.4
Oracle Financial Analytics
enabling Init Blocks for multi-calendar, 4.15.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.1.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.1.1
ORACLE_INSTANCE
definition, 4.1.1
OracleBIAnalyticsApps.rpd
OOTB password, 4.16
password, 4.16

P

page names, locating and dashboards, C.3.2
parent-child relationship, circular hierarchy exceptions, E.1.6
Partitioning
setting up DAC to Support Partitioned Tables, 3.8.3
partitioning, 3.8
Partitioning Guidelines, 3.8
Partitioning Large Fact Tables, 3.8.2
password
for RPD, 4.16
OOTB p/w for OracleBIAnalyticsApps.rpd, 4.16
Oracle BI Administration Tool, 4.16
PerfIndex_Horizontal.sql, 3.9.3
PerfIndex_Industry.sql, 3.9.3
performance
components configured to optimize performance, 3.4.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.8
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
predictive scores, developing and deploying, D.1.2
Presentation Catalog, 2.5
viewing, 2.5
Presentation Catalog for BI Apps
installing, 4.16
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.8

R

repository
Oracle BI repository, setting up, 4.15
setting up connections, 4.15
versioned, F
Repository Documentation
generating, 2.5
repository password for RPD file, 4.16
requests
exposing dashboards and requests, C.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
roadmap
installation and setup, 4.2
RPD
password, 4.16

S

S_.* tables
indexes on, 3.9.3
SA System Subject Area
mapping, 3.9.1
Sales Analytics, turning on options, C.2.7
schema definitions
transactional database, updating, 4.18.4.1
security
enabling Init Blocks, 4.15.3
initialization blocks, 3.9.2
seed data
importing, B.1.1.1
seed data, importing, C.1
server components, installation requirements
See also server component software
Siebel Applications
creating customer indexes, 3.9.3
mapping for SA System subject area, 3.9.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.7
Source System Parameters
about, 4.18.2
setting, 4.18.2
Source System Parameters (also known as DAC ETL Preferences), 4.18.2
SQL Server
DB Library Options setting, modifying, 3.4.2
OLAPTBO session variable, 4.15.3
Oracle Business Analytics Warehouse requirements, 3.4
recommended database parameter settings, 3.4.3
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.3
string translations
adding for metadata, B.1.3.1
SWSE
See Siebel Web Server Extension
system preferences
See also exception reports

T

Task List
installation and configuration, 4.2
Teradata
activating join indexes, 4.10.4
avoiding arithmetic overflows, 3.5.2
best practices for deployments, 3.5.3
code page file property, setting, 4.18.5.1
configuration checklist, Windows, 4.18.5.4
creating and dropping tables, 4.9.2
data warehouse requirements, 3.5.2
database hints, 3.5.2
general guidelines, 3.5.2
Hosts file, setting up, 4.18.5.2
JDBC driver requirement, 3.5.1
LEFT OUTER JOIN issue, 3.5.3.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, E.2.4
importing locale seed data, B.1.1.1
translation tables
process of maintaining, B.1
troubleshoot installer error, 4.2

U

Unicode
configuring SiebelUnicodeDB custom property, 4.13
local seed data, importing, B.1.1.1
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
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.9.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