VacantPositions_Query4.23833in6.5inWhiteNone4.23833in6.5in1in1in1in1in0RSDS_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.Value=Parameters!PositionPositionFulltimeParttime.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 ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) 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 ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) 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])truePositionPositionFulltimeParttime[Position].[Position Fulltime Parttime].[All]
Position Fulltime Parttime
[Position].[Position Fulltime Parttime]WITH 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]))WITH 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]))PositionLocationtruetruetrue<?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!PositionPositionFulltimeParttime.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 ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) 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]true[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 ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionInactiveVacantDateRange, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) 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])truePositionPositionFulltimeParttime[Position].[Position Fulltime Parttime].[All]
Position Fulltime Parttime
[Position].[Position Fulltime Parttime]WITH 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]))WITH 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]))PositionLocationtruePositionInactiveVacantDateRange[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 ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) 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 ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Position].[Position Status].&[Vacant] } ) ON COLUMNS FROM [HR_Payroll])))PositionLocationPositionPositionFulltimeParttimetrue<?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="Measure" UniqueName="[Measures].[Position Count]" />System.Int32=Replace(Fields!Position_Type.Value,"Personnel Cost-","")String[Position].[Location].[All]LocationPositionLocationParameterValueParameterCaptionIndentedtrueString[Position].[Position Fulltime Parttime].[All]Position Fulltime ParttimePositionPositionFulltimeParttimeParameterValueParameterCaptionIndentedtrueString[Position].[Inactive Vacant Date Range].[All]Inactive Vacant Date RangePositionInactiveVacantDateRangeParameterValueParameterCaptionIndentedtrueInch16f5b0e1-0918-42dc-bf01-f0641e6f47ad