Contents

Title and Copyright Information

Preface

New Features for Oracle Business Intelligence Users

Introducing Oracle Business Intelligence Enterprise Edition

Creating Analyses

What Are Analyses?
- How Do I Work with Analyses?
- How Are Analyses Processed?
- Embedding an Analysis in a Dashboard
What Are Subject Areas and Columns?
- What Are the Types of Columns?
- How Are Columns Indicated Visually?
- How Will Measure Columns Created in Previous Releases Be Upgraded?
Understanding the Double Column Feature
What Is the Analysis Editor?
- Managing Panes in the Analysis Editor Tabs
What Is the Process for Constructing Analyses?
Creating New Analyses
Specifying the Criteria for Analyses
- Understanding Null Suppression
- Example 1: Adding a Filter to a Row Edge on a Measure When Null Values Are Included
- Example 2: Adding a Filter to a Row Edge on a Measure When Null Values Are Included
- Example 3: Adding a "Not Null" Filter to a Row Edge on a Measure When Null Values Are Included
- Editing the Formula for a Column
- Combining Columns Using Set Operations
- Viewing Metadata Information from the Subject Areas Pane
Saving Columns to the Catalog
Changing the Sort Order of Subject Areas and Subject Area Folders
- Where Else is the Subject Areas Sort Order Reflected?
Displaying the Results of Analyses
- Creating Additional Compound Layouts
- Alerting Users to No Data in the Results of Analyses
Adding Prompts to Analyses
Examining the Logical SQL Statements for Analyses
Saving Analyses
Creating Agents from Analyses
Editing Analyses
- Editing Upgraded Analyses that Contain "Advanced SQL"
About Embedding an Analysis in a Dashboard
Working with Direct Database Requests
- Setting Privileges for Direct Requests
- Executing a Direct Database Request
- Seeing the Results of Direct Database Requests
Using Variables
- What Are Session Variables?
- What Are Repository Variables?
- What Are Presentation Variables?
- What Are Request Variables?
- What Are Global Variables?
Where Can I Reference Variables?
What Is the Syntax for Referencing Variables?
What Predefined Presentation Variables Are Available?
Example of Referencing a Variable in a Title View

Adding Views for Display in Dashboards

Building and Using Dashboards

Filtering and Selecting Data for Analyses

Prompting in Dashboards and Analyses

Formatting Analyses, Views, and Dashboard Pages

Delivering Content

Working with Conditions

Working with Actions

Using KPIs and KPI Watchlists

Scorecarding

Managing Objects in the Oracle BI Presentation Catalog

Using BI Composer to Work with Analyses

Basic Information to Tell Your Users

Integrating with Microsoft Office

Accessibility Features

Logical SQL Reference

User Interface Reference

Glossary

Index