Bill Pearson: Build a Web Site Traffic Analysis Cube: Part II

In this article, we will enter the design and build phases of the design and construction of a Web Site Traffic Analysis Cube, which we began in Part I, and from which we will emerge with a cube. After we have generated the cube, we will perform browses of the data it contains to examine the results of our handiwork.

The topics within Part II of this two-part article include:

Creation of a database in Analysis Services;
Connection of the new database to the relational source table;
Creation of a measure for our Web Site Traffic Analysis cube;
Creation of dimensions and levels for our cube, including the manual creation of a simple Time dimension;
Incorporating drillthrough into our cube design.
Performance of browse activities against the new Web Site Traffic Analysis cube using the integrated Cube Browser;
Performance of drillthrough on a summary value within the Browser to its supporting detail in the relational data source;
Verification of the results of our drillthrough exercise, using an independent query against the source data in MSSQL Server.

Read the Article ...

SYNOPSIS & CONCEPTS :

Synopsis:

MSAS Architect Bill Pearson returns to an examination of meeting the real world business need of a web site owner to analyze traffic. We conclude the design and construction of the Web Site Traffic Analysis Cube begun in Part I. After we have generated the cube, we will perform browses of the data it contains to briefly examine the results.

Concepts:

Analysis Services
DTS
Data Transformation Services
Access Log
Database

Traffic Analysis
Web
Site
Dimension
Time
Statistics
Data Connection
Browse
OLAP
Import
Relational
Table
Business Intelligence
Query
Navigation
Member
Drill down
Drillthrough
Format

About the Series:

This article is a member of the series Introduction to MSSQL Server 2000 Analysis Services. The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services, with each installment progressively adding features and techniques designed to meet specific real - world needs. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial article, Creating Our First Cube.

Analysis Services, DTS, Data Transformation Services, Access Log, Database, Traffic analysis, Web , Site, Dimension, Time, Statistics, Browse, OLAP, Import, Relational, Table, Business Intelligence, Query, Navigation, Member, Drill down, Drillthrough, Format

All Contents Copyright Island Technologies Inc. ^® Island Technologies^® and Island Technologies Inc.^® are registered trademarks of Island Technologies Inc., protected in the United States and other countries. For information, contact Island.

Previous page

The articles guide continues on the next page

Next page