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

A

action links

about   1

testing   1

alignments dimension, configuring   1

ANSI NULL option, setting   1

Applications

Oracle BI Applications Consumer   1

Oracle Contact Center Telephony Analytics   1

Oracle Financial Analytics   1

Supply Chain Analytics   1

attributes

historically significant attributes, identifying   1

Back to top

B

browsers

settings, configuring   1

bulkload mode, error while creating a custom session   1

Back to top

C

circular hierarchy exceptions, about and example   1

CME Analytics applications

data requirements   1

security settings   1

CME analytics applications

dashboards and pages   1

data requirements   1

order management analytics, about   1

predictive scores, developing and deploying   1

code lookup

about   1

code mappings   1

codes mapplets   1

IA_CODES table   1

sessions for lookups, configuring   1

complex products defined   1

Configuring

fiscal calendar   1

configuring

DAC client   1 ,  2

DAC config.bat   1 ,  2

DAC metadata repository   1

email recipients in DAC client   1

Oracle Business Analytics Warehouse database   1

SSE role   1

conformed dimensions

universal source, configuring for   1

consumer sector

See Consumer Sector Analytics Security Settings

Cost List exceptions

See also Understanding Oracle Business Analytics Warehouse Exceptions

about and example   1

Cost lists, using to display   1

products without a cost list   1

cross-module configuration, performing

codes lookup   1

conformed dimensions, configuring   1

dimension keys, resolving   1

document, local, and group currencies, working with   1

domain values, working with   1

extracts, configuring   1

loads, configuring   1

Oracle 11i, configuring for   1

records, filtering and deleting   1

slowly changing dimensions, changing   1

stored lookups, configuring   1

currencies

configuring, about   1

document, local, and group currencies, working with   1

European Monetary Union currencies, handling   1

exchange rate type, configuring   1

exchange rates, extracting from a custom table   1

currency, diagnosing translation issues   1

Back to top

D

DAC

Source System Parameters   1

DAC config.bat

configuring   1 ,  2

DAC ETL Preferences   1

DAC metadata repository

configuring   1

dashboards

CME dashboards and pages   1

consumer sector dashboards and pages   1

customizing, about   1

exposing dashboards and requests   1

information, about viewing information   1

locating dashboard and page names   1

views, adding   1

data flow

Online Analytical Processing (OLAP) database, about and diagram   1

data import

syndicated data loading, overview   1

data loading

Oracle's Siebel Analytics for Life Sciences, issues when loading   1

troubleshooting, Informatica and data loading issues   1

data warehouse

architecture   1

database connections   1

overview   1

Data Warehouse Application Console (DAC)

about   1

configuring on UNIX   1

Data Warehouse Application Console (DAC) client

configuring   1 ,  2

Data Warehouse Application Console (DAC) system properties

setting up   1

database connections

transactional, creating   1

database connections, creating

DB2 installations, creating database connections for   1

Oracle installation, creating database connections for   1

data-level security

about   1

implementing   1

DB Library Options setting, modifying   1

DB2

database connections, creating for   1

Oracle Business Analytics Warehouse requirements   1

Oracle Business Analytics Warehouse, cannot connect to   1

DB2 databases

DB2CODEPAGE   1

DB2CODEPAGE environment variable   1

dimension keys

dimension key resolution, using a lookup   1

resolving   1

dimensions

alignments dimension, configuring   1

pharmaceuticals, configuring dimensions specific to   1

positions dimension, configuring   1

product costs, configuring   1

products dimension, configuring   1

domain values

domain value conversion process, understanding   1

domain value set, configuring   1

domain value set, extending   1

importance, understanding   1

working with   1

Back to top

E

eBusiness Applications

See Oracle Partner Analytics Security Settings See Responsibilities and Data-Level Visibility in Sales Analytics Applications

email notification, Outlook error when sending post session email   1

Enterprise Manager, error displayed after installing ODBC driver   1

environment variables

DB2CODEPAGE   1

NLS_LANG   1

setting on UNIX   1

setting up on Windows   1

errors

See Troubleshooting Oracle Business Intelligence Applications

ETL History view, using to view the history of the ETL processes and statuses   1

European Monetary Union currencies

EXP_CURR_CONVERSION_TRANSFORM Expression Transformation, using   1

