The Service Level Tracking Summary report shows for selected Service Levels whether the configured Service Level Objectives (SLOs) met their respective goals.
Description:
For a given set of report durations such as “Week to Date” or “Last Month” and a chosen list of Service Levels, this report will show each Service Level and its contained SLOs and how those SLOs performance against their configured goal. Report can be configured to show multiple report durations for trending and will also allow drill through to the SLO Detail Report to view how each SLO instance performed.
Parameters:
Data Aggregation: Report can be run using the hourly or daily aggregations of data.
Date/Time Selection: Allows defining a time period for the report with relative or fixed dates. Date/time selection maps to report duration column when viewing report.
Business hours: Allows defining business hours time range and the weekdays it applies to. If business hours are defined this report only reports within this range. Business hours only works if hourly aggregation is selected.
Service levels: Allows selection of Service Level(s) using Service Level picker. Picker will allow searching by Service Level name.
Additional Time Intervals: Aside from the report duration column which is controlled by the Date/Time selection above, additional columns can be added to the report for trending and comparison.
Columns Available: (Maximum 7 columns in total will be shown on report)
Last 24 Hours
Last 7 Days
Last 30 Days
Last 60 Days
Week to Date
Last Week
Month to Date
Last Month
Quarter to Date
Last Quarter
Year to Date
Last Year
Sample Usage:
Scenario: Report on a single Service Level called “Finance Service Level” showing how its SLOs performed from Monday of the previous week to today and how this compared to last month.
Instructions: (Parameter selections shown in bold)
Ensure Service Level has been configured correctly from Authoring before running report
Open Service Level Tracking Summary Report
Select From drop down and choose Previous Week > Monday
Select To drop down and choose Today
Click Add Service Levels
In search box type Service Level name “Finance Service” then click Search
Highlight correct Service Level then click Add
Click OK once complete.
Select Last Month from Additional Time Intervals parameter.
Click Run to view report.
Report Output:
Column Heading > | Service Level | Image | Goal | Report Duration | Last Month |
Column Description > | Shows the Service Level/SLO name and target class | Graphical representation of target class | For each SLO will show its configured Goal. | Shows how the SLO performed between Monday of the previous week and today* | Shows how the SLO performed Last Month |
*Specific to this sample scenario, will change per date/time selection
Accessibility | Public |
Visible | True |
R.AggregationLabel | Data Aggregation | |
R.AggregationValue_0 | Hourly | |
R.AggregationValue_1 | Daily | |
R.BusinessTimeFormat | {2} from {0} to {1} | |
R.StartEndTimeFormat | From {0} to {1} | |
R.Description | This report shows for selected service levels whether the configured service level objectives(SLOs) met their respective goals | |
R.DescriptionTitle | Description | |
R.GeneratedTimeLabel | Report Time | |
R.Interval.Last24Hours | Last 24 Hours | |
R.Interval.Last30Days | Last 30 Days | |
R.Interval.Last60Days | Last 60 Days | |
R.Interval.Last7Days | Last 7 Days | |
R.Interval.LastMonth | Last Month | |
R.Interval.LastQuarter | Last Quarter | |
R.Interval.LastWeek | Last Week | |
R.Interval.LastYear | Last Year | |
R.Interval.MonthtoDate | Month to Date | |
R.Interval.QuartertoDate | Quarter to Date | |
R.Interval.ReportDuration | Report Duration | |
R.Interval.WeektoDate | Week to Date | |
R.Interval.YeartoDate | Year to Date | |
R.PageFormat | Page {0} of {1} | |
R.SlaFormat | {0} Service Levels included in this report | |
R.SlaFormatLine1 | {0} | |
R.SlaFormatLine2 | {0}| {1} | |
R.SlaLabel | Service Level(s) | |
R.StartEndTimeLabel | Report Duration | |
R.TimeZoneFormat | All dates and times are shown in {0} | |
R.Title | Service Level Tracking Summary Report |
<Report ID="Microsoft.SystemCenter.DataWarehouse.Report.ServiceLevelTrackingSummary" Accessibility="Public" Visible="true">
<Dependencies>
<DataWarehouseScript>Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Script</DataWarehouseScript>
<ReportParameterControl>DataWarehouseReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BusinessRelativeDateTimePicker</ReportParameterControl>
<ReportParameterControl>DataWarehouseReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringSLAXmlPicker</ReportParameterControl>
<ReportParameterControl>DataWarehouseReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox</ReportParameterControl>
</Dependencies>
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="4">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="DataAggregation">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.DataAggregation</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringSLAXmlPicker" columnSpan="2" rowSpan="2">
<ReportParameters>
<ReportParameter name="ServiceLevelAgreementList">
<Prompt>Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.SLAList</Prompt>
</ReportParameter>
<ReportParameter name="ManagementGroupId" binding="GroupList"/>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox" rowSpan="2">
<ReportParameters>
<ReportParameter name="TimeInterval">
<Prompt>Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.SLAInterval</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BusinessRelativeDateTimePicker">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>
</ReportParameter>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</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>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>
</ReportParameter>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
<ReportParameter name="TimeType" binding="TimeType"/>
<ReportParameter name="TimeWeekMap" binding="TimeWeekMap"/>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseMain">
<rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<ReportParameters>
<ReportParameter Name="StateDataSetType">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>StateDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>StateDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
<LabelField>DatasetTypeId</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="StateConnectionString">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>StateDateSetConnection</DataSetName>
<ValueField>ConnectionString</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>StateDateSetConnection</DataSetName>
<ValueField>ConnectionString</ValueField>
<LabelField>DatasetId</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ManagementGroupId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>[Management Group]</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
<LabelField>ManagementGroupName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="DataAggregation">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<Prompt>[Aggregation]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>0</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_0", "[Hourly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>1</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_1", "[Daily]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="TimeInterval">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value/>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>[TimeInterval]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value/>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.ReportDuration", "[ReportDuration]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.Last24Hours", "[Last24Hours]") + "</Title>" +
" <Start>" +
" <Base>Present</Base>" +
" <Offset Type='Day'>-1</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.Last24Hours", "[Last24Hours]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.Last7Days", "[Last7Days]") + "</Title>" +
" <Start>" +
" <Base>Present</Base>" +
" <Offset Type='Day'>-7</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.Last7Days", "[Last7Days]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.Last30Days", "[Last30Days]") + "</Title>" +
" <Start>" +
" <Base>Present</Base>" +
" <Offset Type='Day'>-30</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.Last30Days", "[Last30Days]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.Last60Days", "[Last60Days]") + "</Title>" +
" <Start>" +
" <Base>Present</Base>" +
" <Offset Type='Day'>-60</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.Last60Days", "[Last60Days]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.WeektoDate", "[WeektoDate]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayWeek</Base>" +
" <Offset Type='None'>0</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.WeektoDate", "[WeektoDate]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.LastWeek", "[LastWeek]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayWeek</Base>" +
" <Offset Type='Week'>-1</Offset>" +
" </Start>" +
"<End Time='00:00:00'>" +
" <Base>FirstDayWeek</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.LastWeek", "[LastWeek]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.MonthtoDate", "[MonthtoDate]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayMonth</Base>" +
" <Offset Type='None'>0</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.MonthtoDate", "[MonthtoDate]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.LastMonth", "[LastMonth]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayMonth</Base>" +
" <Offset Type='Month'>-1</Offset>" +
" </Start>" +
"<End Time='00:00:00'>" +
" <Base>FirstDayMonth</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.LastMonth", "[LastMonth]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.QuartertoDate", "[QuartertoDate]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayQuarter</Base>" +
" <Offset Type='None'>0</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.QuartertoDate", "[QuartertoDate]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.LastQuarter", "[LastQuarter]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayQuarter</Base>" +
" <Offset Type='Quarter'>-1</Offset>" +
" </Start>" +
"<End Time='00:00:00'>" +
" <Base>FirstDayQuarter</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.LastQuarter", "[LastQuarter]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.YeartoDate", "[YeartoDate]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayYear</Base>" +
" <Offset Type='None'>0</Offset>" +
" </Start>" +
"<End>" +
" <Base>Present</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.YeartoDate", "[YeartoDate]")</Label>
</ParameterValue>
<ParameterValue>
<Value>="<Interval>" +
" <Title>" + Code.GetLocTable("LT_Report").GetString("R.Interval.LastYear", "[LastYear]") + "</Title>" +
" <Start Time='00:00:00'>" +
" <Base>FirstDayYear</Base>" +
" <Offset Type='Year'>-1</Offset>" +
" </Start>" +
"<End Time='00:00:00'>" +
" <Base>FirstDayYear</Base>" +
" <Offset Type='None'>0</Offset>" +
" </End>" +
"</Interval>"</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.Interval.LastYear", "[LastYear]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<Prompt>[Start Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[From]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<Prompt>[Start Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[Start Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<Prompt>[End Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[To]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<Prompt>[End Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[End Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[Time Type]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeWeekMap">
<DataType>String</DataType>
<Prompt>[Week Days]</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<Prompt>[Time Zone]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>[Time Zone Name]</Prompt>
</ReportParameter>
<ReportParameter Name="Interactive">
<DataType>Boolean</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>=False</Value>
</Values>
</DefaultValue>
<Prompt>Interactive</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ServiceLevelAgreementList">
<DataType>String</DataType>
<Prompt>[ServiceLevelAgreements]</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.05in</rd:GridSpacing>
<rd:SnapToGrid>false</rd:SnapToGrid>
<rd:ReportID>ab518a51-343d-46c4-b1f8-4ec65faafd95</rd:ReportID>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<PageWidth>11in</PageWidth>
<DataSets>
<DataSet Name="StateDateSetConnection">
<Fields>
<Field Name="DatasetId">
<DataField>DatasetId</DataField>
</Field>
<Field Name="ServerName">
<DataField>ServerName</DataField>
</Field>
<Field Name="DatabaseName">
<DataField>DatabaseName</DataField>
</Field>
<Field Name="ConnectionString">
<Value>="Data Source=" + Fields!ServerName.Value + ";Initial Catalog=" + Fields!DatabaseName.Value + ";Integrated Security=SSPI"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>DataRouteGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@DatasetTypeId">
<Value>=Parameters!StateDataSetType.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="LT_Report_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
</Field>
<Field Name="ValueName">
<Value>="LT"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Report.ServiceLevelTrackingSummary</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="NeighborManagementGroups">
<Fields>
<Field Name="ManagementGroupGuid">
<DataField>ManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupName">
<DataField>ManagementGroupName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>DataRouteGetNeighbors</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@DatasetTypeId">
<Value>=Parameters!StateDataSetType.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="StateDataSetType">
<Fields>
<Field Name="DatasetTypeId">
<DataField>DatasetTypeId</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>DatasetTypeIdGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Library</Value>
</QueryParameter>
<QueryParameter Name="@DatasetTypeSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Dataset.State</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="SLASummaryMetaData">
<Fields>
<Field Name="ServiceLevelAgreementRowId">
<DataField>ServiceLevelAgreementRowId</DataField>
</Field>
<Field Name="ServiceLevelAgreementDisplayName">
<DataField>ServiceLevelAgreementDisplayName</DataField>
</Field>
<Field Name="ServiceLevelAgreementTargetManagedEntityTypeDisplayName">
<DataField>ServiceLevelAgreementTargetManagedEntityTypeDisplayName</DataField>
</Field>
<Field Name="ManagementGroupDisplayName">
<DataField>ManagementGroupDisplayName</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ServiceLevelAgreementParameterBlockDataGet</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@ServiceLevelAgreementXml">
<Value>=Parameters!ServiceLevelAgreementList.Value</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Code>
Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"
Const TimeZoneParameterName As String = "TimeZone"
Const SD_BaseTypeParameterName As String = "StartDate_BaseType"
Const SD_BaseValueParameterName As String = "StartDate_BaseValue"
Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"
Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"
Const ED_BaseTypeParameterName As String = "EndDate_BaseType"
Const ED_BaseValueParameterName As String = "EndDate_BaseValue"
Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"
Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"
Const IsRelativeTimeSupported As Boolean = True
Const TimeTypeParameterName As String = "TimeType"
Const TimeWeekMapParameterName As String = "TimeWeekMap"
Const DataAggregationParameterName As String = "DataAggregation"
Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)
Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
Dim ReportStartDate As DateTime
Dim ReportEndDate As DateTime
Dim ReportTime As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
Dim ReportCulture As System.Globalization.CultureInfo
Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor
Dim InitLock As New Object
Const TimeIntervalCount As Integer = 6
Const TimeIntervalParameterName As String = "TimeInterval"
Dim TimeIntervalTable(TimeIntervalCount - 1) As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Dim TimeIntervalParameterTable As System.Collections.Generic.List(Of String)
Dim SlaTable As System.Collections.Generic.Dictionary(Of SlaIdentity, System.Collections.Generic.Dictionary(Of Integer, SloValue))
Protected Overrides Sub OnInit()
LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()
ReportTimeZone = Nothing
ReportStartDate = DateTime.MinValue
ReportEndDate = DateTime.MinValue
ReportTime = Nothing
ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))
ParameterProcessor = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor(ReportCulture)
SlaTable = New System.Collections.Generic.Dictionary(Of SlaIdentity, System.Collections.Generic.Dictionary(Of Integer, SloValue))()
End Sub
Public Function GetCallingManagementGroupId() As String
Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId
End Function
Public Function GetReportLocLanguageCode() As String
Return ReportCulture.ThreeLetterWindowsLanguageName
End Function
Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
If Not LocTables.TryGetValue(Name, LocTable) Then
LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)
LocTables.Add(Name, LocTable)
End If
Return LocTable
End Function
Public Function GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
SyncLock InitLock
If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)
Return ReportTimeZone
End SyncLock
End Function
Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToUniversalTime(DateValue)
End Function
Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToLocalTime(DateValue)
End Function
Public Function GetReportStartDate() As DateTime
SyncLock InitLock
If (ReportStartDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
Else
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)
End if
If (CInt(Report.Parameters(DataAggregationParameterName).Value) > 0) Then
ReportStartDate = ReportStartDate.Date
End If
End If
return ReportStartDate
End SyncLock
End Function
Public Function GetReportEndDate() As DateTime
SyncLock InitLock
If (ReportEndDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)
Else
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)
End if
If (CInt(Report.Parameters(DataAggregationParameterName).Value) > 0) Then
ReportEndDate = ReportEndDate.Date
End If
End If
return ReportEndDate
End SyncLock
End Function
Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
SyncLock InitLock
If IsNothing(ReportTime) Then
If (CInt(Report.Parameters(DataAggregationParameterName).Value) = 0)
ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))
Else
ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Regular, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))
End if
End If
return ReportTime
End SyncLock
End Function
Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean
return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)
End Function
Public Function FormatDateTime(Format As String, Value As DateTime) As String
return Value.ToString(Format, ReportCulture)
End Function
Public Function FormatNumber(Format As String, Value As Decimal) As String
return Value.ToString(Format, ReportCulture)
End Function
Public Function FormatString(Format As String, ParamArray Values() as Object) As String
return String.Format(ReportCulture, Format, Values)
End Function
Public Function NullFormatString(Format As String, Value as String) As String
return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(ReportCulture, Format, Value))
End Function
Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String
Dim result As String
If IsBusinessHours(Value) Then
Dim firstDay As DayOfWeek
Dim days As System.Collections.Generic.List(Of String)
firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek
days = new System.Collections.Generic.List(Of String)()
For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday
Dim day As DayOfWeek
day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)
If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))
Next loopDay
result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))
Else
result = String.Empty
End if
return result
End Function
REM ---------------------------------
Public Enum DataAggregationType
Hourly = 0
Daily = 1
End Enum
Public Function GetBdDataAggregationTypeId(ByVal aggregation As DataAggregationType) As Integer
Select Case aggregation
Case DataAggregationType.Hourly
Return 20
Case DataAggregationType.Daily
Return 30
Case Else
Return 0
End Select
End Function
REM ---------------------------------
Public Enum SloObjectiveType
Under = 0
Over = 1
End Enum
Public Class SloValue
Private CurrentValue As Double
Private RelatedValueTable() As Double = New Double() {}
Public ReadOnly Goal As Double
Public ReadOnly Objective As SloObjectiveType
Public Sub New(ByVal SloValue As Double, ByVal SloGoal As Double, ByVal SloObjective As SloObjectiveType)
CurrentValue = SloValue
Goal = SloGoal
Objective = SloObjective
End Sub
Public Sub New(ByVal SloValue As Double, ByVal SloGoal As Double, ByVal SloObjective As String)
CurrentValue = SloValue
Goal = SloGoal
Objective = [Enum].Parse(GetType(SloObjectiveType), SloObjective, True)
End Sub
Public ReadOnly Property Value() As Double
Get
Return CurrentValue
End Get
End Property
Public ReadOnly Property RelatedValues() As Double()
Get
Return RelatedValueTable
End Get
End Property
Public Function IsGoalMet() As Boolean
Return IIf(Objective = SloObjectiveType.Under, CurrentValue <= Goal, CurrentValue >= Goal)
End Function
Public Function IsRelatedGoalMet(ByVal Index As Integer) As Nullable(Of Boolean)
Dim RelatedValue As Double = RelatedValues(Index)
If Double.IsNaN(RelatedValue) Then
Return Nothing
Else
Return New Nullable(Of Boolean)(IIf(Objective = SloObjectiveType.Under, RelatedValue <= Goal, RelatedValue >= Goal))
End If
End Function
Public Sub CollectValue(ByVal NewValue As Double)
Select Case Objective
Case SloObjectiveType.Over
If (NewValue < CurrentValue) Then
CurrentValue = NewValue
End If
Case SloObjectiveType.Under
If (NewValue > CurrentValue) Then
CurrentValue = NewValue
End If
End Select
End Sub
Public Sub CollectRelatedValue(ByVal Index As Integer, ByVal NewValue As Double)
If Index >= RelatedValues.Length Then
ReDim Preserve RelatedValueTable(Index)
RelatedValues(Index) = Double.NaN
End If
If Not Double.IsNaN(NewValue) Then
If Double.IsNaN(RelatedValues(Index)) Then
RelatedValues(Index) = NewValue
Else
Select Case Objective
Case SloObjectiveType.Over
If (NewValue < RelatedValues(Index)) Then
RelatedValues(Index) = NewValue
End If
Case SloObjectiveType.Under
If (NewValue > RelatedValues(Index)) Then
RelatedValues(Index) = NewValue
End If
End Select
End If
End If
End Sub
End Class
REM ---------------------------------
Public Class SlaIdentity
Implements IEquatable(Of SlaIdentity)
Public ReadOnly Id As Integer
Public ReadOnly GroupId As Integer
Public ReadOnly ObjectId As Integer
Public Sub New(ByVal ManagementGroupId As Integer, ByVal SlaId As Integer, ByVal SlaObjectId As Integer)
Id = SlaId
GroupId = ManagementGroupId
ObjectId = SlaObjectId
End Sub
Public Overloads Function Equals(ByVal other As SlaIdentity) As Boolean Implements System.IEquatable(Of SlaIdentity).Equals
Return Id = other.Id And ObjectId = other.ObjectId And GroupId = other.GroupId
End Function
Public Overrides Function GetHashCode() As Integer
Return (GroupId << 25) Or (Id << 14) Or ObjectId
End Function
End Class
REM ---------------------------------
Public Function AddSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer, ByVal Value As Double, ByVal Goal As Double, ByVal Objective As String) As Double
Dim CurrentValue As SloValue = Nothing
Dim SloTable As System.Collections.Generic.Dictionary(Of Integer, SloValue) = Nothing
Dim SlaId As SlaIdentity = New SlaIdentity(ManagementGroup, Sla, SlaObject)
If Not SlaTable.TryGetValue(SlaId, SloTable) Then
SloTable = New System.Collections.Generic.Dictionary(Of Integer, SloValue)()
SlaTable.Add(SlaId, SloTable)
End If
If Not SloTable.TryGetValue(Slo, CurrentValue) Then
CurrentValue = New SloValue(Value, Goal, Objective)
SloTable.Add(Slo, CurrentValue)
Else
CurrentValue.CollectValue(Value)
End If
Return CurrentValue.Value
End Function
Public Function AddRelatedSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer, ByVal Value As Object, ByVal Index As Integer) As Double
Dim SloVal As SloValue = SlaTable(New SlaIdentity(ManagementGroup, Sla, SlaObject))(Slo)
SloVal.CollectRelatedValue(Index, IIf(IsNothing(Value), Double.NaN, CDbl(Value)))
Return SloVal.RelatedValues(Index)
End Function
Public Function GetSlo(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer) As SloValue
Dim SlaId As SlaIdentity = New SlaIdentity(ManagementGroup, Sla, SlaObject)
If SlaTable.ContainsKey(SlaId) Then
Dim Value As SloValue = Nothing
If SlaTable(SlaId).TryGetValue(Slo, Value) Then
Return Value
Else
Return Nothing
End If
Else
Return Nothing
End If
End Function
Public Function GetSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer) As Double
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
If IsNothing(Value) Then
Return Double.NaN
Else
Return Value.Value
End If
End Function
Public Function GetRelatedSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer, ByVal Index As Integer) As Double
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
If IsNothing(Value) Then
Return Double.NaN
Else
Return Value.RelatedValues(Index)
End If
End Function
Public Function GetSloCondition(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer) As Nullable(Of Boolean)
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
If IsNothing(Value) Then
Return Nothing
Else
Return Value.IsGoalMet()
End If
End Function
Public Function GetRelatedSloCondition(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer, ByVal Index As Integer) As Nullable(Of Boolean)
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
If IsNothing(Value) Then
Return Nothing
Else
Return Value.IsRelatedGoalMet(Index)
End If
End Function
Public Function GetSlaCondition(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer) As Nullable(Of Boolean)
Dim SlaId As SlaIdentity = New SlaIdentity(ManagementGroup, Sla, SlaObject)
Dim Result As Nullable(Of Boolean) = Nothing
If SlaTable.ContainsKey(SlaId) Then
For Each Value As SloValue In SlaTable(SlaId).Values
If (Not Value.IsGoalMet()) Then
Return False
Else
Result = True
End If
Next
End If
Return Result
End Function
Public Function GetRelatedSlaCondition(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Index As Integer) As Nullable(Of Boolean)
Dim SlaId As SlaIdentity = New SlaIdentity(ManagementGroup, Sla, SlaObject)
Dim Result As Nullable(Of Boolean) = Nothing
If SlaTable.ContainsKey(SlaId) Then
For Each Value As SloValue In SlaTable(SlaId).Values
If Not IsNothing(Value.IsRelatedGoalMet(Index)) Then
If (Not Value.IsRelatedGoalMet(Index).Value) Then
Return False
Else
Result = True
End If
End If
Next
End If
Return Result
End Function
Public Function GetMaxSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer) As Double
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
Dim Result As Double = Double.NaN
If Not IsNothing(Value) Then
Result = Value.Goal
If Value.Value > Result Then
Result = Value.Value
End If
For Each RelatedValue As Double In Value.RelatedValues
If RelatedValue > Result Then
Result = RelatedValue
End If
Next
End If
Return Result
End Function
Public Function GetMinSloValue(ByVal ManagementGroup As Integer, ByVal Sla As Integer, ByVal SlaObject As Integer, ByVal Slo As Integer) As Double
Dim Value As SloValue = GetSlo(ManagementGroup, Sla, SlaObject, Slo)
Dim Result As Double = 0
If Not IsNothing(Value) Then
If Value.Goal < Result Then
Result = Value.Goal
End If
If Value.Value < Result Then
Result = Value.Value
End If
For Each RelatedValue As Double In Value.RelatedValues
If RelatedValue < Result Then
Result = RelatedValue
End If
Next
End If
Return Result
End Function
REM ---------------------------------
Public Function GetTimeIntervalParameterTable() As System.Collections.Generic.IList(Of String)
If IsNothing(TimeIntervalParameterTable) Then
TimeIntervalParameterTable = New System.Collections.Generic.List(Of String)()
For Each Value As String In Report.Parameters(TimeIntervalParameterName).Value
If Not IsNothing(Value) Then
If Not String.IsNullOrEmpty(Value.Trim()) Then
TimeIntervalParameterTable.Add(Value)
End If
End If
Next
End If
Return TimeIntervalParameterTable
End Function
Public Function GetTimeInterval(ByVal Index As Integer) As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Dim Value As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval = Nothing
If (Index >= 0) And (Index < TimeIntervalCount) Then
Value = TimeIntervalTable(Index)
If IsNothing(Value) Then
If GetTimeIntervalParameterTable().Count > Index Then
Value = New Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval(GetReportEndDate(), GetTimeIntervalParameterTable()(Index), ReportCulture)
TimeIntervalTable(Index) = Value
End If
End If
End If
Return Value
End Function
Public Function GetTimeIntervalTitle(ByVal Index As Integer) As String
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Interval = GetTimeInterval(Index)
If IsNothing(Interval) Then
Return Nothing
Else
Return Interval.Title
End If
End Function
Public Function IsTimeIntervalContains(ByVal Index As Integer, ByVal Value As DateTime) As Boolean
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Interval = GetTimeInterval(Index)
If IsNothing(Interval) Then
Return False
Else
Return Interval.Contains(Value)
End If
End Function
Public Function IsTimeIntervalHidden(ByVal Index As Integer) As Boolean
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Interval = GetTimeInterval(Index)
Return IsNothing(Interval)
End Function
Public Function CalculateTimeIntervalValue(ByVal Index As Integer, ByVal IntervalDate As DateTime, ByVal Value As Object) As Object
If IsTimeIntervalContains(Index, IntervalDate) Then
Return Value
Else
Return System.DBNull.Value
End If
End Function
Public Function GetTimeIntervalStartDate(ByVal Index As Integer) As Date
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Interval = GetTimeInterval(Index)
If IsNothing(Interval) Then
Return Nothing
Else
Return Interval.StartDate
End If
End Function
Public Function GetTimeIntervalEndDate(ByVal Index As Integer) As Date
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
Interval = GetTimeInterval(Index)
If IsNothing(Interval) Then
Return Nothing
Else
Return Interval.EndDate
End If
End Function
Public Function CalculateMinStartDate() As DateTime
Dim Index As Integer
Dim MinStartDate As DateTime = GetReportStartDate()
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
For Index = 0 To TimeIntervalCount - 1
Interval = GetTimeInterval(Index)
If (Not IsNothing(Interval)) Then
If (Interval.StartDate < MinStartDate) Then
MinStartDate = Interval.StartDate
End If
End If
Next
Return MinStartDate
End Function
Public Function CalculateMaxEndDate() As DateTime
Dim Index As Integer
Dim MaxEndDate As DateTime = GetReportEndDate()
Dim Interval As Microsoft.EnterpriseManagement.Reporting.ParameterTimeInterval
For Index = 0 To TimeIntervalCount - 1
Interval = GetTimeInterval(Index)
If (Not IsNothing(Interval)) Then
If (Interval.EndDate > MaxEndDate) Then
MaxEndDate = Interval.EndDate
End If
End If
Next
Return MaxEndDate
End Function
REM ---------------------------------
Public Enum SloValueType
Number = 0
Percent = 1
End Enum
Public Function FormatSloValue(ByVal Value As Object, ByVal ValueType As SloValueType) As String
If Double.IsNaN(Value) Then
Return String.Empty
Else
Select Case ValueType
Case SloValueType.Number
Return FormatNumber("G12", Value)
Case SloValueType.Percent
Return FormatNumber("P3", Value/100)
End Select
End If
End Function
Public Function GetSloImage(ByVal Value As Nullable(Of Boolean)) As String
If IsNothing(Value) Then
Return "NoDataSmall.gif"
Else
Return IIF(Value.Value, "TrueSmall.gif", "FalseSmall.gif")
End If
End Function
Public Function GetSlaImage(ByVal Value As Nullable(Of Boolean)) As String
If IsNothing(Value) Then
Return "NoDataLarge.gif"
Else
Return IIF(Value.Value, "TrueLarge.gif", "FalseLarge.gif")
End If
End Function
</Code>
<Width>10.85in</Width>
<Body>
<ReportItems>
<CustomReportItem Name="ForceYukonEngine">
<Type>ForceYukonEngine</Type>
<Top>0 mm</Top>
<Left>0 mm</Left>
<Height>0.01 mm</Height>
<Width>0.01 mm</Width>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CustomData>
<DataSetName>SLASummaryMetaData</DataSetName>
<DataColumnGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataColumnGroupings>
<DataRowGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataRowGroupings>
<DataRows>
<DataRow>
<DataCell>
<DataValue>
<Value>1</Value>
</DataValue>
</DataCell>
</DataRow>
</DataRows>
</CustomData>
</CustomReportItem>
<Rectangle Name="rectangle5">
<Left>0.15in</Left>
<ZIndex>5</ZIndex>
<Top>1.41042in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
</Style>
<Height>0.05in</Height>
</Rectangle>
<Rectangle Name="rectangle4">
<Left>0.15in</Left>
<ZIndex>4</ZIndex>
<ReportItems>
<Textbox Name="reportDescriptionTitle">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.31042in</Top>
<Width>10.5in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Report Description Title]")</Value>
</Textbox>
<Textbox Name="reportTitle">
<DataElementOutput>Output</DataElementOutput>
<Top>0.03959in</Top>
<Width>10.49792in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Title</DataElementName>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Title", "[Report Title]")</Value>
</Textbox>
</ReportItems>
<Top>0.7in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.51042in</Height>
</Rectangle>
<Rectangle Name="rectangle3">
<Left>0.15in</Left>
<ZIndex>3</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<ReportItems>
<Textbox Name="reportDescription">
<DataElementOutput>Output</DataElementOutput>
<Width>10.3in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<DataElementName>Description</DataElementName>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Description", "[Report Description]")</Value>
</Textbox>
</ReportItems>
<Top>1.21042in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.2in</Height>
</Rectangle>
<Rectangle Name="rectangle2">
<Left>0.15in</Left>
<ZIndex>2</ZIndex>
<ReportItems>
<Textbox Name="textbox14">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.8573in</Top>
<Width>8.48125in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>18</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95625in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.SlaFormat", "{0}"), Code.FormatNumber("G",CountDistinct(Fields!ServiceLevelAgreementRowId.Value, "SLASummaryMetaData")))</Value>
</Textbox>
<Textbox Name="textbox53">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>17</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.96042in</Left>
<DataElementName>Aggregation</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_" + Parameters!DataAggregation.Value.ToString(), "[" + Parameters!DataAggregation.Value.ToString() + "]")</Value>
</Textbox>
<Textbox Name="textbox54">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>16</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox55">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AggregationLabel", "[Data Aggregation]")</Value>
</Textbox>
<Rectangle Name="rectangle6">
<Left>0.02083in</Left>
<ZIndex>14</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>objectsParameterTitle</ToggleItem>
</Visibility>
<ReportItems>
<List Name="list1">
<ZIndex>1</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<DataSetName>SLASummaryMetaData</DataSetName>
<ReportItems>
<Line Name="line1">
<Top>0.38282in</Top>
<Style>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<ZIndex>2</ZIndex>
<Left>1.89272in</Left>
</Line>
<Textbox Name="textbox68">
<Top>0.18229in</Top>
<Width>8.45833in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.90938in</Left>
<Height>0.17708in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.SlaFormatLine2", "{0}| {1}"), Fields!ManagementGroupDisplayName.Value, Fields!ServiceLevelAgreementTargetManagedEntityTypeDisplayName.Value)</Value>
</Textbox>
<Textbox Name="textbox67">
<rd:DefaultName>textbox67</rd:DefaultName>
<Width>8.45834in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>1.90938in</Left>
<Height>0.17708in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.SLAFormatLine1", "{0}"), Fields!ServiceLevelAgreementDisplayName.Value)</Value>
</Textbox>
</ReportItems>
<Top>0.05078in</Top>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Grouping Name="list1_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!ServiceLevelAgreementRowId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>0.38282in</Height>
</List>
<Line Name="line3">
<Top>0.04in</Top>
<Style>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Left>1.92917in</Left>
<Height>0in</Height>
</Line>
</ReportItems>
<Top>1.07083in</Top>
<Width>10.37917in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.51303in</Height>
</Rectangle>
<Textbox Name="textbox20">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.15in</Left>
<DataElementName>BusinessHours</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatBusinessHours("{2} {0}-{1}", Code.GetReportTimeFilter())</Value>
</Textbox>
<Textbox Name="textbox17">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.1in</Left>
<DataElementName>TimeZone</DataElementName>
<Height>0.2in</Height>
<Value>=Parameters!TimeZoneName.Value</Value>
</Textbox>
<Textbox Name="textbox9">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.05in</Left>
<DataElementName>EndDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportEndDate())</Value>
</Textbox>
<Textbox Name="textbox27">
<DataElementOutput>NoOutput</DataElementOutput>
<Visibility>
<Hidden>=Not Code.IsBusinessHours(Code.GetReportTimeFilter())</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.65in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.96042in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatBusinessHours(Code.GetLocTable("LT_Report").GetString("R.BusinessTimeFormat", "{2} {0} - {1}"), Code.GetReportTimeFilter())</Value>
</Textbox>
<Image Name="parameterBottomImage">
<Sizing>AutoSize</Sizing>
<Top>1.59375in</Top>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>9</ZIndex>
<Height>0.05in</Height>
<Value>../gradient_landscape.gif</Value>
</Image>
<Textbox Name="textbox11">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="objectsParameterTitle">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<Width>1.85in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.SlaLabel", "[Report Service Levels Label]")</Value>
</Textbox>
<Textbox Name="ReportGeneratedTime">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.96042in</Left>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.ToReportDate(DateTime.UtcNow))</Value>
</Textbox>
<Textbox Name="textbox7">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox2">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox1">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.GeneratedTimeLabel", "[Report Generated Time Label]")</Value>
</Textbox>
<Textbox Name="textbox28">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.StartEndTimeFormat", "{0} - {1}"), Code.FormatDateTime(IIf(Code.IsBusinessHours(Code.GetReportTimeFilter()) Or (CInt(Parameters!DataAggregation.Value) > 0), "d", "g"), Code.GetReportStartDate()), Code.FormatDateTime(IIf(Code.IsBusinessHours(Code.GetReportTimeFilter()) Or (CInt(Parameters!DataAggregation.Value) > 0), "d", "g"), Code.GetReportEndDate()))</Value>
</Textbox>
<Textbox Name="textbox26">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndTimeLabel", "[Report Start/End Time Label]")</Value>
</Textbox>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>StartDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportStartDate())</Value>
</Textbox>
</ReportItems>
<Top>1.47083in</Top>
<Width>10.55in</Width>
<Height>1.65416in</Height>
</Rectangle>
<Image Name="banner_image">
<Sizing>AutoSize</Sizing>
<Top>0.11042in</Top>
<Width>10.55208in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>1</ZIndex>
<Left>0.15in</Left>
<Height>0.58958in</Height>
<Value>../banner_landscape.jpg</Value>
</Image>
<Subreport Name="ServiceLevelTrackingSummaryDetail">
<Parameters>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Parameters!StartDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Parameters!EndDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="ManagementGroupId">
<Value>=Parameters!ManagementGroupId.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
<Parameter Name="TimeInterval">
<Value>=Parameters!TimeInterval.Value</Value>
</Parameter>
<Parameter Name="ServiceLevelAgreementList">
<Value>=Parameters!ServiceLevelAgreementList.Value</Value>
</Parameter>
</Parameters>
<Top>3.125in</Top>
<ReportName>Microsoft.SystemCenter.DataWarehouse.Report.ServiceLevelTrackingSummary.Detail</ReportName>
<Width>10.55in</Width>
<Left>0.14583in</Left>
<Height>0.67708in</Height>
</Subreport>
</ReportItems>
<Height>4.05208in</Height>
</Body>
<Language>en-US</Language>
<PageFooter>
<PrintOnFirstPage>true</PrintOnFirstPage>
<ReportItems>
<Textbox Name="textbox8">
<Top>0.1in</Top>
<Width>1.7in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>8.95in</Left>
<Height>0.1875in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>
</Textbox>
<Textbox Name="textbox37">
<Top>0.1in</Top>
<Width>8.75in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.15in</Left>
<Height>0.1875in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>
</Textbox>
</ReportItems>
<Height>0.35in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
</PageFooter>
<PageHeight>8.5in</PageHeight>
</Report>
</Definition>
<ReportStrings>
<ReportString ID="R.Title"/>
<ReportString ID="R.Description"/>
<ReportString ID="R.DescriptionTitle"/>
<ReportString ID="R.GeneratedTimeLabel"/>
<ReportString ID="R.SlaFormatLine1"/>
<ReportString ID="R.SlaFormatLine2"/>
<ReportString ID="R.SlaLabel"/>
<ReportString ID="R.TimeZoneFormat"/>
<ReportString ID="R.PageFormat"/>
<ReportString ID="R.BusinessTimeFormat"/>
<ReportString ID="R.StartEndTimeFormat"/>
<ReportString ID="R.StartEndTimeLabel"/>
<ReportString ID="R.AggregationLabel"/>
<ReportString ID="R.AggregationValue_0"/>
<ReportString ID="R.AggregationValue_1"/>
<ReportString ID="R.SlaFormat"/>
<ReportString ID="R.Interval.ReportDuration"/>
<ReportString ID="R.Interval.Last24Hours"/>
<ReportString ID="R.Interval.Last7Days"/>
<ReportString ID="R.Interval.Last30Days"/>
<ReportString ID="R.Interval.Last60Days"/>
<ReportString ID="R.Interval.WeektoDate"/>
<ReportString ID="R.Interval.LastWeek"/>
<ReportString ID="R.Interval.MonthtoDate"/>
<ReportString ID="R.Interval.LastMonth"/>
<ReportString ID="R.Interval.QuartertoDate"/>
<ReportString ID="R.Interval.LastQuarter"/>
<ReportString ID="R.Interval.YeartoDate"/>
<ReportString ID="R.Interval.LastYear"/>
</ReportStrings>
</Report>