Oracle9i Clickstream Intelligence Data Model Reference Release 2 (9.0.2) Part Number A96129-01 |
|
This chapter provides an introduction to the Oracle9i Clickstream Intelligence Builder.
It contains the following sections:
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.
The Oracle9i Clickstream Intelligence Builder can be used to extend Clickstream Intelligence in two ways:
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:
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'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.
|
![]() Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|