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