Database Reference
In-Depth Information
How to do it...
We remember from the Understanding the Service Manager Data Warehouse data mart re-
cipe that classes, relationships, and enumerations have their respective representations in
the Service Manager Data Warehouse:
• Classes represent dimensions
• Relationships represent facts
• Enumerations represent outriggers
Using XML directives in the <Warehouse> area of a management pack, you can define
which entities should be transferred to the data warehouse.
We will start with the MobilePhone class by defining the dimension as follows:
<Dimension ID="CustomMobilePhoneDim" Accessibility="Public"
Target="Custom.MobilePhone" InferredDimension="true"
HierarchySupport="IncludeExtendedClassProperties"
Reconcile="true" />
The following table lists the relevant attributes that can be defined when creating dimen-
sions for the data warehouse:
Attribute
Description
This is a unique identifier for the dimension element. This will also be the table name of the dimension in the data
warehouse and data mart.
ID
Accessibility
This element should always be set to Public .
Target
This is the class name that the dimension is targeting.
InferredDimension This is always true .
This has one of these three options:
Exact : You must manually define each attribute that should be included in the dimension using the In-
clusionAttribute tag.
IncludeExtendedClassProperties : All the attributes of the target class and all of its base classes will
be included in the dimension.
IncludeDerivedClassProperties : All the attributes of the target class, its base classes, and its derived
classes will be included in the dimension.
HierarchySupport
Search WWH ::




Custom Search