Expert Cube Development with SSAS Multidimensional Models
上QQ阅读APP看书,第一时间看更新

Chapter 3. Designing More Complex Dimensions

At this point in the cube design process we should now have a simple cube deployed and processed, and our users will be telling us what they like and don't like. Once we've taken their feedback on board, it's time to move on to tackle some of the more complex problems. In this chapter, we'll take a look at some specific issues related to dimension design:

  • Grouping and banding
  • Handling the different types of slowly changing dimensions
  • Junk dimensions
  • Modeling ragged hierarchies with parent/child hierarchies and the HideMemberIf property