1
Introduction

This chapter provides an introduction to the Oracle9i Clickstream Intelligence Builder.

It contains the following sections:

• Introduction to Oracle9i Clickstream Intelligence Builder

• Using the Clickstream Intelligence Builder

Introduction to Oracle9i Clickstream Intelligence Builder

Welcome to Oracle9iAS Clickstream Intelligence and the Oracle9i Clickstream Intelligence Builder!

Oracle9iAS Clickstream Intelligence is a Web-based analytical tool that enables you to acquire, process, and report on Web interactions with customers, suppliers, and employees. Oracle9i Clickstream Intelligence Builder enables you to customize Oracle9iAS Clickstream Intelligence. It one of the Business Intelligence tools provided by Oracle9i Developer Suite (Oracle9iDS), a comprehensive and integrated development environment for building and assembling e-business applications.

The Oracle9i Clickstream Intelligence Data Model Reference contains the data model for Oracle9i Clickstream Intelligence. This data model, comprised of 14 core dimensions and 2 fact tables, serves as the extensible framework for Clickstream Analytics. The generic dimensions included in the Clickstream database schema also facilitate customer extensions to the Clickstream Intelligence product.

Using the Clickstream Intelligence Builder

The Oracle9i Clickstream Intelligence Builder can be used to extend Clickstream Intelligence in two ways:

• Extend the Clickstream data model - Add dimensions, define new levels, and make other modifications to the Clickstream Intelligence schema.

• Extend Clickstream Analytics - Define new analytical reports that are customized to your business needs.

Extending the Data Model

Extending the Clickstream data model enables the integration of other data sources and data types that are not already characterized by the 14 pre-defined core dimensions. To utilize Clickstream's extensible platform, Oracle Warehouse Builder (OWB) must be installed on your computer. You must import the metadata loader (mdl) file that contains the Clickstream Project into an existing OWB repository. This file is located in the following directory:

• (UNIX) ORACLE_HOME/click/admin/repository/click.mdl

• (Windows) ORACLE_HOME\click\admin\repository\click.mdl

For further information about importing metadata into the OWB repository and using the OWB Client to access the repository containing Clickstream Intelligence, please reference the Oracle Warehouse Builder User's Guide.

Extending Clickstream Analytics

Extending Clickstream's reporting capabilities enables you to create unique analytical reports that are customized to your specific business needs. To do this, you must extend the pre-defined Clickstream End User Layer (EUL) that is installed in your dedicated Clickstream database. For detailed instructions about installing a database for use with Clickstream Intelligence, please reference Appendix B, "Installing a Dedicated Clickstream Database," in the Oracle9iAS Clickstream Intelligence Administrator's Guide. To learn more about creating and populating EULs, see the Oracle9i Discoverer Administrator Administration Guide. To learn about creating and viewing new reports with Oracle9i Discoverer Plus, see the Oracle9iAS Discoverer Plus User's Guide.

The chapters that follow describe the 14 core dimensions and 2 fact tables that comprise the Clickstream Intelligence data model. Each chapter describes a dimension, and lists all corresponding hierarchies, levels, and level attributes. The last two chapters describe all attributes of the Impression and Session fact tables, respectively.