|Oracle9iAS Clickstream Intelligence User's Guide
Release 2 (220.127.116.11)
Part Number A90888-02
This chapter introduces Oracle9iAS Clickstream Intelligence Analytics (Clickstream Analytics). It contains the following sections:
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 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 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.
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://
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.
To log out of Discoverer Viewer, click the Exit button. You can also close your browser window.
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.
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.
Key to figure:
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:
Click the Exit button to close the browser window and log out of Discoverer Viewer.
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.
Click the Help button to access an online help system that documents the Discoverer Viewer user interface.
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.
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.
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:
This section describes what you'll see in the Content area after you log in to Clickstream Analytics and the work you can do.
This section describes what you'll see in the Content area after you open a workbook.
This section describes what you'll see in the Content area after you select a worksheet from the workbook you opened.
After you log in, the main Discoverer Viewer page displays. Two elements appear in the Content area. These elements are described below:
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.
The List of Workbooks table contains two columns. The first column contains the workbook's name. The second column contains the workbook's description.
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.
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.
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.
The Discoverer Plus UI is described below. For a complete discussion of the functionality of Discoverer Plus, see the Oracle9iAS Discoverer User's Guide.
Key to figure:
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).
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.
The Top axis in a Discoverer Plus worksheet contains the names of the columns that appear in that worksheet.
Data points appear within a worksheet and are the item values generated by an Clickstream Analytics query.
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.
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.
Use the Scroll bar to scroll through worksheet data.
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.