|
Oracle® Business Intelligence Server Administration Guide
What's New in This Release
Back to top
Oracle BI Administration Tool Basics
Administration Tool User Interface Components
Features and Options for Oracle's Siebel Marketing Application
Online and Offline Repository Modes
Checking the Consistency of a Repository or a Business Model
Setting Preferences
Using the Options Dialog Box—General Tab
Using the Options Dialog Box—Repository Tab
Using the Options Dialog Box—Sort Objects Tab
Using the Options Dialog Box—Cache Manager Tab
Using the Options Dialog Box—Multiuser Tab
Using the Options Dialog Box—More Tab
Setting Permissions for Repository Objects
Editing, Deleting, and Reordering Objects in the Repository
Displaying and Updating Row Counts for Tables and Columns
Populating Logical Level Counts Automatically
Using the Browse Dialog Box
Back to top
Planning and Creating an Oracle BI Repository
Roadmap for Planning and Setting Up an Oracle BI Repository
Process of Oracle BI Repository Planning and Design
About Repository Planning and Design
Planning Your Business Model
Identifying the Database Content For The Business Model
Guidelines For Designing a Repository
Creating a New Oracle BI Repository File
Back to top
Creating and Administering the Physical Layer in an Oracle BI Repository
Process of Creating the Physical Layer from Relational Data Sources
Importing a Physical Schema from Relational Data Sources
Process of Creating the Physical Layer from Multidimensional Data Sources
Importing a Physical Schema from Multidimensional Data Sources
Setting Up Database Objects
About Database Types in the Physical Layer
Creating a Database Object Manually in the Physical Layer
Specifying SQL Features Supported by a Database
Setting Up Connection Pools
Creating or Changing Connection Pools
Setting Up Connection Pool Properties for Multidimensional Data Sources
Setting Up Additional Connection Pool Properties for an XML Data Source
Setting Up Write-Back Properties
Setting Up the Persist Connection Pool Property
About Physical Tables
Creating and Setting Up Physical Tables
Creating and Administering General Properties for Physical Tables
Viewing Data in Physical Tables or Columns
Creating and Administering Columns and Keys in a Physical Table
Setting Up Hierarchies in the Physical Layer for a Multidimensional Data Source
Setting Physical Table Properties for an XML Data Source
Creating Physical Layer Folders
Creating Physical Layer Catalogs and Schemas
Using a Variable to Specify the Name of a Catalog or Schema
Setting Up Display Folders in the Physical Layer
About Physical Joins
Defining Physical Foreign Keys and Joins
Defining Physical Foreign Keys or Complex Joins with the Joins Manager
Defining Physical Joins in the Physical Diagram
Deploying Opaque Views
Using Database Hints
Back to top
Creating and Administering the Business Model and Mapping Layer in an Oracle BI Repository
About Creating the Business Model and Mapping Layer
Creating Business Model Objects
Duplicate Business Model and Presentation Catalog
Creating and Administering Logical Tables
Creating Logical Tables
Specifying a Primary Key in a Logical Table
Reviewing Foreign Keys for a Logical Table
Creating and Administering Logical Columns
Creating and Moving a Logical Column
Setting Default Levels of Aggregation for Measure Columns
Associating an Attribute with a Logical Level in Dimension Tables
Creating and Administering Logical Table Sources (Mappings)
Creating or Removing a Logical Table Source
Defining Physical to Logical Table Source Mappings
Defining Content of Logical Table Sources
About Dimensions and Hierarchical Levels
Process of Creating and Administering Dimensions
Creating Dimensions
Creating Dimension Levels and Keys
Setting Up Dimension-Specific Aggregate Rules for Logical Columns
Setting Up Display Folders in the Business Model and Mapping Layer
Defining Logical Joins
Defining Logical Joins with the Joins Manager
Defining Logical Joins with the Business Model Diagram
Specifying a Driving Table
Identifying Physical Tables That Map to Logical Objects
Back to top
Creating and Maintaining the Presentation Layer in an Oracle BI Repository
Creating the Presentation Layer in the Repository
Presentation Layer Objects
Working with Presentation Catalogs
Working with Presentation Tables
Working with Presentation Columns
Using the Alias Tab of Presentation Layer Dialog Boxes
Generating an XML File from a Presentation Table
Back to top
Completing Setup and Managing Oracle BI Repository Files
Process of Completing the Setup for a Repository File
Saving the Repository and Checking Consistency
Add an Entry in the NQSConfig.INI File
Create the Data Source
Start the Oracle BI Server
Test and Refine the Repository
Publish to User Community
Importing From Another Repository
Querying and Managing Repository Metadata
Constructing a Filter for Query Results
Comparing Repositories
Merging Oracle BI Repositories
Exporting Oracle BI Metadata to IBM DB2 Cube Views
About Extracting Metadata Subsets Into Projects
Setting up and Using the Oracle BI Multiuser Development Environment
Setting Up a Multiuser Development Environment (Administrator)
Making Changes in a Multiuser Development Environment (Developers)
Checking In Multiuser Development Repository Projects
Viewing and Deleting History for Multiuser Development
Setting Up the Repository to Work with Delivers
About the SA System Subject Area
Setting Up the SA System Subject Area
Back to top
Oracle BI Administration Tool Utilities and Expression Builder
Utilities and Wizards
Replace Column or Table Wizard
Oracle BI Event Tables
Externalize Strings
Rename Wizard
Update Physical Layer Wizard
Generating Documentation of Repository Mappings
Generating and Deploying a Metadata Dictionary
Removing Unused Physical Objects
Aggregate Persistence Wizard
Calculation Wizard
Expression Builder
Back to top
Setting Up Fragmentation Content in an Oracle BI Repository for Aggregate Navigation
About Aggregate Navigation
Specify Fragmentation Content
Back to top
Administering the Oracle BI Server Query Environment
Starting the Oracle BI Server
Starting the Server from Windows Services
Configuring the Server for Automatic Startup in Windows
Running the Server Startup Script in UNIX
Changing the User ID in Which the Oracle BI Server Runs
If the Server Fails to Start
Shutting Down the Oracle BI Server
Shutting Down the Server in Windows Services
Shutting Down the Server from a Command Prompt in Windows
Running the Server Shutdown Script in UNIX
Shutting Down the Oracle BI Server Using the Administration Tool
Getting Users to Connect to the Server
Administering the Query Log
Administering Usage Tracking
Setting Up Direct Insertion to Collect Information for Usage Tracking
Setting Up a Log File to Collect Information for Usage Tracking
Server Session Management
Server Configuration and Tuning
Back to top
Query Caching in the Oracle BI Server
About the Oracle BI Server Query Cache
Query Cache Architecture
Configuring Query Caching
Monitoring and Managing the Cache
Purging and Maintaining Cache Using ODBC Procedures
Storing and Purging Cache for SAP/BW Data Sources
Strategies for Using the Cache
Creating Aggregates for Oracle BI Server Queries
Identifying Query Candidates for Aggregation
About Writing the Create Aggregates Specification
Generating the SQL Script File
About Setting the Logging Level
Executing the SQL Script File to Create and Delete Aggregates
Post Creation Activities
Cache Event Processing with an Event Polling Table
Setting Up Event Polling Tables on the Physical Databases
Making the Event Polling Table Active
Populating the Oracle BI Server Event Polling Table
Troubleshooting Problems with an Event Polling Table
Making Changes to a Repository
Using the Cache Manager
Displaying Global Cache Information
Purging Cache
About the Refresh Interval for XML Data Sources
Back to top
Connectivity and Third-Party Tools in Oracle BI Server
Configuring Oracle BI ODBC Data Source Names (DSNs)
ODBC Conformance Level
Third-Party Tools and Relational Data Source Adapters
Importing Metadata
Exchanging Metadata with Databases
Finding Information on Metadata Exchange
Generating the Import File
Using Materialized Views in the Oracle Database with Oracle BI
About Using Oracle Database Summary Advisor with Materialized Views
Process of Deploying Metadata for Oracle
Using IBM DB2 Cube Views with Oracle BI
About Using IBM DB2 Cube Views with Oracle BI
Process of Deploying Cube Metadata
Back to top
Using Variables in the Oracle BI Repository
Using the Variable Manager
Understanding and Creating Repository Variables
Understanding and Creating Session Variables
About Using Initialization Blocks With Variables
Process of Creating Initialization Blocks
Assigning a Name and Schedule to Initialization Blocks
Selecting and Testing the Data Source and Connection Pool
Associating Variables With Initialization Blocks
Establishing Execution Precedence
Back to top
Clustering Oracle BI Servers
About the Cluster Server
Components of the Cluster Server
Implementing the Cluster Server
Chronology of a Cluster Operation
Using the Cluster Manager
Viewing and Managing Cluster Information
Performance Considerations
Back to top
Security in Oracle BI
Oracle BI Security Manager
Working with Users
Working with Groups
Importing Users and Groups from LDAP
Authentication Options
Setting Up LDAP Authentication
Setting Up External Table Authentication
Setting Up Database Authentication
About Oracle BI Delivers and Database Authentication
Maintaining Oracle BI Server User Authentication
Order of Authentication
Managing Query Execution Privileges
Back to top
Using XML as a Data Source for the Oracle BI Server
Locating the XML URL
Using the Oracle BI Server XML Gateway
Oracle BI Server XML Gateway Example
Accessing HTML Tables
Using the Data Mining Adapter
Using XML ODBC
XML ODBC Example
XML Examples
83.xml
8_sch.xml
84.xml
Island2.htm
Back to top
Oracle BI Server SQL Reference
SQL Syntax and Semantics
SELECT Query Specification Syntax
SELECT Usage Notes
SELECT List Syntax
Rules for Queries with Aggregate Functions
SQL Logical Operators
Conditional Expressions
SQL Reference
Aggregate Functions
Running Aggregate Functions
String Functions
Math Functions
Calendar Date/Time Functions
Conversion Functions
System Functions
Expressing Literals
Back to top
Oracle BI Server Usage Tracking Data Descriptions and Using the Log File Method
Create Table Scripts for Usage Tracking Data
Loading Usage Tracking Tables with Log Files
Description of the Usage Tracking Data
Back to top
Oracle BI Server Authentication APIs
Back to top
| 
