Service Request Support Group Status Duration Fact

ServiceRequestSupportGroupStatusDurationFact (Fact)

Element properties:

Domain	Domain.ServiceCatalog
Time Grain	Daily
Accessibility	Public

Source Code:

<Fact ID="ServiceRequestSupportGroupStatusDurationFact" Accessibility="Public" Domain="DWBase!Domain.ServiceCatalog" TimeGrain="Daily" Template="DWBase!DW.Transform.Template.StateTransition">

  <WaterMarkDependency>CoreService!System.WorkItem.ServiceRequest</WaterMarkDependency>

  <Dimensions>

    <Dimension>ServiceRequestDim</Dimension>

  </Dimensions>

  <Outriggers>

    <Outrigger>ServiceRequestSupportGroup</Outrigger>

  </Outriggers>

  <DegenerateDimensions>

    <DegenerateDimension ID="StartDateTime" Type="datetime" Nullable="false"/>

    <DegenerateDimension ID="FinishDateTime" Type="datetime" Nullable="true"/>

  </DegenerateDimensions>

  <Measures>

    <Measure>ServiceRequestSupportGroupTotalTimeMeasure</Measure>

  </Measures>

</Fact>