=Sum(Fields!AgeLessThan18.Value)=Sum(Fields!AgeLessThan18.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value0=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.5< 18PrimaryPrimaryBlack0pt=Sum(Fields!Age18to25.Value)=Sum(Fields!Age18to25.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value1=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.518 to 25PrimaryPrimaryBlack0pt=Sum(Fields!Age26to35.Value)=Sum(Fields!Age26to35.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value2=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.526 to 35PrimaryPrimaryBlack0pt=Sum(Fields!Age36to45.Value)=Sum(Fields!Age36to45.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value3=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.536 to 45PrimaryPrimaryBlack0pt=Sum(Fields!Age45to55.Value)=Sum(Fields!Age45to55.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value4=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.546 to 55PrimaryPrimaryBlack0pt=Sum(Fields!Age56to60.Value)=Sum(Fields!Age56to60.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value5=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.556 to 60PrimaryPrimaryBlack0pt=Sum(Fields!Age61to65.Value)=Sum(Fields!Age61to65.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value6=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.561 to 65PrimaryPrimaryBlack0pt=Sum(Fields!Age66to70.Value)=Sum(Fields!Age66to70.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value7=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.566 to 70PrimaryPrimaryBlack0pt=Sum(Fields!Age70Over.Value)=Sum(Fields!Age70Over.Value)EmployeeAgeRangeDetails=Parameters!EmployeeLocation.Value8=Parameters!EmployeeFullPartTime.Value=Parameters!EmployeeFunction.ValueOutputPointWidth1.570+PrimaryPrimaryBlack0pt
Age Range of Employees with Active Assignments
FalseAuto0.5NaNNaNNaNtrue
Axis Title
False0.5NaNOppositeNaNNaN
# of Employee
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaN
BlackBlackPastel
No Data Available
EmployeeAgeRange_Query3.10416in5.28125inWhiteNone3.10416in5.28125in1in1in1in1in0RSDS_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].[Full Name].[Full Name].ALLMEMBERS*
[Employee].[Gender].[Gender].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
{[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].[Full Name].[Full Name].ALLMEMBERS*
[Employee].[Gender].[Gender].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
{[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].[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].[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].[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].[Employee Age].[Employee Age]" />System.String=iif(Fields!Employee_Age.Value < 18,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value >= 18 and Fields!Employee_Age.Value <= 25,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value > 25 and Fields!Employee_Age.Value <= 35,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value > 35 and Fields!Employee_Age.Value <= 45,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value > 45 and Fields!Employee_Age.Value <= 55,Fields!Employee_Count.Value,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,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value > 55 and Fields!Employee_Age.Value <= 60,Fields!Employee_Count.Value,0)=iif(Fields!Employee_Age.Value > 70,Fields!Employee_Count.Value,0)RSDS_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