Dimension usage with measure group
Earlier in this chapter, you built your first cube and experienced how quickly you can build business applications using Analysis Services and Excel. The sample cube was very simplistic in a sense that it only exposed two dimensions, each of which had a direct relationship with the fact table. The Cube Wizard automatically detected such relationships and required minimal developer interaction. There are many real-world applications that have a model very similar to your sample cube. However, other requirements necessitate the usage of more complex fact-to-dimension relationships, which you will learn next.
To define how dimensions relate to various measure groups in your cube, switch over to the tab called Dimension ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook 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.
