I've just posted a new video about the Cube Wizard in Analysis Services 2005. The Cube Wizard is used to create cubes and, as shown in the video, it can also create dimensions, including the attributes and hierarchies in dimensions. I point out some of the things to make sure you do, such as getting the fact and dimension tables correct and setting up a time dimensions, while also pointing out problem areas, such as the hierarchies that are sometimes created. This video runs 16.5 minutes and will be followed up by a video about the Cube Wizard in Analysis Services 2008, which takes a very different approach.