Using MDX and UDM in a SQL Server Analysis Services environment
Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.
Free membership is required to view this page
Become a member now to view all TechTarget content freely.
Sign in for existing membersBy submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy Policy
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
Pro+
Features
Enjoy the benefits of Pro+ membership, learn more and join.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest