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

Oracle Discoverer 3i Viewer Edition can be accessed from other web applications by specifying a combination of parameters 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 Edition 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 Parameters in URLs

Using parameters in a URL can be used to specify specific factors when accessing Oracle Discoverer 3i Viewer Edition from other applications it saves your end users time and gives you control over the data they use.

You can specify username, database, EUL, workbooks, worksheets and worksheet pages through parameters placed in the URL. Passwords are generally not displayed in the URL for security reasons.

4.1.1 Specifying username, database

Format for each parameter is:

&us=<username>
&db=<databasename>

http:mywebserver/disco3iv?us=<username>&db=<databasename>

4.1.2 Specifying display of the Applications User Checkbox in Connect Dialog

You can configure the disco3iv.xml file so that the connect dialog enables or disables display of the Applications User checkbox:
For details see the configuration file located in %3IV_ROOT_PATH%\html\disco3iv.xml for details

See also Section 2.3.4.4.2, "Specifying display of the Applications User Checkbox in Connect Dialog,"

4.1.3 Specifying a workbook in a URL:

Format for parameter is:

&wb=<wkbkname>

You MUST also specify the username and database name (see above). The order used is not important:

http://myserver/disco3iv?us=<username>&db=<databasename>&wb=<workbookname>

An Example is:

http://myserver/disco/disco3iv?us=qstats&db=disco&wb=nobugs

4.1.4 Specifying a worksheet

This is similar to workbook above.

Format for parameter is:

&ws=<worksheetname>

You must also specify the workbook name, username and database name. These parameters do not have to be in a specific order but they must be entered after the question mark?:

http://mywebserver/disco3iv?us=<username>&db=<databasename>&wb=<workbookname>&ws=<worksheetname>

An Example is:

http://myserver/disco/disco3iv?us=qstats&db=disco&wb=nobugs&ws=Sheet+1

4.1.5 Specifying worksheet parameters

Format for parameter is:

&qp_<parameter_name>=<parameter_value>

You must also specify the workbook, worksheet name, username and database name. These parameters do not have to be in a specific order but they must be entered after the question mark?:

http://myserver/disco3iv?us=<username>&db=<dbname>&wb=
<workbookname>&ws=<worksheetname>&qp_<parameter_name>=
<parameter_value>

An Example is:

http://myserver/disco/disco3iv?us=video33&db=video33&wb=wb1&ws=ws2&qp_City=
Denver&qp_City=Los+Angeles&qp_Year=1995

The query string specifies Denver and Los Angeles as values for the City parameter and 1995 as the value for the Year parameter for the worksheet with id ws2, in the workbook with the id wb1, in the database - name video33 with user name video33.

4.1.6 Specifying a page number

This is similar to worksheet above.

Format for parameter is:

&pg=<pagenumber>

You must also specify the workbook, worksheet name, username and database name. These parameters do not have to be in a specific order but they must be entered after the question mark?:

http://myserver/disco3iv?us=<username>&db=<dbname>&wb=<workbookname>&ws=<worksheetname>&pg=<pagenumber>

An Example is:

http://myserver/disco/disco3iv?us=video33&db=video33&wb=wb1&ws=ws2&pg=2

The query string specifies the second page in worksheet with id ws2, in the workbook with the id wb1, in the database - name video33 with user name video33.

Note: If the servlet was supplied this query string the user would be challenged for a password, before opening the worksheet.