Expert Cube Development with SSAS Multidimensional Models

Summary

In this chapter, we discussed how to deal with some common problems we might face when designing our Analysis Services dimensions: grouping and banding members and numeric values; slowly changing dimensions; junk dimensions; ragged hierarchies; and parent/child hierarchies. We found that we can create new attributes on a dimension to group members and create bandings for numeric values using some simple SQL. This can have a positive impact on the user's experience. We also found that with a bit of thought, the three different types of SCDs can all be modeled satisfactorily. With ragged hierarchies, we learned that the parent/child hierarchies are very flexible, but have several problems, especially with query performance, and should be ...