Report Data Set - EmployeeFunction

Property	Value
DataSetName	EmployeeFunction_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].[Function Desc].[Function Desc].ALLMEMBERS
    }
  DIMENSION PROPERTIES
    MEMBER_CAPTION
   ,MEMBER_UNIQUE_NAME
   ON ROWS
FROM
(
  SELECT
    STRTOSET(@EmployeeFunction) ON COLUMNS
FROM
  (
    SELECT
      {[Employee].[Has Active Assignment].&[Yes]} ON COLUMNS
    FROM [HR_Payroll]
  )
  )
WHERE
(
  StrToSet(@EmployeeLocation)
,StrToSet(@EmployeeFullPartTime)
)

Field Name	Field Type	Field Value
Employee_Count	System.Int32
Function_Desc	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

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