CHAPTER 5Conformed Dimensions

Analytics that cross process boundaries are extremely powerful. This holds true within a subject area and across the enterprise. As the previous chapter showed, process-focused analytics require separate fact tables, and cross-process analytics require bringing this information together. This is accomplished by drilling across, and its success or failure hinges on dimensions.

This chapter focuses on insuring cross-process capability through conformed dimensions. With the right dimension design and content, it is possible to compare facts from different fact tables, both within a subject area and across the enterprise. Many powerful metrics can only be provided in this manner. Incompatible dimensions, on the other ...

Get Star Schema The Complete Reference now with O’Reilly online learning.

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