flat file, using to supply exchange rates   1

handling   1

exception reports

See also Understanding Oracle Business Analytics Warehouse Exceptions

additional exceptions, list of   1

circular hierarchy exceptions, about and example   1

cleansing the data, process and diagram   1

ETL History view, using to view the history of the ETL processes and statuses   1

exception report components, list of   1

exception, fixing   1

exchange rate exceptions, about   1

Exchange Rate view, using to diagnose currency translation issues   1

executing the report, cleansing steps   1

invalid hierarchy exceptions, about   1

List of Values exceptions   1

List of Values view, using to compare values with Oracle Business Analytics Warehouse   1

exchange rate exceptions, about   1

Exchange Rate view, using to diagnose currency issues   1

extracts, configuring

about   1

extracting additional data, about   1

extracting data from new source table   1

extracting new data from existing source table   1

Back to top

F

filters for security groups, about   1

Finance Analytics application

logical table sources, disabling   1

logical table sources, updating   1

metadata translation strings, externalizing   1

Financial Analytics applications

process of configuring Oracle 11i for   1

Fiscal Calendar

configuring   1

setting up   1

fiscal month

configuring   1

fiscal week

configuring   1

Full_Extract_Siebel_DW, error returned by Informatica   1

Full_Load_Siebel_DW

error when running   1

Back to top

H

Healthcare Analytics

security settings   1

hierarchical relationships, invalid hierarchy exceptions, about   1

historically significant attributes

identifying   1

home page

content, customizing   1

customizing, about   1

path argument, determining   1

Horizontal applications

indexing for performance   1

Back to top

I

Incentive Compensation Analytics, turning on   1

indexes

to improve performance   1

Indexing

S_.* tables   1

Informatica

copying source files   1

installing patches on UNIX   1

license files, updating on UNIX   1

lookup files   1

Informatica client software

Enable Data Code Pages Validation, checking if conditions met   1

Informatica patches installation   1

Informatica PowerCenter

installation wizard   1

Informatica repository

configuring   1

configuring in Workflow Manager   1

creating   1

dropping   1

restoring   1

verifying configuration   1

Informatica Repository Server

installing on UNIX   1

registering   1

Informatica Server

installing on other than default location   1

installing on UNIX   1

registering   1

setting up   1

starting   1

starting on UNIX   1

stopping on UNIX   1

Informatica Server and repository, configuring

Unicode mode, configuring under Windows   1

Windows, setting up Informatica service under   1

Initialization Blocks   1

installation

data warehouse installation and configuration process   1

database connectivity   1

Informatica patches   1

Informatica PowerCenter   1

Informatica Server, installing on other than default directory   1

Java SDK   1 ,  2

Java SDK and drivers   1

JDBC drivers   1

Oracle BI Applications installation process task list   1

wizard, Oracle BI Applications   1

installing

Oracle BI repository, setting up   1

Insurance Analytics family of products

security settings   1

IP address

virtual IP address, creating   1

virtual IP address, testing   1

Back to top

J

Java SDK

installation   1 ,  2

JDBC drivers

installation   1

Back to top

L

language packs

installing   1

licensing

product licensing   1

List of Values

exceptions, about and example   1

view, using to compare values with the Oracle Business Analytics Warehouse   1

loads, configuring

about   1

Source Adapter mapplet. creating   1

localization packs

installing   1

Back to top

M

Mappings

SA System Subject Area   1

metadata object level security

repository groups   1

Web Catalog groups   1

Web Catalog security   1

metadata strings

externalizing   1

metadata, Siebel Industry applications

Analytics applications, about metadata requirements   1

CME dashboards and pages   1

CME data requirements   1

consumer sector dashboards and pages   1

consumer sector data requirements   1

dimensions, configuring specific to pharmaceuticals   1

Finance Analytics applications, disabling logical table sources   1

Finance Analytics applications, externalizing metadata translation strings   1

Finance Analytics applications, updating logical table sources   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales Analytics, about metadata requirements   1

Pharma sales effectiveness, configuring subject area   1

positions dimension, configuring   1

predictive scores, developing and deploying   1

product costs dimension, configuring   1

products dimension, configuring   1

metadata,Siebel Industry applications

