12/17/2012
What is UDM? Its significance in SSAS?
The role of a Unified Dimensional Model (UDM) is to provide a bridge between
the user and the data sources. A UDM is constructed over one or more physical
data sources, and then the end user issues queries against the UDM using one of
a variety of client tools, such as Microsoft Excel. At a minimum, when the UDM
is constructed merely as a thin layer over the data source, the advantages to
the end user are a simpler, more readily understood model of the data,
isolation from heterogeneous back end data sources, and improved performance for
summary type queries. In some scenarios a simple UDM like this is constructed
totally automatically. With greater investment in the construction of the UDM,
additional benefits accrue from the richness of metadata that the model can
provide.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment