Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Oracle BI Discoverer Keyboard Navigation
• Related Documents
• Conventions
• JGoodies License Agreement

1 Introducing Oracle Business Intelligence Discoverer Viewer

• 1.1 What is Oracle Business Intelligence Discoverer?
• 1.2 Why use Discoverer Viewer?
  • 1.2.1 Easy-to-use Interface
  • 1.2.2 Consistency with Discoverer Plus and Discoverer Desktop
  • 1.2.3 Familiar Browser Facilities with Discoverer Viewer
  • 1.2.4 Database Security
  • 1.2.5 Integration and Customization
  • 1.2.6 JavaScript Enhanced User Interface
  • 1.2.7 Language Support
  • 1.2.8 Publish to Oracle Portal
• 1.3 What are the new features in Oracle Business Intelligence Discoverer Viewer 11g Release 1 (11.1.1)?
• 1.4 What are workbooks?
• 1.5 What are worksheets?
• 1.6 About Discoverer worksheet types
  • 1.6.1 About table worksheets
  • 1.6.2 About crosstab worksheets
• 1.7 What are the components of a cube?
  • 1.7.1 What are measures?
  • 1.7.2 What are dimensions and dimension members?
  • 1.7.3 What are dimension hierarchies?
  • 1.7.4 What are dimension attributes?

2 Starting Discoverer Viewer

• 2.1 What is a Discoverer connection?
• 2.2 About starting Discoverer Viewer
• 2.3 How to display the Discoverer Viewer connections page
• 2.4 How to start Discoverer Viewer using an existing connection
• 2.5 How to start Discoverer by connecting directly
• 2.6 How to exit Discoverer Viewer
• 2.7 Frequently asked questions
  • 2.7.1 What is the End User Layer (EUL)?
  • 2.7.2 What are database accounts?
  • 2.7.3 How do I create and save login information in a Discoverer connection?
  • 2.7.4 How do I edit a Discoverer connection?
  • 2.7.5 How do I delete a Discoverer connection?
  • 2.7.6 What are public connections?
  • 2.7.7 What are user-defined connections?
  • 2.7.8 When and why should I change my password?
  • 2.7.9 How do I change the password for a connection?
  • 2.7.10 How do I change the End User Layer for a Discoverer connection?
  • 2.7.11 What is Single Sign-On?
  • 2.7.12 What is the difference between Single Sign-On and Discoverer passwords?

3 Analyzing data with Discoverer Viewer

• 3.1 How to open a Discoverer worksheet
• 3.2 How to save worksheets
• 3.3 How to preview worksheets before printing
• 3.4 How to print worksheets
• 3.5 Exporting Discoverer worksheets
  • 3.5.1 How to export Discoverer worksheets
  • 3.5.2 What are the implications of using different export formats?
    • 3.5.2.1 What does Discoverer do when you export worksheet data using the XLS file format?
    • 3.5.2.2 What does Discoverer do when you export worksheet data using the CSV file format?
    • 3.5.2.3 About exporting Discoverer worksheets to Microsoft Excel Web Query format
  • 3.5.3 How to configure a client machine to automatically open exported Excel files
• 3.6 How to send Discoverer worksheets in an e-mail
• 3.7 How to format worksheet items and cells
• 3.8 Using conditional formatting in Discoverer
  • 3.8.1 What is a conditional format?
  • 3.8.2 What is a stoplight format?
  • 3.8.3 What is a conditional header format?
  • 3.8.4 How to activate and deactivate conditional formats
  • 3.8.5 How to change the precedence of conditional format
  • 3.8.6 How to create a conditional format
  • 3.8.7 How to create a stoplight format
  • 3.8.8 How to create a conditional header format
  • 3.8.9 How to edit conditional formats
  • 3.8.10 How to delete conditional formats
• 3.9 Using graphs in Discoverer Viewer
  • 3.9.1 About using graphs
  • 3.9.2 How to edit a graph
  • 3.9.3 How to display or hide a graph
• 3.10 Using parameters in Discoverer Viewer
  • 3.10.1 About using indexes and values in parameters
  • 3.10.2 How to apply different parameter values to worksheets
  • 3.10.3 About error when using lists of values
• 3.11 How to sort items and measures in a worksheet
• 3.12 About drilling in Discoverer Viewer
• 3.13 How to drill down in worksheets
• 3.14 How to drill up in worksheets
• 3.15 How to change the layout of a worksheet
• 3.16 How to apply saved selections

4 Dialog Reference

• About Viewer page
• Choose attachment type (send as email attachment)
• Choose export type page
• Component Disabled page
• Conditional Formats (Table/Crosstab) page
• Create Conditional Cell Format page
• Create Conditional Header Format page
• Create Stoplight Format page
• Drill page
• Edit Parameters page
• Error page
• Export Ready page
• Format Cells page
• Format Worksheet data links page
• Logged Out page
• Multiple Sort page
• PDF Ready page
• PDF Sample Ready page
• Preferences page
• Printable Page Options page: Content tab
• Printable Page Options page: Page Setup tab
• Query Canceled page
• Query Confirmation needed page
• Query Progress page
• Save Warning page
• Save Workbook As page
• Search and Select page
• Send Email page
• Specify page
• Table / Crosstab Layout page
• Worksheet Display page
• Worksheet Display page: (Actions and Worksheet links)
• Worksheet Display page: (Graph tools)
• Worksheet Display page: (Page level tools and controls)
• Worksheet Display page: (Table/Crosstab tools)
• Worksheet List page
• Worksheet Options page

Index