Databases Reference
In-Depth Information
Due to rich metadata supported by OLAP, end users are able to ex-
ploit this metadata to navigate and explore data in support of making
business decisions. UDM also provides you with the ability to view
specific sections of the unified model based on your business ana-
lysis needs.
▪
Rich analytics support:
In addition to the rich metadata support,
the UDM provides you with the ability to specify complex calculations
to be applied to the underlying data; in this way you can embed busi-
ness logic. You can specify the complex calculations by a script-
based calculation model using the language called MDX (Multi-Di-
mensional eXpressions). UDM provides rich analytics such as Key
Performance Indicators and Actions that help in understanding your
business with ease and automatically take appropriate actions based
on changes in data.
▪
Model for Reporting and Analysis:
The UDM provides the best
functionality for relating to both relational and OLAP worlds. UDM
provides you with the capability of not only querying the aggregated
data that are typically used for analysis, but also has the ability to
provide for detailed reporting up to the transaction level across mul-
tiple heterogeneous data sources.
Another handy aspect of using the UDM is the storage of foreign language
translations for both data and metadata. This is handled seamlessly by the
UDM such that a connecting user gets the metadata and data of interest cus-
tomized to his or her locale. Of course, somebody has to enter those transla-
tions into the UDM in the first place; it is not actually a foreign language trans-
lation system.
Search WWH ::
Custom Search