alignments dimension, configuring   1

Microsoft Outlook

closes when finishing ETL process, probable cause   1

error when sending post session email   1

Back to top

N

NLS_LANG environment variable   1

Back to top

O

OLAP

 1

Online Analytical Processing database

about   1

Data Warehouse, data flow into   1

Online Transaction Processing database

Online Analytical Processing database, differences from   1

OPB_OBJECT_LOCKS Informatica session deadlocked, probable cause   1

Oracle

database connections, creating for   1

mappings hang, probable cause   1

Oracle Business Analytics Warehouse requirements   1

Oracle 11i

Customers Dimension table, mapping source customer hierarchies to   1

group currency code, configuring   1

last extract date, modifying   1

Oracle Flex fields, incorporating   1

Order Management and Fulfillment, configuring for   1

process of configuring Financial Analytics applications for   1

process of configuring Supply Chain Analytics for   1

product categories, configuring   1

Source ID, modifying   1

Oracle BI

repository, setting up   1

Oracle BI Applications

initialization, completing   1

installation and configuration process task list   1

installation process   1

installation wizard   1

installing, UNIX   1

UNIX, deploying   1

Oracle BI Applications, configuring

action links, about   1

action links, testing   1

browser settings, configuring   1

dashboards, adding views   1

home page and dashboards, about customizing   1

home page content, customizing   1

home page, determining path argument   1

Incentive Compensation Analytics, turning on   1

optional Siebel Analytics applications, accessing   1

Oracle BI Applications, completing initialization   1

process   1

Siebel operational applications, about integrating within   1

Siebel Web Extension, configuring to work with   1

virtual IP address, creating   1

virtual IP address, testing   1

Oracle BI Charts

metadata strings, externalizing   1

Oracle BI seed data, updating for non-English locales   1

Oracle BI Presentation layer

process of maintaining translation tables   1

Oracle BI repository

externalizing metadata strings   1

repository groups, security   1

table joins, configuring   1

Oracle BI seed data

updating for non-English locales   1

Oracle BI Supply Chain Analytics   1

domain values and CSV worksheet files   1

process of aggregating tables for   1

process of configuring universal source for   1

universal source, configuring expenses   1

Oracle Business Analytics Warehouse

architecture   1

architecture components   1

database parameters and requirements   1

database, configuring   1

DB2 requirements   1

deployment configuration   1

operating system, driver, connectivity requirements   1

Oracle Business Analytics Warehouse, differences from   1

Oracle requirements   1

overview   1

SQL server-specific requirements   1

tables, creating   1

Teradata requirements   1

Oracle Contact Center Telephony Analytics

Benchmarks and Targets table, setting up   1

Contact Representative Snapshot table, setting up   1

Contact Status Type columns, about configuring for   1

dates and times, configuring   1

dimension key resolution   1

dimension table, loading   1

Event Type columns, about configuring for   1

fact table, loading   1

overview   1

Representative Activities table, setting up   1

Oracle databases

NLS_LANG   1

Oracle Human Resources Analytics

domain values and CSV worksheet files   1

overview   1

Payroll table, about aggregating   1

Payroll table, aggregating   1

Workforce Operations, about configuring for Oracle 11i   1

Workforce Operations, process of configuring for Oracle 11i   1

Workforce Payroll, process of configuring for Oracle 11i   1

Oracle Order Management and Fulfillment Analytics Option   1

Oracle Partner Analytics

role-based analytics dashboard mapping   1

Oracle Pharma Sales Analytics applications

security settings   1

Oracle's Siebel Industry Applications

Oracle Pharma Sales Analytics security settings   1

Oracle's Siebel Financial Services security settings   1

Siebel Usage Accelerator Analytics security settings   1

Oracle's Siebel Life Sciences

data loading issues   1

Oracle's Siebel Operational Applications

Oracle Partner Analytics security settings   1

Oracle's Siebel Operational Applications, integration with

Oracle's Siebel Industry   1

order management analytics, about   1

Order Management and Fulfillment Analytics

Oracle 11i, process of configuring for   1

Outlook

closes when finishing ETL process, probable cause   1

error when sending post session email   1

Back to top

P

page names, locating and dashboards   1

parent-child relationship, circular hierarchy exceptions   1

