What is the difference between cubes and the Unified Dimensional Model (if any)?

Posted by ngm on Stack Overflow See other posts from Stack Overflow or by ngm
Published on 2010-03-25T15:49:54Z Indexed on 2010/03/25 15:53 UTC
Read the original article Hit count: 370

I'm currently researching SQL Server 2008 as a business intelligence solution, and currently looking at Analysis Services (and I'm pretty new to business intelligence as a whole...)

I'm a bit confused by some of the terms in SSAS, particularly the conceptual differences between cubes and MS's Unified Dimensional Model.

I believe that a cube in SSAS is basically an OLAP cube -- dimensions, measures, something that sits between the underlying data source and a business user.

But then that's kind of what I understand UDM to be as well.

The docs for SQL Server 2005 seem to suggest as much:

"A cube is essentially synonymous with a Unified Dimensional Model (UDM)".

But then the SQL Server 2008 pages sort of suggest that UDM is a wrapper for both multidimensional data (cubes) and relational data:

"Use the Unified Dimensional Model to provide one consolidated business view for relational and multidimensional data that includes business entities, business logic, calculations, and metrics."

This blog post suggests similarly:

"UDM provides a single dimensional model for all OLAP analysis and relational reporting needs. So you can use either MDX or SQL"

Is UDM something that sits above cubes? Or are they the same thing? I presume I would develop cubes with the Cube Designer application; what would I develop a UDM with?

© Stack Overflow or respective owner

Related posts about ssas

Related posts about sql-server