Skip Headers
Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.1) for Microsoft Windows and Solaris Operating System (SPARC)
B13918-03
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

5 Managing and configuring OracleBI Discoverer

Note: This chapter only applies to Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider. For more information about configuring Discoverer Plus OLAP, see Chapter 6, "Configuring the Discoverer Catalog and Discoverer Plus OLAP".

This chapter explains how to manage and configure OracleBI Discoverer, and includes the following topics:

5.1 About Oracle Enterprise Manager Application Server Control

Oracle Enterprise Manager Application Server Control is part of Oracle Enterprise Manager, which provides a comprehensive systems management platform for managing Oracle middle tier products.

Application Server Control provides Web-based management tools that enable you to monitor and configure Oracle components (e.g. OracleBI Discoverer, OracleAS Portal, OracleAS HTTP Server). You can deploy applications, manage security, and create Oracle Application Server clusters.

The figure below shows the Application Server Control main page.

Figure 5-1 Application Server Control main page

Description of Figure 5-1  follows
Description of "Figure 5-1 Application Server Control main page"

Notes

5.1.1 Why use Application Server Control with Discoverer?

You use Application Server Control with Discoverer to:

  • stop and start components

  • set configuration options

  • monitor performance

  • diagnose problems

The following table lists some of the Discoverer configuration tasks that you might perform using Application Server Control:

Discoverer management task Where can I find out more information about this task?
Administer the Discoverer Catalog (i.e. install, uninstall and manage catalog). Chapter 6, "Configuring the Discoverer Catalog and Discoverer Plus OLAP".
Customize the look and feel, and page layout of Discoverer Viewer. Chapter 9, "Customizing OracleBI Discoverer"
Enable and disable Discoverer client tier components. Section 5.4, "About disabling and enabling Discoverer client tier components"
Manage connections for Discoverer Plus and Discoverer Viewer. Section 4.3, "About managing Discoverer connections?"
Monitor Discoverer metrics. Section 5.7, "About monitoring Discoverer metrics"
Search for and analyze Discoverer log files. Section D.2, "About Discoverer diagnostics and logging"
Select the locale for public connections. Chapter 4, "Managing OracleBI Discoverer connections"
Specify a different Java Plug-in for Discoverer Plus (e.g. Sun Java Plug-in). Section 5.9.1, "How to specify a different Java Virtual Machine for Discoverer Plus"
Customize Discoverer Plus and Discoverer Viewer (e.g. specify a logo to use in Discoverer Plus, change the default look and feel). Chapter 9, "Customizing OracleBI Discoverer"
Specify caching settings for Discoverer Viewer. Section 5.6.1, "How to change configuration options for individual Discoverer client tier components"
Specify communication protocols for the Discoverer Plus middle tier. Section 14.6.3.3, "How to display the OracleBI Discoverer Plus Communications Protocols page in Application Server Control"
Specify delay times for Discoverer Viewer. Section 5.6.1, "How to change configuration options for individual Discoverer client tier components"
Specify PDF settings for Discoverer Viewer. Section 5.6.1, "How to change configuration options for individual Discoverer client tier components"
Specify printing settings for Discoverer Viewer. Section 5.6.1, "How to change configuration options for individual Discoverer client tier components"
Specify the maximum number of Discoverer Portlet Provider sessions to pool and the number of generic portlet parameters allowed in a Discoverer worksheet portlet. Chapter 11, "Using OracleBI Discoverer with OracleAS Portal"
Specify the use of caching, logging level, printing paper sizes, PDF generation, email settings and delay times (for Query Progress page and export completion) for Discoverer Viewer. Application Server Control Help
Start and stop the Discoverer Service. Section 5.3, "About starting and stopping the Discoverer Service"
Start and stop the Discoverer servlets. Section 5.5, "How to start and stop the Discoverer servlets"

5.1.2 How to start Application Server Control and display the System Components page

You use Application Server Control to configure OracleBI and OracleAS components (e.g. OracleBI Discoverer, OracleAS Portal). For example, if you want to start or stop the Discoverer Service, view current session details, or configure default user preferences for all users.

