The Blueprint for Proper SSAS Dimensions
Creating dimensions in SQL Server Analysis Services is easy, but creating them properly can be challenging. Failing to create dimensions that adhere to best practices can lead to cubes that are both slow and difficult to browse. Fortunately, learning how to create dimensions that are fast and provide easy analysis for your users is simple, but expect to spend a fair amount of time creating the dimensions and configuring the parameters.