Legal | Privacy
Using Oracle Business Intelligence 10.1.2.2

Oracle by Example Series: Using Oracle Business Intelligence 10.1.2.2

The Oracle Application Server 10g and Oracle Developer Suite 10g Release 2 (10.1.2) Patch Set 2 (10.1.2.2.0) contains many new features for Oracle Business Intelligence. This patch set provides the features that are described in the following table. For information on all the new features, consult the updated Help systems for OracleBI Discoverer Plus OLAP and OracleBI Spreadsheet Add-In.

Feature

Description

Applicable Products
Calculated Members
You can create calculated members through a wizard in OracleBI Discoverer Plus OLAP and view them in other products. OracleBI Discoverer Plus OLAP, OracleBI Discoverer Viewer, OracleBI Discoverer Portlet Provider, OracleBI Spreadsheet Add-In
Write-back
With the appropriate privileges, you can write data back to the analytic workspace in the Oracle database. You can also perform calculations and validations on the data, which will run on the server. OracleBI Spreadsheet Add-In
Graph Styles

You can use six new graph styles that have been added to create attractive presentations easily. Each new style includes a gradient plot area or a gradient background, or both.

The names of the new graph styles are: April, Comet, Confetti, Glass, Nautical Southwest.

OracleBI Discoverer Plus, OracleBI Discoverer Viewer, OracleBI Discoverer Portlet Provider.
Discoverer Catalog Support
You can save and retrieve calculations, saved selections, and calculated members from the Discoverer Catalog for use in OLAP queries. OracleBI Spreadsheet Add-In
Share Calculations and Saved Selections In a Workbook
You share calculations and saved selections across queries in a workbook, even when the workbook is not connected to the Discoverer Catalog. OracleBI Spreadsheet Add-In
Toolbar You can use toolbar buttons to perform actions that were previously available only via menus and keystrokes. OracleBI Spreadsheet Add-In
Floating OracleBI Query Editor
You can allow the Query Editor to stay on top of Excel while you edit the query. OracleBI Spreadsheet Add-In
Enhanced Refreshing of Queries
You can refresh multiple queries in a single request, including refreshing all queries in a workbook.
OracleBI Spreadsheet Add-In
VBA Macros

You can call numerous VBA macros to programmatically perform write-back and other operations.

OracleBI Spreadsheet Add-In

Several of these new features are examined in this Oracle by Example series, including Calculated Members, Discoverer Catalog Support, the Toolbar (Spreadsheet Add-In), and the Floating OracleBI Query Editor (Spreadsheet Add-In).

In this section of the Oracle by Example series, you will learn how to use OracleBI Discoverer Plus OLAP and OracleBI Spreadsheet Add-In to develop and share business insight.

These lessons are designed for completion in the order that is shown below. Each subsequent lesson depends on the completion of the previous lesson. Click on any of the links below to begin.

Lesson 1: Creating Analytic Reports Using Discoverer Plus OLAP 10.1.2.2

Lesson 2: Create a Report that Uses Calculated Members

Lesson 3: Using the OracleBI Spreadsheet Add-In with OLAP Data

 

 


 

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy