O'Reilly logo

Star Schema The Complete Reference™ by Christopher Adamson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required