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, Mark Kromer, Database Platform Specialist, Microsoft
Learn how to order the results of a SQL query when using case statements in a SQL Server Reporting Services (SSRS) report.continue reading
If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 ...continue reading
Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.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.