Database Reference
In-Depth Information
We need to define a
<RelationshipFact>
tag for each fact that we want to create
and one or more
<Relationships>
tags that point to the actual class relationships.
The following table lists the attributes used to define the relationship fact:
Attribute
Description
This is a unique identifier for the relationship fact element. This will also be the table name of the relationship fact in
the data warehouse and data mart.
ID
This element should always be set to
Public
.
Accessibility
The value for this attribute must be an enumeration that is a child of the parent domain enumeration defined in the
Microsoft.SystemCenter.Datawarehouse.Base
management pack.
Domain
TimeGrain
This is the granularity of the relationship fact. The possible values are
Hourly
,
Daily
,
Weekly
, and
Monthly
.
SourceType
This is the class for the source of the relationship.
This is the dimension that targets the source class. This is an optional field. If no source dimension is specified, Ser-
vice Manager will automatically find the dimension that directly targets the source class itself, or the closest parent
class of the source class in the class hierarchy.
SourceDimension
The
<Relationships>
tag points to the actual relationship using the
Relation-
shipType
attribute. The
TargetDimension
attribute points to the dimension that
targets the target class of the relationship.
The full management pack, including the definitions for class, relationship, and enumera-
tion, as well as the data warehouse extension, is listed under
Extending the Service Man-
ager Data Warehouse Code
in
Appendix
,
Useful Websites, Chapter Code, and Commu-
nity Resources
.
Seal the management pack and import it into Service Manager.
Tip
Only sealed management packs will be transferred to the data warehouse.
Once
MPSyncJob
is finished and the ETL jobs have transferred all data to the data ware-
house, you will see the new tables and views in the
DWDataMart
database, as shown in
the following screenshot. This can take several hours to complete.