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
    }
  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
Date_Of_Birth	System.String
Employee_Count	System.Int32
Employee_Fulltime_Parttime	System.String
EmployeeAge		=DateDiff("yyyy",Fields!Date_Of_Birth.Value,Now())
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