Report Data Set - EmployeeAgeRange

Property	Value
DataSetName	EmployeeAgeRange_Query
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX	True
Query Command Type	MDX
Query Data Source Name	RSDS_EnterpriseDW_SSAS
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security

SELECT
  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)
)

Field Name	Field Type	Field Value
Age18to25		=iif(Fields!Employee_Age.Value >= 18 and Fields!Employee_Age.Value <= 25,1,0)
Age26to35		=iif(Fields!Employee_Age.Value > 25 and Fields!Employee_Age.Value <= 35,1,0)
Age36to45		=iif(Fields!Employee_Age.Value > 35 and Fields!Employee_Age.Value <= 45,1,0)
Age45to55		=iif(Fields!Employee_Age.Value > 45 and Fields!Employee_Age.Value <= 55,1,0)
Age56to60		=iif(Fields!Employee_Age.Value > 55 and Fields!Employee_Age.Value <= 60,1,0)
Age61to65		=iif(Fields!Employee_Age.Value > 60 and Fields!Employee_Age.Value <= 65,1,0)
Age66to70		=iif(Fields!Employee_Age.Value > 65 and Fields!Employee_Age.Value <= 70,1,0)
Age70Over		=iif(Fields!Employee_Age.Value > 70,1,0)
AgeLessThan18		=iif(Fields!Employee_Age.Value < 18,1,0)
Date_Of_Birth	System.String
Employee_Age	System.String
Employee_Count	System.Int32
Employee_Fulltime_Parttime	System.String
Full_Name	System.String
Gender	System.String
Location	System.String
Number_Of_Active_Assignments	System.String
ParameterCaption	System.Int32
ParameterCaption	System.Int32
ParameterCaption	System.Int32
ParameterCaptionIndented	System.String	=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented	System.String	=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented	System.String	=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel	System.Int32
ParameterLevel	System.Int32
ParameterLevel	System.Int32
ParameterValue	System.Int32
ParameterValue	System.Int32
ParameterValue	System.Int32
Years_Of_Service_To_Institution	System.String

Parameter Name	Parameter Value
EmployeeFullPartTime	=Parameters!EmployeeFullPartTime.Value
EmployeeFunction	=Parameters!EmployeeFunction.Value
EmployeeLocation	=Parameters!EmployeeLocation.Value