To display Application Server Control:

  1. Start a Web browser and enter the Application Server Control URL containing the fully qualified host name and domain of the OracleBI installation that you want to configure.

    For example:

    http://<host.domain>:1810

    Hint: To find out the URL for Oracle Application Server Control in your installation, look in the file <ORACLE_HOME>/install/setupinfo.txt.

  2. When prompted, enter an Application Server Control user name and password.

  3. Click OK.

    If the Oracle Business Intelligence installation is associated with an OracleAS Infrastructure, the Application Server Control Home Farm page is displayed.

    Description of oem1.gif follows
    Description of the illustration oem1.gif

  4. In the Name column, select the instance containing the Oracle Business Intelligence installation to display the Application Server Home page.

    Description of oem2.gif follows
    Description of the illustration oem2.gif

    Note: If the Oracle Business Intelligence installation is a standalone installation, the Application Server Control Home Farm page is not displayed and you go straight to the Application Server Home page.

Notes

5.1.3 How to display the Application Server Control Discoverer Home page

You display the Application Server Control Discoverer Home page to monitor, configure, and manage Discoverer installations.

To display the Application Server Control Discoverer Home page:

  1. Start Application Server Control and navigate to the System Components page (for more information, see Section 5.1.2, "How to start Application Server Control and display the System Components page").

    Application Server Control displays a list of OracleAS System Components available for the Oracle Business Intelligence installation (e.g. Discoverer, OC4J, HTTP Server).

    Description of oem2.gif follows
    Description of the illustration oem2.gif

  2. In the Name column, select the Discoverer link to display the Application Server Control Discoverer Home page.

    Description of em_main.gif follows
    Description of the illustration em_main.gif

From the Application Server Control Discoverer Home page, you can stop and restart Discoverer client tier components, and manage all aspects of Discoverer (see figure below).

Notes:

  • The figure below shows the Application Server Control Discoverer Home page.

Figure 5-2 Application Server Control Discoverer Home page

Description of Figure 5-2  follows
Description of "Figure 5-2 Application Server Control Discoverer Home page"


Key to figure:
a. Link to the Discoverer Components area (for more information, see Section 5.2, "About using Application Server Control to manage Discoverer components")
b. The Home tab of the Application Server Control Discoverer page.
c. The Administration tab to display Discoverer Catalog administration and Discoverer configuration pages.
d. Buttons to start and stop the Discoverer Service.
e. Current Status indicator, which shows whether the Discoverer Service is running (i.e. Up) or not running (i.e. Down).
f. General information about the Discoverer component (e.g. memory and CPU usage).

5.2 About using Application Server Control to manage Discoverer components

As a middle tier manager, you use Application Server Control to manage the following Discoverer components:

The main tasks that you perform using Application Server Control are:

Figure 5-3 Using Application Server Control to manage Discoverer components

Description of Figure 5-3  follows
Description of "Figure 5-3 Using Application Server Control to manage Discoverer components"

The figure below shows the Discoverer Plus component, Discoverer Viewer component, and Discoverer Portlet Provider component displayed in the Application Server Control Discoverer Home page.

Figure 5-4 Discoverer components displayed in the Application Server Control Discoverer Home page

Description of Figure 5-4  follows
Description of "Figure 5-4 Discoverer components displayed in the Application Server Control Discoverer Home page"

Notes

5.2.1 What happens when you enable or disable Discoverer client tier components?

What happens when you enable or disable Discoverer client tier components depends on whether the Discoverer Service is running, as show below:

Is the Discoverer Service running? What happens when you enable Discoverer client tier components? What happens when you disable Discoverer client tier components?
Yes Discoverer client tier components resume normal operation. Existing Discoverer sessions continue as normal, but no new Discoverer sessions are allowed. A message is displayed that informs the Discoverer end user that the component is disabled (for more information, see Section 5.4, "About disabling and enabling Discoverer client tier components").
No Nothing happens immediately.

When you start the Discoverer Service, the Discoverer client tier components resume normal operation.

Nothing happens immediately (for more information, see Section 5.4, "About disabling and enabling Discoverer client tier components").

5.3 About starting and stopping the Discoverer Service

The Discoverer Service comprises the following:

