Database Reference
In-Depth Information
How to do it...
All data relevant for reporting is exposed in views inside the
DWDataMart
database. You
should not access the tables directly in your report queries.
DWDataMart
is a data ware-
house that uses three types of entities: dimensions, facts, and outriggers.
Understanding dimensions
A dimension in the database is roughly analogous to a class in Service Manager. Each class
in Service Manager has a list of properties, while each dimension contains a list of attrib-
utes. Each dimension attribute will map to one property in a class.
Dimensions are exposed in views that normally end with the
...Dimvw
string, such as
ComputerDimvw
, as shown in the following screenshot:
To get a list of all computers, you can execute the following query:
SELECT * FROM ComputerDimvw
Note that data is never deleted from the data warehouse. Instead, deleted rows are marked
accordingly. Each dimension has an attribute named
IsDeleted
. To get a list of all unde-
leted computers, you can execute the following query:
SELECT * FROM ComputerDimvw WHERE IsDeleted = 0
