Contents

Title and Copyright Information

Preface

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

1 Introducing Oracle BI Discoverer and Oracle Portal

• 1.1 What is Oracle Business Intelligence Discoverer?
• 1.2 What is a Discoverer workbook?
• 1.3 What is a Discoverer Portlet?
• 1.4 What is Discoverer Portlet Provider?
• 1.5 What are the different types of Discoverer portlet?
  • 1.5.1 About the Discoverer Worksheet portlet
  • 1.5.2 About the Discoverer Gauges portlet
  • 1.5.3 About the Discoverer List of Worksheets portlet
• 1.6 What is Oracle Portal?
• 1.7 About Publishing Discoverer portlets in Oracle Portal pages
• 1.8 What are the prerequisite tasks for publishing Discoverer portlets in Oracle Portal?
• 1.9 Setting up Discoverer WSRP Portlet Preference Store for High Availability
• 1.10 How to Publish Discoverer Portlets in Oracle Portal
• 1.11 What are Discoverer connections?

2 Setting up Discoverer Portlet Provider in Oracle Portal

• 2.1 What are the schemas that Discoverer Portlet Provider uses?
• 2.2 How to register Discoverer Portlet Provider with Oracle Portal
  • 2.2.1 How to register Discoverer PDK-Java Portlet Provider with Oracle Portal
  • 2.2.2 How to register Discoverer WSRP Portlet Provider with Oracle Portal
• 2.3 How to edit Discoverer Portlet Provider after it has been registered with Oracle Portal
• 2.4 Notes about changing the default performance settings for Discoverer
• 2.5 About copying Discoverer portlets from one Discoverer installation to another
  • 2.5.1 How to copy Discoverer portlets from one Discoverer installation to another
    • 2.5.1.1 How to log in to Oracle Portal
    • 2.5.1.2 How to export Discoverer portlets to a transport set
    • 2.5.1.3 How to obtain the PORTAL login password
    • 2.5.1.4 How to create a dump (*.dmp) file to copy the Discoverer portlets
    • 2.5.1.5 How to extract a transport set from a dump (*.dmp) file
    • 2.5.1.6 How to import a transport set into Oracle Portal
  • 2.5.2 How to copy Discoverer connections from one Discoverer installation to another
    • 2.5.2.1 How to obtain the <user-prefix>_DISCOVERER_PS login password
    • 2.5.2.2 How to export Discoverer connections
    • 2.5.2.3 How to import Discoverer connections

3 Authoring Oracle Portal Pages with Discoverer Portlets

• 3.1 Pre-requisites for publishing Discoverer worksheets in Oracle Portal
• 3.2 How to connect to Oracle Portal and display the Add Portlets page
• 3.3 How to add a Discoverer List of Worksheets portlet to an Oracle Portal page
• 3.4 How to add a Discoverer Worksheet portlet to an Oracle Portal page
• 3.5 How to add a Discoverer Gauges portlet to an Oracle Portal page
• 3.6 How to edit a Discoverer portlet
• 3.7 How to customize a Discoverer portlet using Discoverer Portlet Provider
• 3.8 How to customize the Discoverer worksheet shown in a portlet in Viewer, using the Analyze link
• 3.9 Notes about resizing graphs in Discoverer Worksheet portlets
• 3.10 Notes about using worksheet parameters in Discoverer portlets
• 3.11 How to map worksheet parameters to Page Parameters in Oracle Portal
  • 3.11.1 How to map worksheet parameters to Generic Page Parameters
  • 3.11.2 How to create a Page Parameter
  • 3.11.3 How to map a Generic Page Parameter to a Page Parameter
• 3.12 How to add Simple Parameter Form portlets to an Oracle Portal page
• 3.13 Notes about publishing Discoverer content in portlets
• 3.14 About choosing database connections for Discoverer portlets
• 3.15 About choosing refresh options for Discoverer portlets
• 3.16 About Discoverer connections and Single Sign-On

4 Using Discoverer Portlets in Oracle Portal

• 4.1 About using Oracle Portal as a personalization framework for Discoverer

A Publishing Discoverer Worksheets in Oracle WebCenter

B Publishing Discoverer Worksheets in Oracle WebLogic Portal

Index