My bachelor degree's thesis is making a Web Server Log Miner using OLAP
technology.
I've clean an transform the raw dataset to the database using SQL
Server.
In order to build cube, my lecturer not allow me to using analysis
service in SQL SERVER. So I must develop a tool ( but not as complex as
in SQL Server) using Delphi.
The Transaction Log's Field is :
- HomePage
- IPAddress
- RequestFile
- File Size
- File Type
- Status
- Date and Time
- Operating System
- Referrer Link

Now, I'm asking suggestion in what Dimensions should I use in this
transacation Log ? And how about the design of Facttable ?

Thx,
Tan Chin Yen

Try,

Looking at which items you want to report on, how they relate 1:N, M:N,
M:1 , this will give you dimensions and attributes within the
dimensions.

Possible Candidates
-----------------------------
Session/Visit (Which will contain a user or depending on schema style
have a FK to user, User Agent, IP Address if you want to assume that a
user can have only one IP (First or last))
Page (this can be further classified by contect, directory etc)
Site(I think you meant this by HomePage, this matters if you multiple
sites adn they share pages M:N, other server if a property or parent of
Page)
Status Code (If you want to report on this)
Date/Time

As for the fact table, its going to be a simple combination of the
chosen dimensions and maybe file size.

This is not a final solution but should get you going.