Enriching the Design of a Microsoft SQL Server 2008 R2 Analysis Services UDM
In the most basic way, the Unified Dimensional Model (UDM) combines the best aspects of traditional OLAP analysis and relational reporting. In doing so it presents a "single version of the truth" that can satisfy multidimensional analysis and relationship reporting. But that's just the tip of the iceberg. The UDM can also define server-side calculations, Key Performance Indicators (KPIs), actions, perspectives, and translations to provide a richer experience than just querying for results from a database. So beyond storing your data, the UDM can store information about how our data is represented and how it should be delivered and presented to the business user. In this session, discover through theory, demonstration, and best practices discussion, how to enrich the design of the UDM beyond the data itself.