Database Reference
In-Depth Information
Attribute
Description
This is an optional Boolean flag to indicate whether the dimension is a base dimension or is extending another di-
mension.
Extends
This is an optional Boolean flag to indicate whether two instances, that are otherwise identical and only differ
through which source the data originated from, should be coalesced into one single row of data.
Reconcile
Configuration Item-related dimensions should have this flag set to
true
, and Work Item-related dimensions will
have this flag set to
false
.
Next, we need to define an outrigger for the mobile phone manufacturer enumeration us-
ing the following XML fragment:
<Outrigger ID="CustomMobilePhoneManufacturer"
Accessibility="Public">
<Attribute ID="MobilePhoneManufacturer"
PropertyPath="$Context/Property[Type='Custom.MobilePhone']/
Manufacturer$" />
</Outrigger>
The
ID
attribute of the
<Outrigger>
tag must contain a unique identifier for the out-
rigger element. This will also be the table name of the outrigger in the Data Warehouse
data mart. The outrigger needs to point to all the class attributes that the enumeration is
used by. This is done using
<Attribute>
tags inside the
<Outrigger>
tag. Each at-
tribute must have a unique
ID
, and
PropertyPath
must uniquely identify the class and
attribute that the outrigger attribute is targeting.
The last step involves the definition of the relationship fact for the mobile phone owner.
See the following XML fragment for details:
<RelationshipFact ID="CustomMobilePhoneOwnedByUserFact"
Accessibility="Public"
Domain="DWBase!Domain.ConfigurationManagement"
TimeGrain="Daily" SourceType="Custom.MobilePhone"
SourceDimension="CustomMobilePhoneDim">
<Relationships RelationshipType="MobilePhoneOwnedByUser"
TargetDimension="DWBase!UserDim" />
</RelationshipFact>
