<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Chart Name="Chart2">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Label />
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Label>Years Less Equal To One</Label>
</ChartMember>
<ChartMember>
<Label>Years2To5</Label>
</ChartMember>
<ChartMember>
<Label>Years6To10</Label>
</ChartMember>
<ChartMember>
<Label>Years11To15</Label>
</ChartMember>
<ChartMember>
<Label>Years16To20</Label>
</ChartMember>
<ChartMember>
<Label>Years21To25</Label>
</ChartMember>
<ChartMember>
<Label>Years25Over</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="YearsLessEqualToOne">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!YearsLessEqualToOne.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!YearsLessEqualToOne.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>0 - 1 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years2To5">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years2To5.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years2To5.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>1</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>2 - 5 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years6To10">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years6To10.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years6To10.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>2</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>6 - 10 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years11To15">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years11To15.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years11To15.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>3</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>11 - 15 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years16To20">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years16To20.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years16To20.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>4</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>16 - 20 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years21To25">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years21To25.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years21To25.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>5</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>21 - 25 Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Years25Over">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Years25Over.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Sum(Fields!Years25Over.Value)</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>EmployeeYearsServiceDetails</ReportName>
<Parameters>
<Parameter Name="YearRangeValue">
<Value>6</Value>
</Parameter>
<Parameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</Parameter>
<Parameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</Parameter>
<Parameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>25+ Years</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
</ChartSeriesCollection>
</ChartData>
<ChartAreas>
<ChartArea Name="Default">
<ChartCategoryAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Years of Service Ranges for Employees
with Active Assignments</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<IntervalType>Auto</IntervalType>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<LabelsAutoFitDisabled>true</LabelsAutoFitDisabled>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartCategoryAxes>
<ChartValueAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption># of Employees</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartValueAxes>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<FontSize>8pt</FontSize>
</Style>
<ChartLegendTitle>
<Caption />
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<Palette>Pastel</Palette>
<ChartBorderSkin>
<Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>No Data Available</Caption>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>EmployeeAgeRange_Query</DataSetName>
<Height>3.21874in</Height>
<Width>5.13541in</Width>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
</ReportItems>
<Height>3.24999in</Height>
<Style />
</Body>
<Width>5.14583in</Width>
<Page>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="RSDS_EnterpriseDW_SSAS">
<DataSourceReference>RSDS_EnterpriseDW_SSAS</DataSourceReference>
<rd:SecurityType>None</rd:SecurityType>
<rd:DataSourceID>900aaef5-1391-4a99-abcb-96f0b33af439</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="EmployeeAgeRange_Query">
<Query>
<DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName>
<QueryParameters>
<QueryParameter Name="EmployeeLocation">
<Value>=Parameters!EmployeeLocation.Value</Value>
</QueryParameter>
<QueryParameter Name="EmployeeFullPartTime">
<Value>=Parameters!EmployeeFullPartTime.Value</Value>
</QueryParameter>
<QueryParameter Name="EmployeeFunction">
<Value>=Parameters!EmployeeFunction.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>SELECT
NON EMPTY
{[Measures].[Employee Count]} ON COLUMNS
,NON EMPTY
{
[Employee].[Years Of Service To Institution].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
{[Employee].[Has Active Assignment].&[Yes]} ON COLUMNS
FROM [HR_Payroll]
)
WHERE
(
StrToSet(@EmployeeLocation)
,StrToSet(@EmployeeFullPartTime)
,StrToSet(@EmployeeFunction)
)</CommandText>
<rd:DesignerState>
<QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition">
<CommandType>MDX</CommandType>
<Type>Query</Type>
<QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Select>
<Items>
<Item>
<ID xsi:type="Level">
<DimensionName>Employee</DimensionName>
<HierarchyName>Years Of Service To Institution</HierarchyName>
<HierarchyUniqueName>[Employee].[Years Of Service To Institution]</HierarchyUniqueName>
<LevelName>Years Of Service To Institution</LevelName>
<UniqueName>[Employee].[Years Of Service To Institution].[Years Of Service To Institution]</UniqueName>
</ID>
<ItemCaption>Years Of Service To Institution</ItemCaption>
<UniqueName>true</UniqueName>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>Employee Count</MeasureName>
<UniqueName>[Measures].[Employee Count]</UniqueName>
</ID>
<ItemCaption>Employee Count</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
</Items>
</Select>
<From>HR_Payroll</From>
<Filter>
<FilterItems />
</Filter>
<Calculations />
<Aggregates />
<QueryProperties />
</QuerySpecification>
<Query>
<Statement>SELECT
NON EMPTY
{[Measures].[Employee Count]} ON COLUMNS
,NON EMPTY
{
[Employee].[Years Of Service To Institution].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
{[Employee].[Has Active Assignment].&[Yes]} ON COLUMNS
FROM [HR_Payroll]
)
WHERE
(
StrToSet(@EmployeeLocation)
,StrToSet(@EmployeeFullPartTime)
,StrToSet(@EmployeeFunction)
)</Statement>
<ParameterDefinitions>
<ParameterDefinition>
<Name>EmployeeLocation</Name>
<DefaultValues>
<DefaultValue>[Employee].[Location].[All]</DefaultValue>
</DefaultValues>
<Caption>EmployeeLocation</Caption>
<HierarchyUniqueName>[Employee].[Location]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Location].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterizedStatement>
<ReferencedParameters />
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>EmployeeFullPartTime</Name>
<DefaultValues>
<DefaultValue>[Employee].[Employee Fulltime Parttime].[All]</DefaultValue>
</DefaultValues>
<Caption>EmployeeFullPartTime</Caption>
<HierarchyUniqueName>[Employee].[Employee Fulltime Parttime]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Employee Fulltime Parttime].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterizedStatement>
<ReferencedParameters />
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>EmployeeFunction</Name>
<DefaultValues>
<DefaultValue>[Employee].[Function Desc].[All]</DefaultValue>
</DefaultValues>
<Caption>EmployeeFunction</Caption>
<HierarchyUniqueName>[Employee].[Function Desc]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Function Desc].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Function Desc].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Function Desc].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Function Desc].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterizedStatement>
<ReferencedParameters />
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
</ParameterDefinitions>
</Query>
</QueryDefinition>
</rd:DesignerState>
</Query>
<Fields>
<Field Name="Years_Of_Service_To_Institution">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Employee].[Years Of Service To Institution].[Years Of Service To Institution]" /></DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Employee_Count">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Employee Count]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="YearsLessEqualToOne">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value <= 1 and NOT(IsNothing(Fields!Years_Of_Service_To_Institution.Value)),Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years2To5">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 1 and Fields!Years_Of_Service_To_Institution.Value <= 5,Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years6To10">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 5 and Fields!Years_Of_Service_To_Institution.Value <= 10,Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years11To15">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 10 and Fields!Years_Of_Service_To_Institution.Value <= 15,Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years16To20">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 15 and Fields!Years_Of_Service_To_Institution.Value <= 20,Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years21To25">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 20 and Fields!Years_Of_Service_To_Institution.Value <= 25,Fields!Employee_Count.Value,0)</Value>
</Field>
<Field Name="Years25Over">
<Value>=iif(Fields!Years_Of_Service_To_Institution.Value > 25,Fields!Employee_Count.Value,0)</Value>
</Field>
</Fields>
</DataSet>
<DataSet Name="EmployeeLocation">
<Query>
<DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName>
<CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Location].ALLMEMBERS ON ROWS FROM [HR_Payroll]</CommandText>
<rd:DesignerState>
<QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition">
<CommandType>MDX</CommandType>
<Type>Query</Type>
<QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Select>
<Items>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterCaption</MeasureName>
<UniqueName>[Measures].[ParameterCaption]</UniqueName>
</ID>
<ItemCaption>ParameterCaption</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterValue</MeasureName>
<UniqueName>[Measures].[ParameterValue]</UniqueName>
</ID>
<ItemCaption>ParameterValue</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterLevel</MeasureName>
<UniqueName>[Measures].[ParameterLevel]</UniqueName>
</ID>
<ItemCaption>ParameterLevel</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
</Items>
</Select>
<From>HR_Payroll</From>
<Filter>
<FilterItems />
</Filter>
<Calculations />
<Aggregates />
<QueryProperties />
</QuerySpecification>
<Query>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Location].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterDefinitions />
</Query>
</QueryDefinition>
</rd:DesignerState>
<rd:AutoGenerated>true</rd:AutoGenerated>
<rd:Hidden>true</rd:Hidden>
</Query>
<Fields>
<Field Name="ParameterCaption">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterValue">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterLevel">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterCaptionIndented">
<Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="EmployeeFullPartTime">
<Query>
<DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName>
<CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Employee Fulltime Parttime].ALLMEMBERS ON ROWS FROM [HR_Payroll]</CommandText>
<rd:DesignerState>
<QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition">
<CommandType>MDX</CommandType>
<Type>Query</Type>
<QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Select>
<Items>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterCaption</MeasureName>
<UniqueName>[Measures].[ParameterCaption]</UniqueName>
</ID>
<ItemCaption>ParameterCaption</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterValue</MeasureName>
<UniqueName>[Measures].[ParameterValue]</UniqueName>
</ID>
<ItemCaption>ParameterValue</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterLevel</MeasureName>
<UniqueName>[Measures].[ParameterLevel]</UniqueName>
</ID>
<ItemCaption>ParameterLevel</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
</Items>
</Select>
<From>HR_Payroll</From>
<Filter>
<FilterItems />
</Filter>
<Calculations />
<Aggregates />
<QueryProperties />
</QuerySpecification>
<Query>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Employee Fulltime Parttime].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Employee Fulltime Parttime].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterDefinitions />
</Query>
</QueryDefinition>
</rd:DesignerState>
<rd:AutoGenerated>true</rd:AutoGenerated>
<rd:Hidden>true</rd:Hidden>
</Query>
<Fields>
<Field Name="ParameterCaption">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterValue">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterLevel">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterCaptionIndented">
<Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="EmployeeFunction">
<Query>
<DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName>
<CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Function Desc].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Function Desc].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Function Desc].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Function Desc].ALLMEMBERS ON ROWS FROM [HR_Payroll]</CommandText>
<rd:DesignerState>
<QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition">
<CommandType>MDX</CommandType>
<Type>Query</Type>
<QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Select>
<Items>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterCaption</MeasureName>
<UniqueName>[Measures].[ParameterCaption]</UniqueName>
</ID>
<ItemCaption>ParameterCaption</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterValue</MeasureName>
<UniqueName>[Measures].[ParameterValue]</UniqueName>
</ID>
<ItemCaption>ParameterValue</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>ParameterLevel</MeasureName>
<UniqueName>[Measures].[ParameterLevel]</UniqueName>
</ID>
<ItemCaption>ParameterLevel</ItemCaption>
<FormattedValue>true</FormattedValue>
</Item>
</Items>
</Select>
<From>HR_Payroll</From>
<Filter>
<FilterItems />
</Filter>
<Calculations />
<Aggregates />
<QueryProperties />
</QuerySpecification>
<Query>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Employee].[Function Desc].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Employee].[Function Desc].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Employee].[Function Desc].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Employee].[Function Desc].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement>
<ParameterDefinitions />
</Query>
</QueryDefinition>
</rd:DesignerState>
<rd:AutoGenerated>true</rd:AutoGenerated>
<rd:Hidden>true</rd:Hidden>
</Query>
<Fields>
<Field Name="ParameterCaption">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterValue">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterLevel">
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ParameterCaptionIndented">
<Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportParameters>
<ReportParameter Name="EmployeeLocation">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Employee].[Location].[All]</Value>
</Values>
</DefaultValue>
<Prompt>EmployeeLocation</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>EmployeeLocation</DataSetName>
<ValueField>ParameterValue</ValueField>
<LabelField>ParameterCaptionIndented</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="EmployeeFullPartTime">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Employee].[Employee Fulltime Parttime].[All]</Value>
</Values>
</DefaultValue>
<Prompt>EmployeeFullPartTime</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>EmployeeFullPartTime</DataSetName>
<ValueField>ParameterValue</ValueField>
<LabelField>ParameterCaptionIndented</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="EmployeeFunction">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Employee].[Function Desc].[All]</Value>
</Values>
</DefaultValue>
<Prompt>EmployeeFunction</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>EmployeeFunction</DataSetName>
<ValueField>ParameterValue</ValueField>
<LabelField>ParameterCaptionIndented</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
</ReportParameters>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
<rd:ReportID>a9d82041-871e-49a9-a1d1-025ed129d5e7</rd:ReportID>
</Report>