The Unified Dimensional Model (UDM)

SQL Server 2008 and end user ad hoc reporting

Andrew Fryer's Blog — Sun, 23 Sep 2007 19:23:16 GMT

In my opinion the weak link in reporting services is that there is no tool for information workers to

re: The Unified Dimensional Model (UDM)

Justin — Wed, 10 Oct 2007 11:48:59 GMT

I am really new to this, so let me see if I have it right. The UDM does not really replace any old method or model. It is really just a upgrade of OLAP.

You will have your source data and then the UDM is "placed" on top to create a better view of the data as a whole. This is where I get a little confused but I will try. Now, that the data is making analytical sense we now build the Cubes on top of the UDM to generate the specific data and reports required from within the UDM.

The key difference being that the UDM has now already done some of the work that the Cubes would have done? Ie: Aggregation, Sum, etc etc?

Is that correct or am I still thinking of the 2 legged models who diet on cigarettes and Mineral water?

re: The Unified Dimensional Model (UDM)

Doss — Wed, 12 Mar 2008 12:15:33 GMT

This is a good article. We are planning to have UDM in our company. We have around 10 Oracle Dbs a few Sequel server DBs and some MS Access DBs. Could you please suggest some tools and best practices available for implementing this UDM. Also waht is the start point?