Oracle Discoverer 3i Viewer Configuration Guide for Oracle9i Application Server for Windows Release 3.3.57 A87361-01 |
|  |  | Contents

# 4
Accessing Oracle Discoverer 3i Viewer From Other Web Applications

Oracle Discoverer 3i Viewer can be accessed from other Web applications by specifying a combination of arguments in the URL. Rather than having your end users log in, choose a workbook, and worksheet, you can specify a URL that starts the Oracle Discoverer 3i Viewer for them. You can explicitly specify the settings that you want; for example, you can specify which workbook and worksheet you want to open and which parameter values to use.

This means you can embed live Discoverer reports directly onto your Web site pages simply by specifying the details in a URL. When the link is clicked the database is queried and the latest data is displayed in HTML.

After you create this URL, you can give it to end users to type into their Web browser. Or you can add the URL as a link on your company's Intranet site so that end users can make a specific database query with a single click.

In addition, you can also specify an end user's Applications Responsibility in this same URL.

## 4.1 Using arguments in URLs

You can specify username, database, EUL, workbooks, worksheets and worksheet pages as arguments placed in the URL.

Passwords are generally not displayed in the URL for security reasons. Discoverer 3i Viewer will ask users for a password before opening a worksheet.

### 4.1.1 What is the format of the URL to start Discoverer 3i Viewer automatically?

The URL you create must adhere to the standard URL command line syntax as follows:

http://mywebserver.mycompany.com/servletname?arg1=value1&arg2=value2&...&argN=valueN

where:

mywebserver is the Discoverer Server instance name

mycompany.com is your company nae

servletname is the location and name of the Discoverer 3i Viewer servlet

The URL must always include the following mandatory arguments:

- username

- database name

- workbook name

- worksheet name

Note that the order of the mandatory arguments is not important, but all of the mandatory arguments must be present in the URL.

In addition to the mandatory arguments, you can also include the following optional arguments:

- worksheet parameters

- page numbers

### 4.1.2 Mandatory URL arguments

In all the examples below, the URL specifies:

- video33 as the username

- video33 as the database name

- sales as the workbook name

- ws2 as the worksheet name

#### 4.1.2.1 Username

Format: | &us=<username>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=Sheet+1

#### 4.1.2.2 Database

Format: | &db=<databasename>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=Sheet+1

#### 4.1.2.3 Workbook

Format: | &wb=<workbookname>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=Sheet+1

#### 4.1.2.4 Worksheet

Format: | &ws=<worksheetname>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=Sheet+1

### 4.1.3 Optional URL arguments

#### 4.1.3.1 Worksheet parameter

Format: | &qp_<parameter_name>=<parameter_value>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=ws2&qp_City= Denver&qp_City=Los+Angeles&qp_Year=1995

In the example, the URL specifies:

- video33 as the username

- video33 as the database name

- sales as the workbook name

- ws2 as the worksheet name

- Denver and Los Angeles as values for the City parameter

- 1995 as the value for the Year parameter

#### 4.1.3.2 Page number

Format: | &pg=<page_number>
Example: | http://mywebserver.mycompany.com/disco/disco3iv ?us=video33&db=video33&wb=sales&ws=ws2&pg=4

In the example, the URL specifies:

- video33 as the username

- video33 as the database name

- sales as the workbook name

- ws2 as the worksheet name

- 4 as the page of worksheet ws2 to display

| Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|  |  | Contents