Activity Distribution

ServiceManager.Report.ActivityManagement.ActivitiesDistribution (Report)

This report provides the number of activities as well as several important attributes including status, type, stage, and more. The data can be grouped by Status, Stage, or Type.
Element properties:

Accessibility	Public
Visible	True
Report Localization:

*ReportName*	Activity Distribution
*ReportDescriptionLabel*	Expand this section to see a full description of this report.
*ReportDescription*	This report provides the number of activities as well as several important attributes including status, type, stage, and more. The data can be grouped by Status, Stage, or Type.
*ReportGeneratedLabel*	Report generated
*StartEndDateLabel*	Resolution Description
*Format.DateRange*	From {0} to {1}
*Area*	Area
*Priority*	Priority
*Type*	Type
*Status*	Status
*AssignedTo*	Assigned to
*Stage*	Stage
*ActualStartDate*	Actual Start Date
*ScheduledStartDate*	Scheduled Start Date
*ScheduledEndDate*	Scheduled End Date
*ActualEndDate*	Actual End Date
*ImpactedCIName*	Impacted Configuration Item Name
Id	ID
*Name*	Name
*CreatedOn*	Created Date
*ScheduledStart*	Scheduled Start Date
*ScheduledEnd*	Scheduled End Date
*ParentWorkitemID*	Parent Work Item
*Link.ActivityDetailReport*	Activity Details report
*Prompt.ActivityName*	Activity Name
*Prompt.ID*	Activity ID
*Prompt.Type*	Type
*Prompt.ImpactedCIName*	Impacted Configuration Item Name
*AllLabel*	(All)
*Category*	Category
*ExpandRowMessage*	Expand the rows below to see more information about that group
*None*	NA
*Manual*	Manual
*Review*	Review
Source Code:

<Report ID="ServiceManager.Report.ActivityManagement.ActivitiesDistribution" Accessibility="Public" Target="Activity!System.WorkItem.Activity" Visible="true">

  <Dependencies>

    <Dimension>DWBase!UserDim</Dimension>

    <Dimension>ActivityDW!ActivityDim</Dimension>

    <DataWarehouseScript>ServiceManager.Report.ActivityManagement.SP.ActivitiesDistribution.Script</DataWarehouseScript>

    <DataWarehouseScript>ServiceManager.Report.ActivityManagement.SP.ReportOptimizations.Script</DataWarehouseScript>

    <ReportResource>SMReportCommon!Report_Header_Potrait.png</ReportResource>

    <ReportResource>SMReportCommon!Report_Header_Landscape.png</ReportResource>

    <ReportResource>SMReportCommon!horizontal_line_gradient.png</ReportResource>

  </Dependencies>

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="6">

    <Controls>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDatePickerValueEditor">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.StartDate</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.EndDate</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.SingleValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Type">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Type</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Status">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Status</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ActivityStatus</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ActivityManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Category">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Category</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ChangeCategory</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ChangeManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Area">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Area</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ActivityArea</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ActivityManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.SingleValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="ReportSeries">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.ReportSeries</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Stage">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Stage</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ActivityStage</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ActivityManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Priority">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Priority</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>30</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>ActivityPriority</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.ActivityManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="AssignedTo">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.AssignedTo</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>UserDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Microsoft.SystemCenter.Datawarehouse.Base</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="2" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="CIName">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.CIName</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>ConfigItemDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Microsoft.SystemCenter.Datawarehouse.Base</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.StringValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="ID">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.ID</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.StringValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Name">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.Name</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="StartDate_ScheduledStart">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.StartDate_ScheduledStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="EndDate_ScheduledStart">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.EndDate_ScheduledStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="StartDate_ScheduledEnd">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.StartDate_ScheduledEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="EndDate_ScheduledEnd">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.EndDate_ScheduledEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="StartDate_ActualStart">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.StartDate_ActualStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="EndDate_ActualStart">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.EndDate_ActualStart</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="StartDate_ActualEnd">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.StartDate_ActualEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DateTimeValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="EndDate_ActualEnd">

            <Prompt>ServiceManager.ActivityManagement.Report.Library!ReportParameter.EndDate_ActualEnd</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <ReportDefinition>ServiceManager.Report.ActivityManagement.ActivitiesDistribution.ReportRdl</ReportDefinition>

  <ReportStrings>

    <ReportString ID="ReportName"/>

    <ReportString ID="ReportDescriptionLabel"/>

    <ReportString ID="ReportDescription"/>

    <ReportString ID="ReportGeneratedLabel"/>

    <ReportString ID="StartEndDateLabel"/>

    <ReportString ID="Format.DateRange"/>

    <ReportString ID="Area"/>

    <ReportString ID="Priority"/>

    <ReportString ID="Category"/>

    <ReportString ID="Type"/>

    <ReportString ID="Status"/>

    <ReportString ID="AssignedTo"/>

    <ReportString ID="Stage"/>

    <ReportString ID="ActualStartDate"/>

    <ReportString ID="ScheduledStartDate"/>

    <ReportString ID="ScheduledEndDate"/>

    <ReportString ID="ActualEndDate"/>

    <ReportString ID="ImpactedCIName"/>

    <ReportString ID="Id"/>

    <ReportString ID="Name"/>

    <ReportString ID="CreatedOn"/>

    <ReportString ID="ScheduledStart"/>

    <ReportString ID="ScheduledEnd"/>

    <ReportString ID="ParentWorkitemID"/>

    <ReportString ID="Link.ActivityDetailReport"/>

    <ReportString ID="Prompt.ActivityName"/>

    <ReportString ID="Prompt.ID"/>

    <ReportString ID="Prompt.Type"/>

    <ReportString ID="Prompt.ImpactedCIName"/>

    <ReportString ID="AllLabel"/>

    <ReportString ID="ExpandRowMessage"/>

    <ReportString ID="None"/>

    <ReportString ID="Review"/>

    <ReportString ID="Manual"/>

  </ReportStrings>

</Report>