EmployeePosition_Query2.01041in3.17708inWhiteNone2.01041in3.17708in1in1in1in1in0RSDS_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].[Position Type].[Position Type].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)
)MDXQueryHR_PayrollSELECT
NON EMPTY
{[Measures].[Employee Count]} ON COLUMNS
,NON EMPTY
{
[Employee].[Position Type].[Position Type].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)
)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].[Position Type].[Position Type]" />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.Int32RSDS_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.StringString[Employee].[Location].[All]EmployeeLocationEmployeeLocationParameterValueParameterCaptionIndentedtrueString[Employee].[Employee Fulltime Parttime].[All]EmployeeFullPartTimeEmployeeFullPartTimeParameterValueParameterCaptionIndentedtrueString[Employee].[Function Desc].[All]EmployeeFunctionEmployeeFunctionParameterValueParameterCaptionIndentedtrueIncha9d82041-871e-49a9-a1d1-025ed129d5e7