Professional SQL Server™ Analysis Services 2005 with MDX

6.1. The Unified Dimensional Model

To generate profits for a business, key strategic decisions need to be made based on likely factors such as having the right business model, targeting the right consumer group, pricing the product correctly, and marketing through optimal channels. To make the right decisions and achieve targeted growth you need to analyze data. The data can be past sales, expected sales, or even information from competitors. The phrase "Knowledge is power" is very fitting here because in the world of business, analyzing and comparing current sales against the expected sales helps executives make decisions directly aligned with the goals of the company. Such sales information is typically stored in a distributed fashion and must be collected from various sources. Executives making the business decisions typically do not have the capability to access the raw sales data as formed from various locations and subsequently optimized for use. The decision-makers typically rely on the aggregated data, which is easy to understand and which facilitates the decision-making process. Presenting aggregated data to the decision-makers quickly is a key challenge for business intelligence providers. Analysis Services 2005 enables you to design a model that bridges the gap between the raw data and the information content that can be used for forming business decisions. This model, designed through Analysis Services 2005, is called the Unified Dimensional Model (UDM).

The UDM is ...