PeopleSoft Trees   1

PerfIndex_Horizontal.sql   1

PerfIndex_Industry.sql   1

performance

components configured to optimize performance   1

implementing indexes to improve   1

Pharma

medical education effectiveness, configuring subject area   1

objectives achievement, configuring subject area   1

product categories, configuring subject area   1

promotional effectiveness, configuring subject area   1

sales effectiveness, configuring subject area   1

Pharma Sales Analytics

alignments dimension, configuring   1

dimensions, configuring specific to pharmaceuticals   1

metadata requirements, about   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales effectiveness, configuring subject area   1

positions dimension, configuring   1

product costs dimension, configuring   1

products dimension, configuring   1

security settings   1

positions dimension, configuring   1

predictive analytics metadata

predictive scores, developing and deploying   1

Presentation Catalog, administering

dashboards, about viewing information   1

dashboards, exposing and requests   1

dashboards, locating and page names   1

primary extract and delete mapping

delete and primary extract sessions, enabling   1

source-archived records, deletion configuration   1

working with   1

product costs dimension, configuring   1

product licensing   1

products dimension, configuring   1

Back to top

Q

Query Analyzer, can not open after installing ODBC driver   1

Back to top

R

RDBMS error message, probable cause   1

records

source-archived records, deletion configuration   1

records, filtering and deleting

about   1

primary extract and delete mappings, understanding   1

primary extract and delete mappings, working with   1

Refresh_Extract_Siebel_DW

error returned by Informatica   1

repository

Oracle BI repository, setting up   1

requests

exposing dashboards and requests   1

responsibilities

access in Oracle BI   1

integrated security, about   1

user responsibilities, checking   1

user responsibilities, registering new responsibility   1

Back to top

S

S_.* tables

indexing   1

S_MSG table, adding custom translations   1

SA System Subject Area

mapping   1

schema definitions

transactional database, updating   1

SDEINC_RecordExtractStart session fails, probable cause   1

Security

initialization blocks   1

security

CME security settings   1

consumer sector security settings   1

data-level security, about   1

data-level security, implementing   1

default security settings   1

filters for security groups, about   1

Finance Analytics security settings   1

metadata object level security (repository groups), about   1

operational applications security   1 ,  2

Oracle Partner Analytics security settings   1

Oracle Pharma Sales Analytics security settings   1

Oracle's Siebel Usage Accelerator Analytics security settings   1

repository table joins, configuring   1

responsibilities and access in Oracle Business Intelligence   1

responsibilities, integrated security for   1

security levels, about   1

Siebel Sales Analytics security settings   1

user responsibilities, checking   1

user responsibilities, registering new responsibility   1

Web Catalog security   1

seed data

importing   1

server components, installation requirements

See also General Guidelines for Setting Up Oracle Business Analytics Warehouse

Oracle Business Analytics Warehouse, about   1

setting up

DAC system properties   1

Siebel Analytics Charts

local seed data, importing   1

localization packs, installing   1

S_MSG table, adding custom translations   1

string translations, adding for metadata   1

translation tables, process of maintaining   1

Web catalog strings, about translating   1

Siebel Analytics repository

repository groups, security   1

Siebel CME Analytics applications

predictive scores, developing and deploying   1

Siebel Communications, Media, and Energy Analytics

See Communications, Media, and Energy (CME) Analytics Security Settings

Siebel Consumer Sector Analytics applications

consumer sector dashboards and pages   1

consumer sector data requirements   1

security settings   1

Siebel Enterprise Contact Center Analytics

configuring flags for   1

excluding representative data   1

Siebel Enterprise Sales Analytics

currency and quantity grain   1

multiple products, about tracking   1

overview   1

Sales Order Dates, about   1

Siebel Enterprise Workforce Analytics

domain values and CSV worksheet files, configuring   1

Siebel Finance Analytics applications

logical table sources, disabling   1

logical table sources, updating   1

metadata translation strings, externalizing   1

security settings   1

Siebel Financial Analytics

overview,   1

PeopleSoft Trees   1

Siebel Industry Applications

alignments dimension, configuring   1

Analytics applications, about metadata requirements   1

CME dashboards and   1

CME data requirements   1

CME security settings   1

consumer sector dashboards and pages   1

