Data set

A written definition of how to create and/or populate a specified list of SQL tables for a disconnected application on a disconnected machine. A data set represents an inseparable downloadable unit of data for a synchronization operation. This gives disconnected users more flexibility when downloading data for disconnected applications to their disconnected machines.

For example, a rapidly changing fact table might have its own data set while the relatively static dimension tables might share another data set. Advanced users might select specific data sets that they want to download during synchronization (in the Oracle BI Disconnected Analytics Application Manager, on the Advanced tab), but less-experienced users might prefer the default selection of data sets.

Oracle BI Disconnected Analytics Application Manager

The utility program used to synchronize, start, and delete a disconnected application on a disconnected machine.

For more information, see Oracle BI Disconnected Analytics Application Manager.

Disconnected application

A completely self-contained Oracle Business Intelligence application that runs on a disconnected machine. Application data resides in a disconnected SQL Anywhere database, Oracle Business Intelligence metadata resides in a disconnected repository, and Oracle Business Intelligence metadata resides in a local Oracle BI Presentation Catalog.

Disconnected application configuration file

A file in XML format that defines a particular disconnected application, including associating sourcing queries and SQL script files with data sets and identifying the location of the disconnected repository and local Oracle BI Presentation Catalog.

Disconnected machine

The machine is typically a laptop on which Oracle Business Intelligence is installed with the disconnected option. A disconnected user connects to Oracle BI Server from this machine and initiates a synchronization operation to download a disconnected application.

Disconnected repository

The repository for a disconnected application that is downloaded from the Oracle BI Server to a disconnected machine during a synchronization operation.

Local Oracle BI Presentation Catalog

The local catalog for a disconnected application downloaded from the Oracle BI Server to a disconnected machine during a synchronization operation.

Full Oracle BI Presentation Catalog

The Oracle BI Presentation Catalog that resides on the Oracle BI Server.

Oracle Business Intelligence application

The fully functional Oracle Business Intelligence application that runs on the Oracle BI Server. The disconnected application is a version of the Oracle Business Intelligence application that is configured for a single user. It typically contains fewer queries (reports) and dashboards and a subset of the data.

Enterprise repository

The analytics repository for the enterprise application.

Oracle BI Server

The central machine that runs the complete version (as opposed to the disconnected version) of Oracle Business Intelligence and hosts the application. Disconnected users connect their disconnected machines to the Oracle BI Server to download a disconnected application.

Full data set

A data set that represents all data for a particular disconnected application at a given point in time. Subsequent incremental updates are defined by incremental data sets.

Incremental data set

A data set that defines additional data generated after a full data set. An incremental data set checks for certain time stamps to determine which pieces of data the user needs and to generate only those pieces. For a first-time synchronization, a full data set and an incremental data set are the same, because the full data set is downloaded.

Sourcing query (report)

A query that is stored in the Oracle BI Presentation Catalog on the Oracle BI Server and is used to generate data files for downloading to a disconnected application.

For more information, see Sourcing Queries for Disconnected Applications.

SQL script files

Files that contain SQL commands that create and populate tables and indexes in the SQL Anywhere database on a disconnected machine.

For more information, see SQL Scripts for Disconnected Applications

Synchronization operation

The mechanism for synchronizing a disconnected application on a disconnected machine with the corresponding application on the Oracle BI Server. The following are some of the tasks that this operation performs:

• Downloading data files that are generated or stored on the Oracle BI Server to a disconnected machine.
• Loading those files into a SQL Anywhere database on a disconnected machine.
• Downloading the disconnected repository.
• Downloading the local Oracle BI Presentation Catalog.