UDM, on the other hand, is the name that Microsoft gives to the data structures used to store data in Analysis Service. For example, when you create a start schema in SSAS with dimensions, facts and hierarchies, you have created a unified dimensional model or UDM. This is how the data is stored in the cube, while MDX is the language you use to query the data stored in the cube.
Dig Deeper on SQL Server Database Modeling and Design
Related Q&A from Mark Kromer
Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed. Continue Reading
Learn how to order the results of a SQL query when using case statements in a SQL Server Reporting Services (SSRS) report. Continue Reading
Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.