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.
Search WWH ::




Custom Search