Enriching the Design of a Microsoft SQL Server 2008 R2 Analysis Services UDM

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

Right click “Save as…”

Slides (view online)
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.

Comment on this Session

Already have a Channel 9 account? Please sign in