Oracle Business Intelligence Enterprise Edition System Administrator's Guide

560 Pages·2010·8.23 MB·English

by  Oracle Corporation

Oracle® Fusion Middleware
System Administrator's Guide for Oracle Business Intelligence
Enterprise Edition
11g Release 1 (11.1.1)
E10541-01
July 2010
Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition,
11g Release 1 (11.1.1)
E10541-01
Copyright © 2010, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical data"
pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As
such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and
license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of
the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software
License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not
developed or intended for use in any inherently dangerous applications, including applications which may
create a risk of personal injury. If you use this software in dangerous applications, then you shall be
responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use
of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of
this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.
This software and documentation may provide access to or information on content, products, and services
from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all
warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and
its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of
third-party content, products, or services.
Contents
Preface............................................................................................................................................................. xxiii
Audience................................................................................................................................................... xxiii
Documentation Accessibility................................................................................................................. xxiii
Related Documents................................................................................................................................. xxiv
Conventions............................................................................................................................................. xxiv
New Features for Oracle Business Intelligence System Administrators .............. xxv
New Features........................................................................................................................................... xxv
Upgrade Considerations........................................................................................................................ xxvi
Part I Administering Oracle Business Intelligence
1 Introduction to Oracle Business Intelligence System Administration
1.1 What are the Oracle Business Intelligence System Administration Tasks?....................... 1-1
1.2 Getting Started with Managing Oracle Business Intelligence.............................................. 1-2
1.3 What is the Oracle Business Intelligence System Logical Architecture?............................ 1-3
1.4 About Oracle BI Java Components and System Components............................................. 1-5
1.5 What is the Administration Server?......................................................................................... 1-6
1.6 What System Administration Tools are Available for Managing Oracle Business
Intelligence?................................................................................................................................. 1-7
1.6.1 Fusion Middleware Control - Monitor, Manage, and Configure Oracle Business
Intelligence System Components...................................................................................... 1-7
1.6.2 Oracle WebLogic Server Administration Console - Monitor and Manage Oracle
Business Intelligence JEE Java Components.................................................................... 1-7
1.6.3 Oracle Process Manager and Notification Server (OPMN) Tool - Manage Oracle
Business Intelligence System Components (for advanced users)................................. 1-8
1.6.4 Oracle Weblogic Scripting Tool (WLST) - Programmatically Administer Oracle
Business Intelligence........................................................................................................... 1-8
1.6.5 Oracle BI Administration Tool - Manage the Metadata Repository............................ 1-9
1.7 Topics of Interest in Other Guides........................................................................................... 1-9
1.8 System Requirements and Certification.................................................................................. 1-9
2 Managing Oracle Business Intelligence
2.1 Why Use Fusion Middleware Control and WebLogic Server Administration Console? 2-1
iii
2.2 Centrally Managing Oracle Business Intelligence Components Using Fusion
Middleware Control................................................................................................................... 2-2
2.2.1 Logging into Fusion Middleware Control to Manage Oracle Business Intelligence. 2-2
2.2.2 Using Fusion Middleware Control to Manage Oracle Business Intelligence System
Components 2-4
2.2.3 Using Fusion Middleware Control to Monitor Status and Start and Stop Oracle
Business Intelligence Java Components........................................................................... 2-5
2.2.4 About the Navigation Tree in Fusion Middleware Control.......................................... 2-6
2.3 Centrally Managing Oracle Business Intelligence Java Components Using the Oracle
WebLogic Server Administration Console.............................................................................. 2-7
2.4 Managing Oracle Business Intelligence JMX MBeans Using the Fusion Middleware
Control MBean Browser............................................................................................................. 2-9
2.4.1 What is the Fusion Middleware Control MBean Browser?........................................... 2-9
2.4.2 Displaying the Fusion Middleware Control MBean Browser.................................... 2-10
3 Configuring the Oracle Business Intelligence System
3.1 Configuring Oracle Business Intelligence............................................................................... 3-1
3.2 Using Fusion Middleware Control to Update Oracle Business Intelligence
Configuration Settings .............................................................................................................. 3-2
3.3 Using the Oracle BI Systems Management API to Update Oracle Business Intelligence
Configuration Settings............................................................................................................... 3-3
3.4 Using a Text Editor to Update Oracle Business Intelligence Configuration Settings....... 3-3
3.5 Using the Fusion Middleware Control MBean Browser to Update Configuration
Settings......................................................................................................................................... 3-4
3.6 Where are Configuration Files Located?................................................................................. 3-5
Part II Managing Processes and Components
4 Starting and Stopping Oracle Business Intelligence
4.1 About Starting and Stopping Oracle Business Intelligence.................................................. 4-1
4.2 Starting the Oracle Business Intelligence System................................................................... 4-2
4.3 Using Fusion Middleware Control to Start and Stop Oracle Business Intelligence
System Components and Java Components........................................................................... 4-3
4.4 Using Oracle WebLogic Server Administration Console to Start and Stop
Java Components........................................................................................................................ 4-5
4.5 Alternative Methods For Starting and Stopping Oracle Business Intelligence System
Components................................................................................................................................. 4-6
4.5.1 Using the OPMN Command Line to Start, Stop, Restart, and View the Status of
Oracle Business Intelligence System Components......................................................... 4-6
4.5.2 Using a Windows Service to Start and Stop Oracle Business Intelligence System
Components ......................................................................................................................... 4-8
4.5.3 Configuring OPMN to Start and Stop Oracle Business Intelligence System
Components Automatically on Linux.............................................................................. 4-9
4.5.4 Using the Oracle BI Systems Management API to Programmatically Start and Stop
Oracle Business Intelligence............................................................................................... 4-9
4.6 Confirming Whether the Administration Server is Running............................................... 4-9
4.7 Starting and Stopping the Administration Server and all Oracle Business Intelligence
Java Components on Windows and UNIX.......................................................................... 4-10
4.8 Confirming Whether the Managed Server is Running, and Starting it if Necessary..... 4-11
iv
4.9 Starting and Stopping Managed Servers on Windows and UNIX................................... 4-12
4.10 Troubleshooting System Startup........................................................................................... 4-13
4.10.1 The Administration Server Fails to Start When the Database is Not Running....... 4-13
4.10.2 The Managed Server is Down......................................................................................... 4-14
4.10.3 The Oracle BI Server Fails to Start.................................................................................. 4-14
4.10.4 Oracle BI Presentation Services Fails to Start............................................................... 4-14
4.10.5 Unable to Log On.............................................................................................................. 4-14
Part III Scaling and Deploying for High Availability and Performance
5 Scaling Your Deployment
5.1 About Scaling Oracle Business Intelligence............................................................................ 5-1
5.1.1 How Do I Know When to Scale Out Processes?.............................................................. 5-2
5.1.2 What Processes Should I Scale?......................................................................................... 5-2
5.2 Vertically Scaling Oracle Business Intelligence...................................................................... 5-3
5.3 Horizontally Scaling Oracle Business Intelligence................................................................. 5-3
5.4 Setting Up Shared Files and Directories.................................................................................. 5-4
5.4.1 Uploading and Sharing the Oracle BI Repository.......................................................... 5-4
5.4.2 Sharing the Oracle BI Presentation Catalog..................................................................... 5-4
5.4.3 Setting Up the Global Cache.............................................................................................. 5-5
5.4.4 Setting the Scheduler Script Path and Default Script Path............................................ 5-5
5.5 Using Fusion Middleware Control to Scale System Components....................................... 5-6
5.6 Validating That Your System Has Been Scaled Correctly.................................................... 5-7
5.6.1 Using Fusion Middleware Control to View System Component Availability........... 5-7
5.6.2 Using the Administration Console to View Managed Server Availability................. 5-8
6 Deploying Oracle Business Intelligence for High Availability
6.1 About Oracle Business Intelligence Components in a Clustered Environment................ 6-2
6.1.1 Recommendations for Availability................................................................................... 6-3
6.1.2 Using Fusion Middleware Control to Identify Single Points of Failure...................... 6-3
6.2 Configuring Oracle Business Intelligence Components for High Availability................. 6-4
6.2.1 Using Fusion Middleware Control to Configure Primary and Secondary Instances 6-4
6.3 How Do Oracle Business Intelligence Components Provide Availability?....................... 6-6
6.3.1 About the Cluster Controller............................................................................................. 6-6
6.3.1.1 What if the Cluster Controller Fails?......................................................................... 6-6
6.3.2 About Clustered Oracle BI Servers and the Master BI Server....................................... 6-7
6.3.2.1 What if a Clustered Oracle BI Server Fails?.............................................................. 6-7
6.3.2.2 What if the Master BI Server Fails?............................................................................ 6-8
6.3.3 About Clustered Oracle BI Scheduler Instances............................................................. 6-8
6.3.3.1 What if an Oracle BI Scheduler Instance Fails?........................................................ 6-9
6.3.4 About the Oracle BI Cluster Server................................................................................... 6-9
6.3.4.1 About the Startup Process for the Cluster Server.................................................... 6-9
6.3.4.2 Performance Considerations for the Cluster Server............................................. 6-11
6.3.5 About Clustered Presentation Services Instances........................................................ 6-11
6.3.5.1 What if a Presentation Services Instance Fails?..................................................... 6-12
6.3.6 About Clustered JavaHost Instances............................................................................. 6-12
v
6.3.7 About Web Tier Components......................................................................................... 6-13
6.4 Optional Configuration for Oracle Business Intelligence High Availability.................. 6-13
6.4.1 Setting Optional Cluster Controller Parameters.......................................................... 6-13
6.4.2 Setting Optional Presentation Services Parameters..................................................... 6-14
6.4.3 Setting Optional Oracle BI Presentation Services Plug-in Parameters..................... 6-15
6.5 Using the Cluster Manager..................................................................................................... 6-15
6.5.1 Viewing and Managing Cluster Information............................................................... 6-16
6.5.1.1 Status Information..................................................................................................... 6-16
6.5.1.2 Cache Information..................................................................................................... 6-18
6.5.1.3 Session Information................................................................................................... 6-18
6.5.1.4 Server Information.................................................................................................... 6-20
6.6 Troubleshooting an Oracle Business Intelligence Clustered Environment..................... 6-20
6.6.1 Avoiding Errors with Network Appliance Devices when the Oracle BI Server is
Running on Linux or UNIX............................................................................................. 6-20
7 Managing Performance Tuning and Query Caching
7.1 Monitoring Service Levels......................................................................................................... 7-1
7.1.1 Using Fusion Middleware Control to View Common Performance Metrics............. 7-2
7.1.2 Using Fusion Middleware Control to View All Oracle Business Intelligence
Metrics................................................................................................................................... 7-2
7.1.3 Using the Administration Console to View Metrics for Java Components................ 7-3
7.2 About Query Performance Tuning........................................................................................... 7-3
7.3 Setting Performance Parameters in Fusion Middleware Control........................................ 7-4
7.3.1 Using Fusion Middleware Control to Disallow RPD Updates..................................... 7-5
7.3.2 Using Fusion Middleware Control to Set the User Session Log-Off Period............... 7-5
7.3.3 Using Fusion Middleware Control to Set Configuration Options for Data in
Tables and Pivot Tables...................................................................................................... 7-6
7.3.4 Using Fusion Middleware Control to Set the Maximum Number of Rows
Processed to Render a Table............................................................................................... 7-6
7.4 About the Oracle BI Server Query Cache................................................................................ 7-7
7.4.1 Query Cache Architecture.................................................................................................. 7-8
7.4.2 Advantages of Caching....................................................................................................... 7-8
7.4.3 Costs of Caching.................................................................................................................. 7-9
7.4.3.1 Disk Space...................................................................................................................... 7-9
7.4.3.2 Administrative Tasks................................................................................................... 7-9
7.4.3.3 Keeping the Cache Up To Date.................................................................................. 7-9
7.4.3.4 CPU Usage and Disk I/O......................................................................................... 7-10
7.4.4 Cache Sharing Across Users............................................................................................ 7-10
7.4.5 About the Refresh Interval for XML Data Sources...................................................... 7-10
7.4.6 About the Global Cache................................................................................................... 7-11
7.5 Configuring Query Caching................................................................................................... 7-12
7.5.1 Using Fusion Middleware Control to Enable and Disable Query Caching............. 7-12
7.5.2 Using Fusion Middleware Control to Set Query Cache Parameters......................... 7-13
7.5.3 Manually Editing Additional Query Cache Parameters............................................. 7-14
7.5.4 Using Fusion Middleware Control to Set Global Cache Parameters........................ 7-14
7.5.5 Manually Editing Additional Global Cache Parameters............................................ 7-15
7.6 Monitoring and Managing the Cache................................................................................... 7-15
7.6.1 Choosing a Cache Management Strategy..................................................................... 7-15
vi
7.6.1.1 Disable Caching for the System............................................................................... 7-15
7.6.1.2 Caching and Cache Persistence Timing for Specified Physical Tables.............. 7-16
7.6.1.3 Configure Oracle BI Server Event Polling Tables................................................. 7-16
7.6.2 Purging and Maintaining Cache Using ODBC Procedures........................................ 7-16
7.6.2.1 About ODBC Procedure Syntax.............................................................................. 7-17
7.6.2.2 About Sharing the Presentation Services Query Cache....................................... 7-17
7.6.2.3 About Result Records............................................................................................... 7-18
7.6.2.4 Storing and Purging Cache for SAP/BW Data Sources....................................... 7-18
7.6.3 How Repository Changes Affect the Query Cache..................................................... 7-19
7.6.3.1 Online Mode............................................................................................................... 7-20
7.6.3.2 Offline Mode.............................................................................................................. 7-20
7.6.3.3 Switching Between Repositories............................................................................. 7-20
7.6.3.4 Changes to Dynamic Repository Variables........................................................... 7-20
7.7 Strategies for Using the Cache............................................................................................... 7-20
7.7.1 About Cache Hits.............................................................................................................. 7-21
7.7.1.1 Ensuring Correct Cache Results When Using Row-Level Database Security.. 7-23
7.7.2 Running a Suite of Queries to Populate the Cache...................................................... 7-24
7.7.3 Using Agents to Seed the Oracle BI Server Cache....................................................... 7-25
7.7.4 Using the Cache Manager................................................................................................ 7-25
7.7.4.1 Displaying Global Cache Information in the Cache Manager............................ 7-26
7.7.4.2 Purging Cache in the Administration Tool............................................................ 7-27
7.8 Cache Event Processing with an Event Polling Table........................................................ 7-28
7.8.1 Setting Up Event Polling Tables on the Physical Databases...................................... 7-29
7.8.1.1 Polling Table Structure............................................................................................. 7-29
7.8.1.2 Sample Event Polling Table CREATE TABLE Statements.................................. 7-31
7.8.2 Making the Event Polling Table Active......................................................................... 7-32
7.8.3 Populating the Oracle BI Server Event Polling Table.................................................. 7-32
7.8.4 Troubleshooting Problems with Event Polling Tables................................................ 7-33
7.9 Managing the Oracle BI Presentation Services Cache Settings......................................... 7-33
7.10 Improving Oracle BI Web Client Performance.................................................................... 7-35
7.10.1 Setting Up Static File Caching......................................................................................... 7-35
7.10.1.1 Setting Up Static File Caching for Microsoft IIS Server....................................... 7-35
7.10.1.2 Setting Up Static File Caching for Oracle HTTP Server/Apache HTTP Server 7-35
7.10.2 Bypassing Static Files....................................................................................................... 7-36
Part IV Resolving Issues
8 Diagnosing and Resolving Issues in Oracle Business Intelligence
8.1 Viewing And Configuring Diagnostic Log Files.................................................................... 8-1
8.1.1 Using Fusion Middleware Control to View Log Information, Error Messages,
and Alerts.............................................................................................................................. 8-2
8.1.2 Configuring Log File Rotation Policy and Specifying Log Levels............................... 8-3
8.1.2.1 Using Fusion Middleware Control to Configure Log File Rotation Policy and
Specify Log Levels........................................................................................................ 8-3
8.1.2.2 Manually Changing Additional Log File Settings................................................... 8-4
8.2 Understanding Diagnostic Log and Log Configuration Files.............................................. 8-5
8.2.1 What Are Diagnostic Log Files and Where are They Located?.................................... 8-5
vii
8.2.2 What Are Diagnostic Log Configuration Files and Where are They Located?.......... 8-6
8.2.3 What Are Log File Message Categories and Levels?...................................................... 8-8
8.2.4 What is Log File Rotation?.................................................................................................. 8-9
8.3 Managing the Query Log........................................................................................................... 8-9
8.3.1 Configuring Query Logging........................................................................................... 8-10
8.3.1.1 Setting the Query Logging Level............................................................................ 8-10
8.3.1.2 Setting the Query Logging Level for a User.......................................................... 8-12
8.3.2 Using the Log Viewer....................................................................................................... 8-12
8.3.2.1 Interpreting the Log Records................................................................................... 8-13
8.4 Logging in Oracle BI Presentation Services......................................................................... 8-14
8.4.1 Using the Oracle BI Presentation Services Logging Facility...................................... 8-14
8.4.2 Structure for the Oracle BI Presentation Services Configuration File....................... 8-14
8.4.2.1 Examples of the Formats of Logged Messages..................................................... 8-18
8.4.3 Oracle BI Presentation Services Message Structure..................................................... 8-19
8.4.4 Oracle BI Presentation Services Log Filters.................................................................. 8-19
8.4.5 Diagnosing Issues with the Agents................................................................................ 8-20
9 Managing Usage Tracking
9.1 Setting Up Usage Tracking........................................................................................................ 9-1
9.1.1 Setting Up Direct Insertion to Collect Information for Usage Tracking...................... 9-2
9.1.2 Setting Up a Log File to Collect Information for Usage Tracking................................ 9-3
9.1.2.1 Selecting an Output Location..................................................................................... 9-3
9.1.2.2 File Naming Conventions........................................................................................... 9-4
9.1.2.3 Output File Format....................................................................................................... 9-4
9.1.2.4 Performance Considerations....................................................................................... 9-6
9.2 Description of the Usage Tracking Data.................................................................................. 9-6
Part V Configuring Oracle Business Intelligence
10 Configuring Repositories
10.1 Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI
Presentation Catalog Location............................................................................................... 10-1
10.2 Understanding Repository Version Numbers..................................................................... 10-2
10.3 Using the System MBeans to Publish the Metadata Repository....................................... 10-3
11 Configuring Connections to External Systems
11.1 Configuring E-Mail and Agents............................................................................................ 11-1
11.1.1 Using Fusion Middleware Control to Configure Oracle BI Scheduler E-mail
Settings That Affect Agents............................................................................................. 11-1
11.2 Configuring for Actions with the Action Framework........................................................ 11-2
11.3 Configuring for Connections to the Marketing Content Server....................................... 11-2
11.3.1 Using Fusion Middleware Control to Configure the Connection to the Marketing
Content Server................................................................................................................... 11-3
11.3.2 Manually Editing Settings for the Marketing Content Server Connection.............. 11-3
11.4 Configuring to Download Oracle Hyperion Smart View for Office................................ 11-4
viii
12 Configuring Presentation Setting Defaults
12.1 Using Fusion Middleware Control to Change Presentation Setting Defaults................ 12-1
13 Configuring Mapping and Spatial Information
13.1 What are the System Requirements for Map Views?......................................................... 13-1
13.1.1 Hardware Sizing and Deployment Strategy for Maps................................................ 13-2
13.2 Administering Maps................................................................................................................ 13-2
13.2.1 Working with Maps and Layers..................................................................................... 13-2
13.2.1.1 Associating Layers with Columns.......................................................................... 13-3
13.2.1.2 Ordering Layers on Maps........................................................................................ 13-3
13.2.2 Administration Page Functions...................................................................................... 13-5
13.2.3 Administering Maps........................................................................................................ 13-5
14 Configuring Oracle Scorecard and Strategy Management
14.1 Enabling Comments and Status Overrides in Oracle Scorecard and Strategy Management..
14-1
15 Configuring Time Zones
15.1 Where Time Zones Are Used................................................................................................. 15-1
15.2 Setting Time Zones.................................................................................................................. 15-2
15.3 Precedence Order for Time Zones......................................................................................... 15-2
15.3.1 User-Preferred Time Zone............................................................................................... 15-3
15.4 Where Time Zone Specifications Are Stored....................................................................... 15-3
15.4.1 Specifying Time Zone Values......................................................................................... 15-3
15.5 Description of Time Zone Settings........................................................................................ 15-4
15.6 Example: Configuration File Settings for Specifying the Time Zone............................... 15-5
16 Localizing Oracle Business Intelligence
16.1 What is Localization?.............................................................................................................. 16-1
16.1.1 What Components are Translated?................................................................................ 16-1
16.1.2 How Do I Localize Oracle Business Intelligence Components?................................ 16-2
16.2 Localizing Oracle BI Presentation Services.......................................................................... 16-3
16.2.1 Localizing the User Interface for Oracle BI Presentation Services............................ 16-3
16.2.1.1 Understanding the Directory Structure for Localizing Oracle BI Presentation
Services........................................................................................................................ 16-3
16.2.1.2 Localizing Messages for Users' Preferred Currency............................................ 16-4
16.2.1.3 Specifying the Default Language for the Sign-in Page........................................ 16-4
16.2.1.4 Specifying the Language in the URL...................................................................... 16-5
16.2.2 Localizing Oracle BI Presentation Catalog Captions................................................... 16-6
16.2.3 Tip for Arabic and Hebrew in Mozilla Firefox Browsers........................................... 16-9
16.2.4 Handling the Translation of Layers in Maps................................................................ 16-9
16.3 Setting the Current Locale in the Oracle BI Server............................................................. 16-9
16.3.1 Setting Locale Parameters on Oracle BI Server............................................................ 16-9
16.3.1.1 Setting the Locale on UNIX Systems.................................................................... 16-10
16.3.2 Understanding How the Error Message Language is Determined......................... 16-11
ix
16.3.3 Troubleshooting the Current Locale in the Oracle BI Server................................... 16-11
16.3.3.1 Handling the NLS Locale Not Supported Error Message................................. 16-11
16.3.3.2 Setting the Japanese Locale on AIX Systems....................................................... 16-12
16.4 Localizing Metadata Names in the Repository................................................................. 16-12
16.5 Supporting Multilingual Data.............................................................................................. 16-14
16.5.1 What is Multilingual Data Support?............................................................................ 16-14
16.5.2 What is Lookup?............................................................................................................. 16-15
16.5.3 What is Double Column Support?............................................................................... 16-15
16.5.4 Designing Translation Lookup Tables in a Multilingual Schema........................... 16-15
16.5.4.1 A Lookup Table for Each Base Table.................................................................... 16-15
16.5.4.2 A Lookup Table for Each Translated Field.......................................................... 16-16
16.5.5 Creating Logical Lookup Tables and Logical Lookup Columns............................. 16-16
16.5.5.1 Creating Logical Lookup Tables........................................................................... 16-16
16.5.5.2 Designating a Logical Table as a Lookup Table.................................................. 16-18
16.5.5.3 About the LOOKUP Function Syntax.................................................................. 16-18
16.5.5.4 Creating Logical Lookup Columns....................................................................... 16-19
16.5.6 Creating Physical Lookup Tables and Physical Lookup Columns......................... 16-20
16.5.7 Supporting Multilingual Data in Essbase Through Alias Tables............................ 16-22
16.5.8 Enabling Lexicographical Sorting................................................................................ 16-22
17 Configuring Currency Options
17.1 Changing the Default Currency for Analyses..................................................................... 17-1
17.2 Defining User-Preferred Currency Options......................................................................... 17-2
17.2.1 Defining User-Preferred Currency Options Using a Static Mapping....................... 17-3
17.2.2 Example: Static Mapping to Define User-Preferred Currency Options................... 17-4
17.2.3 Defining User-Preferred Currency Options Using a Dynamic Mapping................. 17-4
17.2.4 Example: Dynamic Mapping to Define User-Preferred Currency Options............. 17-5
18 Configuring and Managing the Oracle BI Presentation Catalog
18.1 About the Oracle BI Presentation Catalog........................................................................... 18-1
18.2 About Catalog Manager.......................................................................................................... 18-2
18.2.1 Uses for Catalog Manager............................................................................................... 18-2
18.2.2 Guidelines for Working with Catalog Manager........................................................... 18-2
18.2.3 Tips for Working with Catalog Manager...................................................................... 18-3
18.3 Maintaining the Oracle BI Presentation Catalog................................................................. 18-3
18.3.1 Manually Changing Additional Configuration Settings for the Catalog................. 18-3
18.3.2 Manually Creating a New Oracle BI Presentation Catalog ....................................... 18-4
18.3.3 Deploying a Catalog Object to Production................................................................... 18-4
18.4 Starting Catalog Manager and Opening Catalogs.............................................................. 18-5
18.4.1 Starting Catalog Manager................................................................................................ 18-5
18.4.2 Understanding the Two Catalog Modes ...................................................................... 18-5
18.4.3 Operations Available in Online Mode and Offline Mode.......................................... 18-6
18.4.4 Opening an Oracle BI Presentation Catalog................................................................. 18-7
18.5 Using the Catalog Manager Workspace............................................................................... 18-7
18.5.1 What Does the Catalog Manager Workspace Do?....................................................... 18-8
18.5.2 What Does the Catalog Manager Workspace Look Like?.......................................... 18-8
18.5.3 Managing the View of the Catalog Manager Workspace........................................... 18-9
x