2.10417in1.85417in0.76042in0.65625in0.54167in0.91667in0.65625in0.25intruetrueLocationTextbox12pt2pt2pt2pttruetrueFull NameTextbox32pt2pt2pt2pttruetrueFT / PTTextbox72pt2pt2pt2pttruetrueGenderTextbox52pt2pt2pt2pttruetrueAgeTextbox92pt2pt2pt2pttruetrue# Of Active AssignmentsTextbox112pt2pt2pt2pttruetrueYears Of ServiceTextbox132pt2pt2pt2pt0.25intruetrue=Fields!Location.ValueLocation2pt2pt2pt2pttruetrue=Fields!Full_Name.ValueFull_Name2pt2pt2pt2pttruetrue=Fields!Employee_Fulltime_Parttime.ValueEmployee_Fulltime_Parttime2pt2pt2pt2pttruetrue=Fields!Gender.ValueGender2pt2pt2pt2pttruetrue=Fields!Employee_Age.ValueEmployeeAge2pt2pt2pt2pttruetrue=Fields!Number_Of_Active_Assignments.ValueNumber_Of_Active_Assignments2pt2pt2pt2pttruetrue=Fields!Years_Of_Service_To_Institution.ValueYears_Of_Service_To_Institution2pt2pt2pt2ptAfterEmployeeAgeRange_Query=Fields!Location.Value=Fields!Full_Name.Value0.5in7.4896in0.52083in7.4896in1in1in1in1in0RSDS_EnterpriseDW_SSASNone900aaef5-1391-4a99-abcb-96f0b33af439RSDS_EnterpriseDW_SSAS=Parameters!EmployeeLocation.Value=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueSELECT
NON EMPTY
{[Measures].[Employee Count]} ON COLUMNS
,NON EMPTY
{
[Employee].[Location].[Location].ALLMEMBERS*
[Employee].[Gender].[Gender].ALLMEMBERS*
[Employee].[Employee Fulltime Parttime].[Employee Fulltime Parttime].ALLMEMBERS*
[Employee].[Full Name].[Full Name].ALLMEMBERS*
[Employee].[Number Of Active Assignments].[Number Of Active Assignments].ALLMEMBERS*
[Employee].[Years Of Service To Institution].[Years Of Service To Institution].ALLMEMBERS*
[Employee].[Date Of Birth].[Date Of Birth].ALLMEMBERS*
[Employee].[Employee Age].[Employee Age].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet(@EmployeeLocation
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet(@EmployeeFullPartTime
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
{[Employee].[Has Active Assignment].&[Yes]} ON COLUMNS
FROM [HR_Payroll]
)
)
)
WHERE
(
StrToSet(@EmployeeFunction)
)MDXQueryHR_PayrollSELECT
NON EMPTY
{[Measures].[Employee Count]} ON COLUMNS
,NON EMPTY
{
[Employee].[Location].[Location].ALLMEMBERS*
[Employee].[Gender].[Gender].ALLMEMBERS*
[Employee].[Employee Fulltime Parttime].[Employee Fulltime Parttime].ALLMEMBERS*
[Employee].[Full Name].[Full Name].ALLMEMBERS*
[Employee].[Number Of Active Assignments].[Number Of Active Assignments].ALLMEMBERS*
[Employee].[Years Of Service To Institution].[Years Of Service To Institution].ALLMEMBERS*
[Employee].[Date Of Birth].[Date Of Birth].ALLMEMBERS*
[Employee].[Employee Age].[Employee Age].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet(@EmployeeLocation
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet(@EmployeeFullPartTime
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
{[Employee].[Has Active Assignment].&[Yes]} ON COLUMNS
FROM [HR_Payroll]
)
)
)
WHERE
(
StrToSet(@EmployeeFunction)
)
EmployeeLocation[Employee].[Location].[All]
EmployeeLocation
[Employee].[Location]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]trueEmployeeFullPartTime[Employee].[Employee Fulltime Parttime].[All]
EmployeeFullPartTime
[Employee].[Employee Fulltime Parttime]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]trueEmployeeFunction[Employee].[Function Desc].[All]
EmployeeFunction
[Employee].[Function Desc]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]true<?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].[Location].[Location]" />System.String<?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].[Gender].[Gender]" />System.String<?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].[Employee Fulltime Parttime].[Employee Fulltime Parttime]" />System.String<?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].[Date Of Birth].[Date Of Birth]" />System.String<?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]" />System.Int32<?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].[Full Name].[Full Name]" />System.String<?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].[Employee Age].[Employee Age]" />System.String<?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].[Number Of Active Assignments].[Number Of Active Assignments]" />System.String<?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]" />System.String=iif(Fields!Employee_Age.Value < 18,1,0)=iif(Fields!Employee_Age.Value >= 18 and Fields!Employee_Age.Value <= 25,1,0)=iif(Fields!Employee_Age.Value > 25 and Fields!Employee_Age.Value <= 35,1,0)=iif(Fields!Employee_Age.Value > 35 and Fields!Employee_Age.Value <= 45,1,0)=iif(Fields!Employee_Age.Value > 45 and Fields!Employee_Age.Value <= 55,1,0)=iif(Fields!Employee_Age.Value > 60 and Fields!Employee_Age.Value <= 65,1,0)=iif(Fields!Employee_Age.Value > 65 and Fields!Employee_Age.Value <= 70,1,0)=iif(Fields!Employee_Age.Value > 55 and Fields!Employee_Age.Value <= 60,1,0)=iif(Fields!Employee_Age.Value > 70,1,0)=IIF(Parameters!AgeRangeValue.Value = 0 AND Fields!Employee_Age.Value < 18,1,
IIF(Parameters!AgeRangeValue.Value = 1 AND Fields!Employee_Age.Value >= 18 AND Fields!Employee_Age.Value <= 25, 1,
IIF(Parameters!AgeRangeValue.Value = 2 AND Fields!Employee_Age.Value > 25 AND Fields!Employee_Age.Value <= 35, 1,
IIF(Parameters!AgeRangeValue.Value = 3 AND Fields!Employee_Age.Value > 35 AND Fields!Employee_Age.Value <= 45, 1,
IIF(Parameters!AgeRangeValue.Value = 4 AND Fields!Employee_Age.Value > 45 AND Fields!Employee_Age.Value <= 55, 1,
IIF(Parameters!AgeRangeValue.Value = 5 AND Fields!Employee_Age.Value > 55 AND Fields!Employee_Age.Value <= 60, 1,
IIF(Parameters!AgeRangeValue.Value = 6 AND Fields!Employee_Age.Value > 60 AND Fields!Employee_Age.Value <= 65, 1,
IIF(Parameters!AgeRangeValue.Value = 7 AND Fields!Employee_Age.Value > 65 AND Fields!Employee_Age.Value <= 70, 1,
IIF(Parameters!AgeRangeValue.Value = 8 AND Fields!Employee_Age.Value > 70, 1,0)))))))))Equal1RSDS_EnterpriseDW_SSASWITH 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]MDXQueryHR_PayrollWITH 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]truetrue<?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]" />System.Int32<?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]" />System.Int32<?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]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSASWITH 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]MDXQueryHR_PayrollWITH 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]truetrue<?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]" />System.Int32<?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]" />System.Int32<?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]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSASWITH 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]MDXQueryHR_PayrollWITH 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]truetrue<?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]" />System.Int32<?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]" />System.Int32<?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]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringStringtrueAgeRangeValue012345678String[Employee].[Location].[All]EmployeeLocationEmployeeLocationParameterValueParameterCaptionIndentedtrueString[Employee].[Employee Fulltime Parttime].[All]EmployeeFullPartTimeEmployeeFullPartTimeParameterValueParameterCaptionIndentedtrueString[Employee].[Function Desc].[All]EmployeeFunctionEmployeeFunctionParameterValueParameterCaptionIndentedtrueIncha9d82041-871e-49a9-a1d1-025ed129d5e7