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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
