0.66667in2.02084in1in0.71875in1.6875in1in0.83333in0.64583in0.25intruetruePosition CodeTextbox72pt2pt2pt2pttruetruePosition TitleTextbox92pt2pt2pt2pttruetrueLocationTextbox12pt2pt2pt2pttruetrueFT / PTTextbox112pt2pt2pt2pttruetruePosition TypeTextbox132pt2pt2pt2pttruetruePay BasisTextbox32pt2pt2pt2pttruetrueRegular TemporaryTextbox52pt2pt2pt2pttruetrueExempt StatusTextbox152pt2pt2pt2pt0.25intruetrue=Fields!Position_Code.ValuePosition_Code2pt2pt2pt2pttruetrue=Fields!Position_Title.ValuePosition_Title2pt2pt2pt2pttruetrue=Fields!Location.ValueLocation2pt2pt2pt2pttruetrue=Fields!Position_Fulltime_Parttime.ValuePosition_Fulltime_Parttime2pt2pt2pt2pttruetrue=Fields!PositionTypeShort.ValuePosition_Type2pt2pt2pt2pttruetrue=Fields!Pay_Basis.ValuePay_Basis2pt2pt2pt2pttruetrue=Fields!Regular_Temporary.ValueRegular_Temporary2pt2pt2pt2pttruetrue=Fields!Exempt_Status.ValueExempt_Status2pt2pt2pt2ptAfterVacantPositions_Query=Fields!Position_Code.Value0.55083in0.01041in0.5in8.57292in3.24875in10.11458in1in1in1in1in0RSDS_EnterpriseDW_SSASNone540c30ea-0620-4f91-9329-85826281dbd4RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Location].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Location].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS 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_SSAS=Parameters!PositionLocation.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Position Fulltime Parttime].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll]))MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Position Fulltime Parttime].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Position Fulltime Parttime].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll]))PositionLocation[Position].[Location].[All]
Location
[Position].[Location]WITH MEMBER [Measures].[ParameterCaption] AS [Position].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Location].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])truetruetrue<?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_SSAS=Parameters!PositionLocation.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Inactive Vacant Date Range].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterCaption] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Inactive Vacant Date Range].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))PositionLocation[Position].[Location].[All]
Location
[Position].[Location]WITH MEMBER [Measures].[ParameterCaption] AS [Position].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Location].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])truetruetrue<?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_SSAS=Parameters!PositionLocation.Value=Parameters!PositionInactiveVacantDateRange.Value SELECT NON EMPTY { [Measures].[Position Count] } ON COLUMNS, NON EMPTY { ([Position].[Location].[Location].ALLMEMBERS * [Position].[Position Fulltime Parttime].[Position Fulltime Parttime].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Pay Basis].[Pay Basis].ALLMEMBERS * [Position].[Regular Temporary].[Regular Temporary].ALLMEMBERS * [Position].[Date Established].[Date Established].ALLMEMBERS * [Position].[Exempt Status].[Exempt Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))) WHERE ( [Position].[Position Status].&[Vacant], IIF( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED).Count = 1, STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED), [Position].[Inactive Vacant Date Range].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXHR_Payroll[Position].[Position Status][Position].[Position Status].&[Vacant][Position].[Location][Position].[Location].[All]true[Position].[Position Fulltime Parttime][Position].[Position Fulltime Parttime].[All][Position].[Inactive Vacant Date Range][Position].[Inactive Vacant Date Range].[All]true SELECT NON EMPTY { [Measures].[Position Count] } ON COLUMNS, NON EMPTY { ([Position].[Location].[Location].ALLMEMBERS * [Position].[Position Fulltime Parttime].[Position Fulltime Parttime].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Pay Basis].[Pay Basis].ALLMEMBERS * [Position].[Regular Temporary].[Regular Temporary].ALLMEMBERS * [Position].[Date Established].[Date Established].ALLMEMBERS * [Position].[Exempt Status].[Exempt Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))) WHERE ( [Position].[Position Status].&[Vacant], IIF( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED).Count = 1, STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED), [Position].[Inactive Vacant Date Range].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSPositionLocation[Position].[Location].[All]
Location
[Position].[Location]WITH MEMBER [Measures].[ParameterCaption] AS [Position].[Location].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Location].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Location].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Location].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])truePositionInactiveVacantDateRange[Position].[Inactive Vacant Date Range].[All]
Inactive Vacant Date Range
[Position].[Inactive Vacant Date Range]WITH MEMBER [Measures].[ParameterCaption] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Inactive Vacant Date Range].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))WITH MEMBER [Measures].[ParameterCaption] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Position].[Inactive Vacant Date Range].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Position].[Inactive Vacant Date Range].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Position].[Position Fulltime Parttime].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))PositionLocationtrue<?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="[Position].[Location].[Location]" />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="[Position].[Position Fulltime Parttime].[Position Fulltime Parttime]" />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="[Position].[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="Level" UniqueName="[Position].[Position Code].[Position Code]" />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].[Position Count]" />System.Int32=Replace(Fields!Position_Type.Value,"Personnel Cost-","")<?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="[Position].[Position Title].[Position Title]" />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="[Position].[Pay Basis].[Pay Basis]" />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="[Position].[Regular Temporary].[Regular Temporary]" />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="[Position].[Date Established].[Date Established]" />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="[Position].[Exempt Status].[Exempt Status]" />System.String=IIF(Fields!PositionTypeShort.Value = Parameters!PositionTypeShort.Value,1,0)Equal1=IIF(Fields!Position_Fulltime_Parttime.Value = Parameters!PositionPositionFulltimeParttime.Value,1,0)Equal1String[Position].[Location].[All]LocationPositionLocationParameterValueParameterCaptionIndentedtrueString[Position].[Position Fulltime Parttime].[All]Position Fulltime ParttimeString[Position].[Inactive Vacant Date Range].[All]Inactive Vacant Date RangePositionInactiveVacantDateRangeParameterValueParameterCaptionIndentedtrueString[Position].[Position Type].[All]PositionTypeShorttrueInch16f5b0e1-0918-42dc-bf01-f0641e6f47ad