O'Reilly logo

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX by Denny Guang-Yeu Lee, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Sivakumar Harinath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

25.4. Step-by-Step Guide

It is important to note here that many more complex concepts within Web Analytics are not covered in this chapter. Recall that the purpose of this section is to provide a step-by-step guide on how to build a basic Web Analytics cube on top of web log information. Therefore, in this section we review:

  • Basic parsing of a web log file

  • Simple web log transformation

  • Transforming the page path

  • Creating the fact table

  • Identifying visitors and sessions

  • Creating the Analysis Services cube (and its many steps)

This section uses files that you can download from www.wrox.com.

25.4.1. Reviewing the Log File

Let's start with the included log file ex20071217.log, which is an IIS 6.0 W3C format log file (see Figure 25-2). Please note that this is a test log file, not an actual log file, because we do not want to be sharing personal information.

Figure 25.2. Figure 25-2

25.4.2. Parsing the Web Log

As you can see from the log file, there are a number of columns and parameter-value pairs that you need to parse through in order to extract the data that you need. Though there are many methods that can be used, a handy and straightforward tool to do this is the Log Parser tool that is available at support.microsoft.com/kb/910447. Download the logparser tool from the link provided and install it on your machine. For more information about the logparser, I would also recommend ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required