For more information about the Discoverer Service, see Section 1.8.2, "About the Discoverer CORBA components (Discoverer Service)".

You use Application Server Control to start, stop, and monitor the Discoverer Service running on a machine. For example, you might need to start and stop the Discoverer Service for maintenance (e.g. when you apply a Discoverer patch).

Figure 5-5 The Application Server Control Discoverer Home page displaying the Discoverer Service options

Description of Figure 5-5  follows
Description of "Figure 5-5 The Application Server Control Discoverer Home page displaying the Discoverer Service options"

For information about starting or stopping the Discoverer Service, see Section 5.3.1, "How to stop or restart the Discoverer Service on a machine".

Notes

5.3.1 How to stop or restart the Discoverer Service on a machine

You might want to start the Discoverer Service after maintenance. For example, after the Discoverer Service has been stopped to apply a Discoverer patch.

To start and stop the Discoverer Service on a machine:

  1. Display the Application Server Control Discoverer Home page for the machine that you want to configure (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

    Description of em_main.gif follows
    Description of the illustration em_main.gif

  2. Do one of the following:

    • click Restart to start the Discoverer Service

    • click Stop to stop the Discoverer Service

  3. Click Yes at the confirmation page.

5.4 About disabling and enabling Discoverer client tier components

Sometimes you will want to disable and enable end user access to Discoverer client tier components (i.e. Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider).

For example, you might want to:

The Discoverer client tier components behave differently when you disable them, as follows:

5.4.1 How to disable Discoverer client tier components

You might need to disable one or more Discoverer client tier components to perform maintenance. For example, to apply a Discoverer patch, or to restrict user access to a Discoverer component.

To disable Discoverer client tier components:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

  2. Select the Components link to display the Components area.

    Description of oem21.gif follows
    Description of the illustration oem21.gif

  3. In the Components area, select the check box in the Select column for the Discoverer component(s) that you want to disable.

    For example, to disable Discoverer Plus, select the Discoverer Plus check box.

  4. Complete the following steps to disable the selected Discoverer component:

    1. Click Disable.

      Application Server Control displays a warning message.

    2. Click Yes to begin the process that disables the Discoverer component.

      Application Server Control displays a Processing message.

    The Status column displays 'Disabled' for the Discoverer component(s) that you selected.

Notes

  • Alternatively, click a link in the Name column to display the Home page for the component you selected and click Disable.

5.4.2 How to enable Discoverer client tier components

You might need to enable one or more Discoverer client tier components after performing maintenance. For example, after you have applied a Discoverer patch, or to enable user access to a Discoverer component.

To enable Discoverer client tier components:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

  2. Select the Components link to display the Components area.

    Description of oem21.gif follows
    Description of the illustration oem21.gif

  3. In the Components area, select a check box in the Select column for the Discoverer component(s) that you want to enable.

    For example, to enable Discoverer Plus, select the Discoverer Plus check box.

  4. Complete the following steps to enable the selected Discoverer component:

    1. Click Enable.

      Application Server Control displays a warning message.

    2. Click Yes to begin the process that enables the Discoverer component.

      Application Server Control displays a warning message.

    The Status column displays 'Enabled' for the Discoverer component(s) that you selected.

Notes

  • Alternatively, click a link in the Name column to display the Home page for the component you selected and click Enable.

5.5 How to start and stop the Discoverer servlets

You can start and stop the Discoverer servlets (i.e. the Discoverer J2EE components) running on a standalone machine in an OracleAS component farm from any machine in the farm. For example, you might want to perform maintenance tasks on a machine and need to stop the Discoverer servlets.

For more information about the Discoverer servlets, see Section 1.8.1, "About the Discoverer J2EE components".

To start and stop the Discoverer servlets:

  1. Start Oracle Application Server Control and display the System Components page (for more information, see Section 5.1.2, "How to start Application Server Control and display the System Components page").

    Description of oem2.gif follows
    Description of the illustration oem2.gif

  2. In the Name column, select the OC4J_BI_Forms link to display the OC4J_BI_Forms page.

  3. Do one of the following:

    • click Start to start the OC4J_BI_Forms component, which starts the Discoverer servlets (i.e. Discoverer Plus, Discoverer Viewer, Discoverer Portlet Provider)

    • click Stop to stop the OC4J_BI_Forms component, which stops the Discoverer servlets (i.e. Discoverer Plus, Discoverer Viewer, Discoverer Portlet Provider)

    • click Restart to stop and then start the OC4J_BI_Forms component, which starts the Discoverer servlets (i.e. Discoverer Plus, Discoverer Viewer, Discoverer Portlet Provider)

5.6 About configuring the options for the Discoverer Service and Discoverer client tier components

You use Application Server Control to configure options for the Discoverer Service and the Discoverer client tier component as follows:

For more information about how to configure Discoverer and Discoverer component options, see Section 5.6.1, "How to change configuration options for individual Discoverer client tier components".

5.6.1 How to change configuration options for individual Discoverer client tier components

To change configuration options for individual Discoverer client tier components:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

  2. Select the Components link to display the Components area.

    Description of oem21.gif follows
    Description of the illustration oem21.gif

  3. In the Components area, in the Name column, select the Discoverer link (i.e. Discoverer Plus, Discoverer Viewer, or Discoverer Portlet Provider) for the component that you want to configure.

    Oracle Application Server Control displays the Home configuration page for the component you select. For example, select the Discoverer Plus link to display the Home page for Discoverer Plus.

  4. In the General area, select any of links in the Configuration area to display the Configuration page for that component, as follows:

    • The Discoverer Plus Configuration page has the following options:

    • The Discoverer Viewer Configuration page has the following options:

      • the Caching area enables you to enable and disable OracleAS Web Cache

      • the Printing Paper Sizes area enables you to specify paper sizes available for printing

      • the PDF Generation area enables you to specify a PDF resolution and maximum memory settings

      • the Email area enables you to specify an SMTP server for sending email (for more information, see Section D.1.10, "Configuring a SMTP Server for Discoverer Viewer")

      • the Viewer Delay Times area enables you to specify how long to wait before Discoverer Viewer displays a query progress page, or the frequency for checking for export completion

      • the Viewer Logging area enables you to set Discoverer Viewer logging options

    • The Discoverer Portlet Provider Configuration page has the following options:

      • the Discoverer Session area enables you to fine tune the caching for Discoverer portlets in order to maximize Discoverer performance

      • the Portlet Generic Parameters area enables you to specify the number of generic parameters that you want the Discoverer Worksheet Portlet to expose

      • the Portlet Provider Logging area enables you to set Discoverer Portlet Provider logging options

    Note: For more information about configuration fields, see Application Server Control Help. You can also find more information about the settings in the Discoverer Session area in Section A.2, "List of configuration settings in configuration.xml" and in Section 12.3.12, "How to improve Discoverer Portlet Provider performance".

  5. Modify the configuration options as required.

    For more information about each option, see Application Server Control Help.

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

Note: Configuration changes take effect when Discoverer users next log in to Discoverer. You do not have to restart the Discoverer Service or the Discoverer servlets.

5.7 About monitoring Discoverer metrics

As the Discoverer middle tier administrator, you will typically want to analyze system performance by monitoring a number of statistics or metrics. This enables you to easily compare the total resources used by Discoverer with other installed applications and services.

You can use Application Server Control to monitor the following Discoverer metrics:

You can view the Discoverer metrics in two different ways:

For more information about how to monitor Discoverer metrics, see:

Notes

5.7.1 How to monitor summary metrics for all Discoverer client tier components

You might want to monitor metrics for all Discoverer client tier components. For example, to view the total amount of memory or CPU that the Discoverer system is using.

To monitor metrics for all Discoverer client tier components:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

    Description of em_main.gif follows
    Description of the illustration em_main.gif

    The Application Server Control Discoverer Home page displays general information and summary metrics.

    Note the following:

    • The CPU and memory consumption of the Discoverer servlets are not included in this figure (i.e. the Discoverer Viewer, Discoverer Plus, and Discoverer Portlet Provider servlets).

    • If the Current Status indicator is Down, Application Server Control does not display figures for the Uptime, CPU Usage and Memory Usage.

  2. (optional) In the Related Links area, select the All Metrics link to display the All Metrics page.

    The All Metrics page displays an expandable list of performance metrics for Discoverer. You can drill down into individual metrics to show a value for each performance metric. For example, if you select the Discoverer Sessions link, you can monitor metrics for Private Memory Usage and Shared Memory usage for all Discoverer sessions.

    Description of em6.gif follows
    Description of the illustration em6.gif

  3. (optional) Display the Performance tab or page to show session details for all Discoverer client tier components.

    Description of em2.gif follows
    Description of the illustration em2.gif

    The Performance tab or page displays:

    • the total number of sessions

    • a list of the top N sessions ordered by either CPU usage or memory usage

    For more information about the Discoverer session details displayed on this page, see Application Server Control Help.

  4. (optional) Click the file icon in the View Log column on the Performance page to display the View Logs page.

    The View Logs page displays all the log information for the selected Discoverer session.

5.7.2 How to monitor metrics for a single Discoverer client tier component

You might want to monitor metrics for a single Discoverer component (i.e. Discoverer Plus, Discoverer Viewer, or Discoverer Portlet Provider). For example, you might want to find out exactly how many sessions are currently used by Discoverer Plus users compared to Discoverer Viewer users.

To monitor metrics for a single Discoverer client tier component:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

    Description of em_main.gif follows
    Description of the illustration em_main.gif

  2. Select the Components link to display the Components area.

    Description of oem21.gif follows
    Description of the illustration oem21.gif

  3. In the Name column of the Components area, select the Discoverer link for the component that you want to monitor.

    For example, select the Discoverer Plus link to display the Home page for Discoverer Plus.

    Application Server Control displays the Home page for the Discoverer component that you selected.

    Each Discoverer component Home page displays general information and summary metrics. The Discoverer component home page is similar to the metrics on the Application Server Control Discoverer Home page, except that the metrics are specific to the displayed Discoverer component.

  4. (optional) Display the Performance page to show session details for the selected Discoverer component.

    The Performance page displays:

    • the total number of sessions for this Discoverer component

    • a list of the top N sessions for this Discoverer component, ordered by either CPU usage or memory usage

    For more information about the Discoverer session details displayed on this page, see Application Server Control Help.

  5. (optional) Click the file icon in the View Log column on the Performance page to display the View Logs page.

    The View Logs page displays log information for the selected Discoverer session.

Notes

  • The CPU and memory consumption of the Discoverer servlets (i.e. the Discoverer Viewer, Plus and Portlet Provider servlets) are not included in this figure.

  • If the Current Status indicator is Down, Application Server Control does not display figures for the Uptime, CPU Usage and Memory Usage.

  • Discoverer Plus OLAP connects directly the database, and does not create sessions on the middle tier.

5.8 How to list ports used by Oracle Application Server

Discoverer uses the same listen ports as the Oracle HTTP Server (of type Listen or Listen (SSL)).

To see a list of ports used by Oracle Application Server:

  1. Start Oracle Application Server Control and display the System Components page (for more information, see Section 5.1.2, "How to start Application Server Control and display the System Components page").

    Description of oem2.gif follows
    Description of the illustration oem2.gif

  2. Display the Ports tab.

    Description of ports.gif follows
    Description of the illustration ports.gif

Refer to the value in the Port In Use column for the Oracle HTTP Server component in the Component column (for type Listen or Listen (SSL)).

For information about changing the default OracleAS ports for OracleAS components, see Section 5.8.1, "How to change the port on which Discoverer is deployed".

5.8.1 How to change the port on which Discoverer is deployed

To change the port on which Discoverer is deployed:

  1. Start Oracle Application Server Control and display the System Components page (for more information, see Section 5.1.2, "How to start Application Server Control and display the System Components page").

    Description of oem2.gif follows
    Description of the illustration oem2.gif

  2. Display the Ports tab.

    Description of ports.gif follows
    Description of the illustration ports.gif

  3. In the rows containing the Oracle HTTP Server component (Type=Listen), select the edit icon in the Configure column to display the Server Properties page for that component.

    Description of infra4.gif follows
    Description of the illustration infra4.gif

  4. Scroll down to the Listening Addresses and Ports area and change the port number in the Default Port field.

  5. Click OK.

  6. When you are prompted to restart the Oracle HTTP Server, click Yes.

    For more information about the Server Properties page in Application Server Control, see Application Server Control Help.

    Hint: If you change a Discoverer port number, make sure that any other OracleAS components that use that Discoverer port number are synchronized.

5.9 About running Discoverer Plus with different Java Virtual Machines

OracleBI Discoverer Plus supports the following default Java Virtual Machines (JVMs):

You might want to change the JVM in the following circumstances:

Note: If you use a different JVM, you must ensure that it is certified to work with Oracle Business Intelligence.

If Discoverer Plus users use Apple Mac OS X client machines, you must specify the Sun Java Plug-in on the Discoverer middle tier (for more information, see Section 5.9.1, "How to specify a different Java Virtual Machine for Discoverer Plus").

You can specify a different JVM in one of two ways:

5.9.1 How to specify a different Java Virtual Machine for Discoverer Plus

To specify a different Java Virtual Machine for Discoverer Plus:

  1. Display the Application Server Control Discoverer Home page (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

    Description of em_main.gif follows
    Description of the illustration em_main.gif

  2. Select the Discoverer Plus link to display the Application Server Control Discoverer Plus Home page.

    Hint: To display the Discoverer Plus link, either scroll down the page to the Components area, or select the Components link.

    Description of em_plus.gif follows
    Description of the illustration em_plus.gif

  3. Select the Java Plugin link to display the Java Plug-in area.

    Description of em_plus3.gif follows
    Description of the illustration em_plus3.gif

  4. Select an option (e.g. Sun Java Plug-in <version>) from the Java Plugin drop down list.

    Note: If Discoverer Plus users use Apple Mac OS X client machines, you must select the Sun Java Plug-in option (for more information about using Discoverer Plus on Apple Mac client browser machines, see Section 3.6, "About running Discoverer Plus over HTTP for the first time on a client machine").

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

5.9.2 How to specify your own Java Virtual Machine for Discoverer Plus

To specify your own Java Virtual Machine for Discoverer Plus:

  1. Open the configuration.xml file in a text editor or XML editor (for more information about the location of configuration files, see Section A.1, "List of Discoverer file locations").

  2. Locate the jvm attributes for the plus element.

    Description of jvm.gif follows
    Description of the illustration jvm.gif

  3. Edit the jvm attributes for the plus element.

    For example, change the version or URL of the JVM.

    Hint: To change the Java Plug-in details, edit the <jvm name = "sun" ...> entry. To change the JInitiator details, edit the <jvm name = "jinitiator" ...> entry.

  4. Save the configuration.xml file.

    The specified JVMs will now be available to use for Discoverer Plus sessions.

    Hint: Make sure that you have selected the correct JVM in Oracle Application Server Control. For example, if you specify a different JInitiator version in the configuration.xml file, make sure that you select JInitiator in Oracle Application Server Control (for more information, see Section 5.9.1, "How to specify a different Java Virtual Machine for Discoverer Plus").

5.10 About configuring Discoverer to export to Web Query format

Microsoft Excel Web Query is an external data format in Microsoft Excel that enables you to include dynamic data from a URL (e.g. a Discoverer worksheet) in a Microsoft Excel worksheet. For example, you might want to create a Microsoft Excel worksheet that contains a Discoverer sales report for a range of dates that you specify when you open the worksheet in Microsoft Excel. The Microsoft Excel worksheet stores the query used to obtain the Discoverer data, so that the data can be refreshed automatically.

You can export data to Web Query format from Discoverer Plus and Discoverer Viewer.

Note: To access Discoverer data in Web Query format, you need Microsoft Excel 2000 or later.

Discoverer enables Microsoft Excel Web Query format by default using the default Discoverer URL "http://machine-name:port/discoverer/viewer". If you want to disable Microsoft Excel Web Query format or change the Discoverer URL, you must add the following preferences to the pref.txt file on each Discoverer host:

Note: The EnableWebqueryRun preference enables you to turn the Discoverer response on or off when a query is run in Microsoft Excel.

For more information about preferences, see Chapter 10, "Managing OracleBI Discoverer preferences".

Notes