ActiveAssignments4.22917in6.35417inWhiteNone4.22917in6.35417in1in1in1in1in0RSDS_EnterpriseDW_SSASNone1cacf018-af12-42bb-b8ac-154ba9328439RSDS_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 [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 [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 [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 [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 [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.Value SELECT NON EMPTY { [Measures].[Count Of Active Assignments] } ON COLUMNS, NON EMPTY { ([Position].[Position Fulltime Parttime].[Position Fulltime Parttime].ALLMEMBERS * [Position].[Position Type Code].[Position Type Code].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@PositionLocation, CONSTRAINED).Count = 1, STRTOSET(@PositionLocation, CONSTRAINED), [Position].[Location].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXHR_Payroll[Position].[Location][Position].[Location].[All]true[Position].[Position Fulltime Parttime][Position].[Position Fulltime Parttime].[All]true SELECT NON EMPTY { [Measures].[Count Of Active Assignments] } ON COLUMNS, NON EMPTY { ([Position].[Position Fulltime Parttime].[Position Fulltime Parttime].ALLMEMBERS * [Position].[Position Type Code].[Position Type Code].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionPositionFulltimeParttime, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@PositionLocation, CONSTRAINED).Count = 1, STRTOSET(@PositionLocation, CONSTRAINED), [Position].[Location].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 [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 [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 [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].[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 Type Code].[Position Type 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="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="Measure" UniqueName="[Measures].[Count Of Active Assignments]" />System.Int32=Replace(Fields!Position_Type.Value,"Personnel Cost-","")=Fields!Count_Of_Active_Assignments.ValueGreaterThan0String[Position].[Location].[All]LocationPositionLocationParameterValueParameterCaptionIndentedtrueString[Position].[Position Fulltime Parttime].[All]Position Fulltime ParttimePositionPositionFulltimeParttimeParameterValueParameterCaptionIndentedtrueInchc1c0cfd7-06b6-42cb-a7ee-771a162c8f39