Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Creating an Internet Tracking Cube

Sometimes you might have information in a table that doesn’t look like a standard star schema, with separate fact and dimension tables. For example, suppose that your company has a Web site and maintains a log of people who visit the site. In such a situation, the log file might contain nothing more than a Visitor ID and a date—certainly no discernible measure column. You need to be able to create a cube from a “fact” table that doesn’t have a measure.

Also, the Analysis server has a limitation that there can be no more than approximately 64,000 children for any one parent in a hierarchy. A log of visitors could easily exceed that number of different visitors many times over, with no information available for ...