consumer sector data requirements   1

consumer sector security settings   1

dimensions, configuring specific to pharmaceuticals   1

Finance Analytics applications, disabling logical table sources   1

Finance Analytics applications, externalizing metadata translation strings   1

Finance Analytics applications, updating logical table sources   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales Analytics, about metadata requirements   1

Pharma sales effectiveness, configuring subject area   1

positions dimension, configuring   1

predictive scores, developing and deploying   1

product costs dimension, configuring   1

products dimension, configuring   1

seed data, importing   1

Siebel Operational Applications

dashboards, adding views   1

home page content, customizing   1

home page path argument, determining   1

security   1 ,  2

Siebel Analytics, about integrating within   1

Siebel Sales Analytics security settings   1

Siebel Operational Applications, integration with

data types   1

Siebel Pharma Sales Analytics applications

dimensions, configuring specific to pharmaceuticals   1

metadata requirements, about   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales effectiveness, configuring subject area   1

positions dimension, configuring   1

product costs dimension, configuring   1

products dimension, configuring   1

Siebel PRM Analytics

data-level visibility   1

portal-based analytics dashboard mapping   1

subject area mapping   1

subject area visibility   1

Siebel Sales Analytics

responsibilities and data-level visibility   1

Siebel Transaction Database

connection error   1

Cost lists, displaying   1

Siebel Transactional database

importing locale seed data   1

Siebel Web Extension

configuring to work with   1

virtual IP address, creating   1

virtual IP address, testing   1

SIF files

verifying SIF patch   1

simple products defined   1

slowly changing dimensions, configuring

about   1

currencies, configuring   1

effective dates   1

historically significant attributes, identifying   1

Type I changing dimension   1

Type II slowly changing dimension   1

Source Adapter mapplet

creating   1

Source System Parameters

about   1

setting   1

source-archived records

deletion configuration   1

SQL Server

DB Library Options setting, modifying   1

Oracle Business Analytics Warehouse requirements   1

SSE role

creating   1

stored lookups

configuring   1

stored procedures

creating   1

string translations

adding for metadata   1

Supply Chain Analytics

process of configuring Oracle 11i for   1

SWE

See Process of Configuring Oracle Business Intelligence with Oracle's Siebel Web Extension (SWE)

syndicated data

importing, overview   1

system preferences

See also Understanding Oracle Business Analytics Warehouse Exceptions

Back to top

T

Teradata

activating join indexes   1

avoiding arithmetic overflows   1

code page file property, setting   1

configuration checklist, Windows   1

creating and dropping tables   1

data warehouse requirements   1

database hints   1

general guidelines   1

Hosts file, setting up   1

installation checklist for UNIX   1

installing patches on UNIX   1

setting up Hosts file on UNIX   1

translation tables

process of maintaining   1

troubleshooting

Informatica and data loading issues   1

Oracle Business Analytics Warehouse installation   1

Unicode   1 ,  2

UNIX installation   1

Back to top

U

Unicode

deploying Informatica and Oracle Business Analytics Warehouse in   1

local seed data, importing   1

localization pack, installing   1

metadata strings, externalizing   1

Oracle BI seed data, updating for non-English locales   1

S_MSG table, adding custom translations   1

string translations, adding for metadata   1

translation tables, process of maintaining   1

Web catalog strings, about translating   1

Unicode mode

Windows, configuring under   1

universal source

conformed dimensions, configuring   1

Oracle BI Supply Chain Analytics, configuring expenses   1

process of configuring Oracle BI Supply Chain Analytics for   1

UNIX

deploying Oracle BI Applications   1

updating license files   1

URL

dashboards, configuring for   1

home page, configuring for   1

Usage Accelerator Analytics security settings   1

user responsibilities

checking   1

new responsibility, registering   1

Back to top

V

Vertical applications

indexing for performance   1

views, adding to dashboards   1

virtual IP address

creating   1

testing   1

Back to top

W

Web Catalog groups

Siebel Analytics applications, security in   1

Web Catalog strings

about translating   1

Windows

Informatica Server, setting up under   1

Unicode mode, configuring under Windows   1

workflows

error message when executing on the Informatica Server Manager, probable cause   1

Server Manager error message, probable cause   1

Back to top