11 Using OracleBI Discoverer with OracleAS Portal

11.1 What is OracleAS Portal?

OracleAS Portal is a component of OracleAS that enables non-technical business users to create portals. Portals are Internet or intranet sites that provide a personalized, single point of interaction with a company's suite of applications. Portals also enable you to provide a consistent look and feel to users.

The Discoverer Portlet Provider is the content delivery mechanism used to publish Discoverer data in OracleAS Portal. The Discoverer Portlet Provider enables portal users to publish three types of Discoverer portlet:

• a Worksheet portlet, which displays a Discoverer worksheet and an Analyze link that displays the worksheet in Discoverer Viewer

• a List of Worksheets portlet, which displays links to Discoverer worksheets

• a Gauges portlet, which displays Discoverer worksheet data as one or more semi-circular gauges. The gauges have a similar appearance to a speedometer.

The figure below shows a portal page containing a Discoverer List of Worksheets portlet called Analyze Sales Reports. Analyze Sales Reports contains links to Discoverer worksheets that enable portal users to start Discoverer Viewer and quickly access Discoverer reports.

Figure 11-1 An OracleAS Portal containing a List of Worksheets portlet

Description of the illustration portmain.gif

You can also use Discoverer portlets in dashboard applications to display worksheets and graphs (see figure below).

Figure 11-2 A dashboard application featuring a Discoverer portlet

Description of the illustration dash.gif

Notes

• For more information about OracleAS Portal, see Oracle Application Server Portal Configuration Guide.

• for relational worksheets, you can display worksheet data and/or graph data. For multidimensional worksheets, you display worksheet data and graph data.

• For more information about how OracleBI Discoverer works with OracleAS Portal and OracleAS Single Sign-On, see Section 14.7.2.3, "An example showing how Discoverer works with OracleAS Portal and Single Sign-on".

• To use Discoverer with OracleAS Portal, make sure that the OssoIPCheck parameter value in the mod_osso.conf file is set to FALSE.

11.2 How to use OracleBI Discoverer with OracleAS Portal

Before portal users can add Discoverer portlets to an OracleAS Portal, you must register the Discoverer Portlet Provider with OracleAS Portal.

You register the Discoverer Portlet Provider using the Add Portlet Provider page in OracleAS Portal.

To use OracleBI Discoverer with OracleAS Portal, do the following:

• (optional) make sure that Discoverer Portlet Provider is installed correctly by entering the following URL in an Internet browser:

  http://<host.domain>:<port>/discoverer/portletprovider/

  If Discoverer Portlet Provider is installed correctly, you will see the JPDK Test Page, which displays the message 'Congratulations! You have successfully reached your Provider's Test Page', and lists the Discoverer portlet types available.

• register Discoverer Portlet Provider with OracleAS Portal (for more information, see Section 11.3, "How to register Discoverer Portlet Provider with OracleAS Portal")

  Note: This task must be done once during or after an Oracle Business Intelligence standalone CD installation.

• use OracleAS Portal to add Discoverer portlets to portal pages, which is typically done by Discoverer Plus or Discoverer Viewer users

  For more information about how to add Discoverer portlets to portal pages, see Oracle Business Intelligence Discoverer Plus User's Guide.

11.3 How to register Discoverer Portlet Provider with OracleAS Portal

You register Discoverer Portlet Provider to enable OracleAS Portal end users to add Discoverer business intelligence portlets to their portal pages.

To register Discoverer Portlet Provider with OracleAS Portal:

1. Start a Web browser and enter the URL for OracleAS Portal.

   For example:

   http://<host.domain>:<port>/pls/portal

   For more information about displaying the OracleAS Portal main page, contact the OracleAS Portal administrator.

   
   Description of the illustration port5.gif
   
   

2. Select the Login link and connect as a Portal administrator.

3. Display the Administer tab.

4. Display the Portlets sub-tab.

   
   Description of the illustration port4.gif
   
   

5. Select the Register a Provider link to display the Provider Information page.

   
   Description of the illustration port1.gif
   
   

6. Enter the Discoverer Portlet Provider details.

   You can enter any name and display name for the Discoverer Portlet Provider as required. The name and display name can be different.

   Hint: Give the Portlet Provider a useful display name because users will see this when they add a Discoverer portlet to a portal page.

7. Choose Web from the Implementation Style drop down list.

8. Click Next to display the Define Connection - General Properties page.

   
   Description of the illustration port2.gif
   
   

9. Enter the Portlet Provider general properties as follows:

   1. Enter the URL of the Discoverer Portlet Provider in the URL field, in the form:

      http://<host.domain>:<port>/discoverer/portletprovider (e.g. http://myserver:80/discoverer/portletprovider)

   2. Clear the Web Provider in same cookie domain as the portal check box.

   3. Select the The user has the same identity in the Web providers application as in the Single Sign-On identity radio button.

   4. In the User/Session Information area, select the User radio button, and select the Once Per User Session option from the Login Frequency field.

      Note: Do not change the default value of other fields.

10. Click Next to display the Control Access page.

    
    Description of the illustration port3.gif
    
    

11. (optional) Change the default access control settings if necessary.

12. Click Finish.

End users can now use the Discoverer Portlet Provider to add portlets to an OracleAS Portal page.

Notes

• If Discoverer end users need to publish workbooks and worksheets using a public connection, use Oracle Application Server Control to create a public connection that they can use (for more information about creating public connections, see Section 4.6, "How to create public connections").

11.4 How to edit the Discoverer Portlet Provider

You edit the Discoverer Portlet Provider when you want to change the way that it works. For example, you might want to change the Discoverer Portlet Provider Display Name, or change its Control Access settings.

To edit the Discoverer Portlet Provider:

1. Start a Web browser and enter the URL for the OracleAS Portal main page main page.

   For example:

   http://<host.domain>:<port>/pls/portal

   For more information about displaying the OracleAS Portal main page, contact the OracleAS Portal administrator.

2. Display the Administer tab.

3. Display the Portlets sub-tab.

   
   Description of the illustration port4.gif
   
   

4. In the Remote Providers area, enter the name of the Discoverer Portlet Provider (i.e. its display name) in the Name field, and click Edit to display the Provider Information page.

   Hint: If you are not sure of the display name of the Discoverer Portlet Provider, do the following:

   1. Click the Browse Providers icon to the right of the Name field.

   2. Choose the Discoverer Portlet Provider name from the list of Portlet Providers displayed.

      Hint: The name that you choose is the display name that was specified when you registered the Discoverer Portlet Provider (for more information, see Section 11.3, "How to register Discoverer Portlet Provider with OracleAS Portal").

   3. Click Edit to display the Edit Portlet Provider page.

5. Make the necessary changes, as follows:

   • use the Main tab to change provider information (e.g. the display name of the Discoverer Portlet Provider)

   • use the Connection tab to change general properties (e.g. the URL of the Discoverer Portlet Provider)

   • use the Access tab to change the access privileges (e.g. the control access settings of the Discoverer Portlet Provider)

6. Click OK to save the changes you have made.

The Discoverer Portlet Provider is updated according to changes you have made.