Cube Construction 101

This is the third post for SSAS week at SQL University. If you're just joining the class, refer to Why Do I Need a Cube & How Do I Get Started and Dimension Design 101 to get caught up. At this point, my expectation is that you have an Analysis Services project with at least two dimensions designed-Date and Product. Now you're ready to build the cube itself. In a later post, I'll discuss various cube enhancements that you can make, security measures to implement, and tools that enable user access to cube data.