Chapter 9

Advanced Cube Design

What's in this chapter?

  • Working with measure groups and measures
  • Understanding cube dimensions
  • Exploring actions, Drillthrough, and Key Performance Indicators
  • Extending cube intelligence
  • Understanding cube storage and partitioning
  • Building cube aggregations
  • Exploring real-time cubes

You learned about creating and browsing a cube in Chapter 6, and in Chapters 5 and 8 you learned about dimensions and enhancing dimensions by using special dimension properties and by adding business intelligence. In addition you learned about MDX in Chapter 3. These topics form a solid foundation for this chapter, where you learn about enhancements to cube design that can help you become an expert in cube design. Review Chapters 3, 5, 6, and 8 if you are not confident that you understand them, because this chapter builds on what you learned there, focusing on enhancements to your cube in support of specific business requirements. The emphasis here is on working with measures in your cube by modifying properties to change how those measures appear in cubes and how values are aggregated. There is also a focus on using enhanced dimension relationships. In addition, you work with actions and Key Performance Indicators (KPIs), features that add functionality that help end users view and interpret data efficiently. To implement many of the techniques described in this chapter, you use advanced MDX. In some cases, you can use the Business Intelligence Wizard to simplify the ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.