Data Source
A data source is the origin of all the data that is contained
within an OLAP cube. An OLAP cube connects to a data source to read and process
raw data to perform aggregations and calculations for its associated measures.
The data source for all Service Manager OLAP cubes is the data marts, which
includes the data marts for both Operations Manager and Configuration Manager.
Authentication information about the data source must be stored in
SQL Server Analysis Services (SSAS) to establish the correct level of permissions.
Data Source View
The data source view (DSV) is a collection of views that
represent the dimension, fact, and outrigger tables from the data source, such
as the Service Manager data marts. The DSV contains all the relationships
between tables, such as primary and foreign keys.
In other words, the DSV
specifies how the SSAS database will map to the relational schema, and it
provides a layer of abstraction on top of the relational database. Using this
layer of abstraction, relationships can be defined between fact and dimension
tables, even if no relationships exist within the source relational database.
Named calculations, custom measures, and new attributes may also be defined in
the DSV that may not natively exist in the data warehouse dimensional schema.
For example, a named calculation that defines a Boolean value for Incidents
Resolved calculates the value as true if an incident’s status is
resolved or closed. Using the named calculation, Service Manager can then
define a measure to display useful information such as the percentage of
incidents resolved, the total number of incidents resolved,and the total
number of incidents that are not resolved.
Another quick example of a named calculation is ReleasesImplementedOnSchedule.
This named calculation provides a quick health status check on the number
of release records in which the actual end date is less than or equal to the
scheduled end date.
No comments:
Post a Comment