Oracle® Business Intelligence Disconnected Analytics Administration and Configuration Guide

What's New in This Release

Back to top

Overview of Oracle BI Disconnected Analytics

About Oracle BI Disconnected Analytics

Frequently Used Terms for Oracle BI Disconnected Analytics

Distinguishing Between the Disconnected and the Network Environments

SQL Scripts for Disconnected Applications

Sourcing Queries for Disconnected Applications

Oracle BI Disconnected Analytics Application Manager

Oracle BI Disconnected Analytics Architecture (Server and Laptop)

Oracle BI Disconnected Analytics Scenario

Back to top

Setting Up Oracle BI Disconnected Analytics

Installing Oracle BI Disconnected Analytics Client

Updating the instanceconfig.xml File

Configuring ODBC DSN for Authentication with Oracle BI Disconnected Analytics

Configuring Sun ONE Web Server for Disconnected Clients

Setting Up Oracle BI Disconnected Analytics for Use with Windows Single Sign-On

Back to top

Preparing Applications for Oracle BI Disconnected Analytics

Step 1: Understanding the Directory Structure for Oracle BI Disconnected Analytics

Step 2: Creating and Testing Tables and Indexes in the SQL Anywhere Database

Creating SQL Scripts

Scenario for Using SQL Scripts to Create Disconnected Tables and Indexes

Testing SQL Scripts That Create Disconnected Tables and Indexes

Storing SQL Scripts in the Disconnected Directory

Step 3: Creating and Storing the Disconnected Repository

Assign the Database Type and Connection Pool

Testing and Storing the Disconnected Repository

Step 4: Creating the Local Oracle BI Presentation Catalog

Step 5: Defining Sourcing Queries for Oracle BI Disconnected Analytics

Step 6: Creating the Configuration File for an Oracle BI Disconnected Analytics Application

Working with Data Set Definitions

Defining Multiple Data Sets

Generating a Combined Table from Multiple Tables

Example of an Application Configuration File

The Retail.xml Configuration File Structure

Descriptions of Elements and Attributes in the Retail.xml Configuration File

Deleting Applications from Oracle BI Server

Back to top

Deploying Applications in Oracle BI Disconnected Analytics

Step 1: Creating and Testing Silent Installation for Oracle BI Disconnected Analytics

Step 2: Testing Oracle BI Disconnected Analytics Applications

Step 3: Testing the Downloading of an Application

Step 4: Setting Up Disconnected Machines

Installing Oracle BI Disconnected Analytics on Users' Machines

Downloading Applications to Users' Machines

Setting Up Users' Machines to Operate in Silent Mode

Back to top

Synchronizing Applications in Oracle BI Disconnected Analytics

About Synchronization

Setting Up for Synchronization

Step 1: Modifying the Synchronization Configuration File

Step 2: Disabling Alerts for Updates from the Oracle BI Presentation Catalog

Step 3: Setting Up for Background Synchronization (Silent Mode)

Step 4: Setting Up for Preprocessed Synchronization

About Preprocessed Synchronization

Setting Up Syncmode in the Application Configuration File

Storing Data Set Files

Configuring the Oracle BI Server

Step 5: Setting Up for Incremental Synchronization

About Incremental Synchronization

About Incremental Data Sets

Using Session Variables or Filters for Incremental Synchronization

Examples of Incremental Synchronization Scripts

Back to top

Configuration File Reference

Back to top