Oracle Business Intelligence Enterprise Edition consists of components that were formerly available from Siebel Systems as Siebel Business Analytics Platform, with a number of significant enhancements.

The Oracle Business Intelligence Server Administration Guide is part of the documentation set for Oracle Business Intelligence Enterprise Edition. This guide contains information about setting up the Oracle Business Intelligence Server. This guide contains new material and material that was previously published under the title Siebel Business Analytics Server Administration Guide.

Oracle recommends reading the Oracle Business Intelligence Enterprise Edition Release Notes before installing, using, or upgrading the Oracle BI Infrastructure. The Oracle Business Intelligence Enterprise Edition Release Notes are available:

  • On the Oracle Business Intelligence Enterprise Edition CD-ROM.
  • On the Oracle Technology Network at http://www.oracle.com/technology/documentation/bi_ee.html (to register for a free account on the Oracle Technology Network, go to http://www.oracle.com/technology/about/index.html).

What's New in Oracle Business Intelligence Server Administration Guide, Version 10.1.3.2

Table 1 lists changes described in this version of the documentation to support Release 10.1.3.2 of the software. These changes include the name of this guide and many of the products.

Table 1. Changed Features and Information in Oracle Business Intelligence Server Administration Guide, Version 10.1.3.2
Topic
Description

Menus in the Administration Tool

Updated menu items to reflect changes to product names and changed functionality.

Keyboard Shortcuts in the Administration Tool

Added new shortcuts.

Icons and Symbols in the Administration Tool

Added new icons for physical cube hierarchy types, opaque views, and aggregate objects.

Features and Options for Oracle's Siebel Marketing Application

Added topic.

Checking the Consistency of a Repository or a Business Model

Rewrote topic to describe the new Consistency Check Manager.

Using the Options Dialog Box—General Tab

Updated Calculation Wizard information, added import repository option, and removed options for Time Series Wizard and Merge repository mismatch warning.

Using the Options Dialog Box—Multiuser Tab

Added information about new tab.

Populating Logical Level Counts Automatically

Added topic.

Process of Creating the Physical Layer from Multidimensional Data Sources

Updated section to include support for SAP/BW and new versions of Microsoft Analysis Services.

Importing a Physical Schema from Multidimensional Data Sources

Updated the steps to import objects to include support for SAP/BW.

Creating a Database Object Manually in the Physical Layer

Added field needed to create a database using a virtual private database as a source.

Creating or Changing Connection Pools

Updated general properties for setting up connection pools for all data sources.

Setting Up Connection Pool Properties for Multidimensional Data Sources

Updated general properties for setting up connection pools.

About Physical Tables

Updated topic.

About Physical Alias Tables

Added topic.

Creating and Administering General Properties for Physical Tables

Updated this topic to include changes for multidimensional data sources and added new properties for alias tables.

About Measures in a Multidimensional Data Source

Added topic.

Creating and Administering Columns and Keys in a Physical Table

Updated topic and procedure to include instructions for alias tables.

Setting Up Hierarchies in the Physical Layer for a Multidimensional Data Source

Updated topic to reflect new properties.

Updating Member Counts and Viewing Members in Physical Cube Tables

Added topics about updating member counts and viewing member data.

Deploying Opaque Views

Added topics that explain how to deploy, undeploy, and remove opaque views.

Creating Dimensions

Updated topic.

Creating Dimension Levels and Keys

Updated topic and added topics about working with time dimensions and chronological keys.

Selecting and Sorting Chronological Keys in a Time Dimension

Added topic.

Importing From Another Repository

Added information about changes to the import from repository process.

Querying and Managing Repository Metadata

Added procedures for saving queries and deleting saved queries. Updated procedures for running queries and saving query results to an external file.

About Extracting Metadata Subsets Into Projects

Added an explanation about how project extract work.

Setting Up the SA System Subject Area

Revised topic and added caution note about authorization and authentication configuration option.

Extracting Analytics Metadata Using Dependency Tracking

This topic replaced by Generating and Deploying a Metadata Dictionary

Time Series Wizard

Removed topic from Oracle BI Administration Tool Utilities and Expression Builder.

Synchronize Aliases

Removed topic from Oracle BI Administration Tool Utilities and Expression Builder. Synchronization is now automatic.

Generating and Deploying a Metadata Dictionary

Added topic.

Aggregate Persistence Wizard

Added topic.

Calculation Wizard

Added topic.

About Time Series Conversion Functions

Added topic to update Expression Builder.

About the IndexCol Conversion Function

Added topic to update Expression Builder.

Administering Usage Tracking

Added information about how usage tracking works.

Purging and Maintaining Cache Using ODBC Procedures

Added information about the SAGetSharedRequestKey ODBC procedure.

Storing and Purging Cache for SAP/BW Data Sources

Added topic.

Creating Aggregates for Oracle BI Server Queries

Added topics.

Understanding and Creating Session Variables

Added description of Oracle Business Intelligence Disconnected Analytics variables.

Creating Repository Variables and Creating Session Variables

Reorganized and updated these topics to reflect the changes in user interface design. Also added information about virtual private database parameters.

About Using Initialization Blocks With Variables and Process of Creating Initialization Blocks

Revised all topics to conform to new user interface.

About Authenticating Users Using Initialization Blocks

Retitled and revised topics.

Clustering Oracle BI Servers

Added information about Oracle BI Scheduler to this chapter.

Setting Parameters in the NQSConfig.INI File and Setting Parameters in the NQClusterConfig.INI File

Removed parameters from these topics. Parameters are described in the Oracle Business Intelligence Infrastructure Installation and Configuration Guide.

Setting Up LDAP Authentication and Maintaining Oracle BI Server User Authentication

Expanded and reorganized topics about LDAP authentication.

Maintaining Oracle BI Server User Authentication

Added cross-reference to Oracle Business Intelligence Enterprise Edition Deployment Guide.

Using FILTER to Compute a Conditional Aggregate

Added topic.

Aggregate Functions

Added and updated several topics about time series functions.

IndexCol

Added conversion function.

Description of the Usage Tracking Data

Added data columns.

Oracle BI Server Authentication APIs

Added appendix.

Other Documentation Changes

  • Added notes throughout the guide to identify the repository Presentation layer catalogs as subject areas.
Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.