Dimension Design 101

This is the second post for SSAS week at SQL University. If you're just joining the class, go back to the first post, Why Do I Need a Cube & How Do I Get Started, to get your bearings and get your environment ready, and then join me back here. Today, I'll walk you through the basic steps of building dimensions. Then, later in the week, I'll cover cube construction and also discuss various cube enhancements that you can make, security measures to implement, and tools that enable user access to cube data.