- Expert Cube Development with SSAS Multidimensional Models
- Chris Webb Alberto Ferrari Marco Russo
- 97字
- 2021-08-13 18:02:59
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
HideMemberIfproperty