Skip Headers

Oracle9iAS Clickstream Intelligence User's Guide
Release 2 (

Part Number A90888-02
Go To Documentation Library
Go To Product List
Solution Area
Go To Table Of Contents
Go To Index

Go to previous page Go to next page

Getting Started

Getting Started

This chapter introduces Oracle9iAS Clickstream Intelligence Analytics (Clickstream Analytics). It contains the following sections:

Oracle9iAS Clickstream Intelligence Analytics

As a marketing expert, corporate IT specialist or other business professional, you rely on up-to-date information about your company's performance. Analysis of Web site traffic can be used to effectively assess company growth and performance within your industry sector, and may support business decisions that influence the future direction and success of current company-wide initiatives and project plans. Detailed analysis of clickstream data from your company's Web site may provide answers to critical questions related to customer satisfaction and product popularity. Have site visits increased this month? Were campaigns for the summer product line successful? How many error messages were generated by your Web servers last month, and how has this affected customer rentention? Clickstream Analytics provides you with the data used to identify and solve many of your industry's most important questions - without having to know anything about a database.

As an integrated business intelligence component of Oracle9i Application Server, Clickstream Analytics leverages the powerful data analysis tools of Oracle9iAS Discoverer to display both pre-defined and customized analytical reports (worksheets). You can take advantage of the functionality in both Oracle9iAS Discoverer Viewer (Discoverer Viewer) and Oracle9iAS Discoverer Plus (Discoverer Plus) to produce strategic business reports that graphically illustrate Web site usage, trends, effectiveness, and more. To determine whether Discoverer Viewer or Discoverer Plus is best suited to your analytical reporting needs, consult with your company's System Administrator, or administrator for Clickstream Analytics (also referred to as your Clickstream Administrator).

Discoverer Viewer Overview

Discoverer Viewer is an application that runs within your Internet browser. It enables users to view and rearrange data displayed in Clickstream Analytics worksheets. It is best utilized by business professionals who want to review clickstream data stored in the database, but do not want to define new reports. If your reporting needs include spontaneous data analysis, creation of new Clickstream Analytics worksheets, or modification of existing worksheets, Discoverer Plus (see next section) should be used instead of Discoverer Viewer. To learn more about Discoverer Viewer, access the Discoverer Viewer online help through your Internet browser.

Discoverer Plus Overview

Discoverer Plus is a robust Java-based application that enables power users, data analysts, marketing specialists, and report-builders to:

As with Discoverer Viewer, Discoverer Plus also enables users to view pre-defined workbooks and worksheets via Internet browser. To learn more about the capabilities and functionality of Discoverer Plus, please reference the Oracle9iAS Discoverer Plus User's Guide, or access the Discoverer Plus online help.

Launching Oracle9iAS Clickstream Intelligence Analytics

To launch and access Clickstream Analytics, open a standard Internet browser (such as Netscape Navigator or Microsoft Internet Explorer) and enter the URL provided to you by your System Administrator.


Your User Name, your Password and URL will be provided by your System Administrator. The URL will follow this format http://HOST:PORT/click/

Logging In/Logging Out

When you want to access or log in to Discover Viewer/Plus for the first time, you may be transported directly to the connection page of the application you selected on the Clickstream Intelligence Components page, or you may be prompted to log in with your Oracle Single Sign-On ID.

Once on the Connect to Discoverer Viewer/Plus page, you can select a public connection from those that appear in the Connections table, or you can create a private connection. Public connections are created by your Oracle9iAS Clickstream Intelligence or Oracle9iAS Discoverer Administrator and can be accessed by any particular user.

Private connections are created by individual users and are specific to the browser and computer on which they were created. For example, if you access Discoverer Viewer or Discoverer Plus with another type of browser (such as Netscape), your private connection will not be displayed. Similarly, your private connection is not be accessible from a computer that is different from the one on which the connection was created. For more information on creating private Oracle9iAS Discoverer connections, see the Oracle9iAS Discoverer User's Guide.


You can have access to several public and private connections. Each connection operates independently.

Logging in to Oracle9iAS Clickstream Intelligence Analytics

  1. Launch a Web browser and enter the Clickstream Analytics URL.

  2. Enter your Oracle Single Sign-On user name and password in the fields provided and click the Login button. (If you have already logged in, Clickstream Analytics skips this step.)

  3. Select the Oracle9iAS Discoverer tool with which you want to view Clickstream Analytics.

  4. Select a public or private connection from the list of available connections.

Logging out of Oracle9iAS Clickstream Intelligence Analytics

Logging Out with Discoverer Viewer

To log out of Discoverer Viewer, click the Exit button. You can also close your browser window.

Logging Out with Discoverer Plus

To log out of Discoverer Plus, select File | Exit. If you have any unsaved work, a dialog box will prompt you to save your data or simply exit the application. Due to the risk of losing unsaved data, is not recommended that you log out of Discoverer Plus by closing your browser window.

Discoverer Viewer Interface

The Discoverer Viewer user interface (UI) is divided into four areas: the Global Buttons area; the Navigation area; the Content area; and the Footer area. The location of these areas are displayed in the figure below. Information about each interface area is provided in the sections that follow.

Figure 2-1 Discoverer Viewer Interface

Text description of click_ui.gif follows.

Text description of the illustration click_ui.gif

Key to figure:

    1. Global Buttons Area

    2. Navigation Area

    3. Content Area

    4. Page Footer

Global Buttons Area

The Global Buttons area is located in the top right corner of the Discoverer Viewer user interface. It contains buttons for accessing content or functional areas global to the application. The following buttons appear:

Exit Button

Click the Exit button to close the browser window and log out of Discoverer Viewer.

Preferences Button

Click the Preferences button to configure the way in which Discoverer Viewer queries the data gathered and stored by Oracle9iAS Clickstream Intelligence. The following options are available:

Detailed explanations of these options appear in Options for Modifying Database Queries in Chapter 3.

Help Button

Click the Help button to access an online help system that documents the Discoverer Viewer user interface.

Navigation Area

The Navigation area is located beneath the Global Buttons area. The Navigation area includes a Side Navigation Menu that is located on the left side of the interface. The Navigation area always contains a horizontal blue bar that stretches across the Discoverer Viewer user interface. The links on the Side Navigation menu appear and disappear as appropriate.

Side Navigation Menu

The Side Navigation menu is vertically attached to the left side of the UI, located below the Oracle9iAS Discoverer logo. When you open a workbook, this menu displays the worksheets contained within the workbook. If no links are available, the menu does not appear.

Content Area

The Content area of the UI is the largest part of the interface, located beneath the Oracle9iAS Discoverer logo and above the Page Footer. You'll do most of your work in this interface region. Specifics about the form and function of the Content area appear in the following sections:

Main Page Content

This section describes what you'll see in the Content area after you log in to Clickstream Analytics and the work you can do.

Workbook Content

This section describes what you'll see in the Content area after you open a workbook.

Worksheet Content

This section describes what you'll see in the Content area after you select a worksheet from the workbook you opened.

Main Page Content

After you log in, the main Discoverer Viewer page displays. Two elements appear in the Content area. These elements are described below:

Workbook Search Area

The Workbook Search area enables you to search the workbooks available in Oracle9iAS Clickstream Analytics and display your search results.

To search, select a workbook type from the drop-down list (for example, database workbooks or scheduled workbooks). Then, enter the search term in the text field and click Go. By default, the workbook list is unfiltered. It contains all the workbooks available for the workbook type you selected. The name and a description of each workbook matching the search criteria are stored in the List of Workbooks table. To access the worksheets within a particular workbook, click the title of the workbook. The results in the Workbook Search area are session-dependent. Each time you start a new session, an unfiltered list of workbooks appears.

List of Workbooks

The List of Workbooks table contains two columns. The first column contains the workbook's name. The second column contains the workbook's description.

Workbook Content

When you open a workbook, the Content area displays a parameter selection screen. In addition, a Horizontal Navigation bar appears with links to all the worksheets contained in the workbook. The parameters that appear in the Content area are associated with whichever worksheet link is highlighted on the Side Navigation bar. A complete description of how to apply parameters to a worksheet appears in "Getting the Data You Want from Worksheets" in Chapter 3.

Worksheet Content

The worksheet Content area exists in two distinct states: pre-query and post-query. As you query the database, the Content area displays the parameters associated with whichever worksheet link is highlighted on the Side Navigation bar. After the query completes, the query report, which normally contains text and graphics, appears in the Content area.

Page Footer

The Page Footer appears at the bottom of the Discoverer Viewer UI. Specifically, it is located below the gold-colored bar at the bottom of the Content area. The Footer area always contains a link to Oracle copyright information, a link to the XML code used to create the content contained in the Content area, and the version number associated with your copy of Discoverer Viewer. When worksheet data appears in the Content area, a button for printing data is displayed in the Page Footer.

Discoverer Plus Interface

The Discoverer Plus UI is described below. For a complete discussion of the functionality of Discoverer Plus, see the Oracle9iAS Discoverer User's Guide.

Figure 2-2 Discoverer Plus Interface

Text description of click_di.gif follows.

Text description of the illustration click_di.gif

Key to figure:

    1. Menu Bar

    2. Toolbar

    3. Work Area

    4. Top Axis

    5. Data Points

    6. Worksheet Navigation Buttons

    7. Worksheet Tabs

    8. Scroll Bar

    9. Sheet Format Button

Menu Bar

The Menu bar appears at the top of the interface. It contains links to drop-down lists that contain all Discoverer Plus functions. To access a specific Discoverer Plus function, click the appropriate link.


The Toolbar appears beneath the Menu bar. It provides icons that enable you to quickly access the most popular Discoverer Plus menu items (for example, Save, Open, Print, Filter, and so on).

Work Area

The Work area appears beneath the Menu bar and Tool bar and above the Worksheet Navigation buttons. All data generated by a database query appears here.

Top Axis

The Top axis in a Discoverer Plus worksheet contains the names of the columns that appear in that worksheet.

Data Points

Data points appear within a worksheet and are the item values generated by an Clickstream Analytics query.

Worksheet Navigation Buttons

The Worksheet Navigation buttons appear at the bottom left of the interface above the Worksheet tabs. They enable you to navigate through worksheets that contain multiple pages of data.

Worksheet Tabs

The Worksheet tabs appear beneath the Work area. The Worksheet tabs provide access to the worksheets available in the workbook that is currently open. To open a worksheet, click its tab.

Scroll Bar

Use the Scroll bar to scroll through worksheet data.

Sheet Format Button

The Sheet Format button appears at the bottom right of the interface above the Worksheet tabs. Use this button to set the number of data rows displayed by a worksheet.

Go to previous page Go to next page
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Go To Product List
Solution Area
Go To Table Of Contents
Go To Index