Archive | June, 2011

Cubing IIS Logs

Using the data warehouse built in the <a title=”Data Warehousing IIS Logs” target=”_blank” href=””>previous post and SQL Server Analysis Services (SSAS) we can cube our log data.  The most compelling reason to create a data cube for the log data was to gain access to MDX (MultiDimensional eXpression). MDX comes with a great deal more built in […]

Continue reading

Data Warehousing IIS Logs

Previously, I discussed using LogParser 2.2 to load IIS logs into SQL Server. Continuing on with my prototype for reporting on IIS Log data, I roughed out a data warehouse for the log data – the schema is below.

Continue reading