Enriching the Design of a Microsoft SQL Server 2008 R2 Analysis Services UDM [NZ 2010: DAT201]
Play Enriching the Design of a Microsoft SQL Server 2008 R2 Analysis Services UDM [NZ 2010: DAT201]
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.