truetrueMonthTextbox42pt2pt2pt2pttruetruePartTime TypeTextbox92pt2pt2pt2pttruetrueFunction DescriptionTextbox112pt2pt2pt2pttruetrueStart Date of Work WeekTextbox12pt2pt2pt2pttruetrueTime TypeTextbox52pt2pt2pt2pt1in0.25intruetrue=FORMAT(Sum(Fields!Hours_Worked.Value),"#,###.00")Hours_Worked2pt2pt2pt2pt0.25intruetrueHours WorkedTextbox22pt2pt2pt2pt=Fields!Month_Of_Year.Value=Fields!Fiscal_Period_Of_Year.Value1intruetrue=Fields!Month_Of_Year.ValueMonth_Of_Year2pt2pt2pt2pt=Fields!Regular_Temporary.Value=Fields!Regular_Temporary.Value1.30208intruetrue=Fields!Regular_Temporary.ValueRegular_Temporary2pt2pt2pt2pt=Fields!Function_Description.Value=Fields!Function_Description.Value2.02083intruetrue=Fields!Function_Description.ValueFunction_Description2pt2pt2pt2pt=Fields!Date_Name.Value=Fields!Date_Name.Value1intruetrue=Fields!Date_Name.ValueDate_Name2pt2pt2pt2pt=Fields!Time_Type.Value=Fields!Time_Type.Value1intruetrue=Fields!Time_Type.ValueTime_Type2pt2pt2pt2pttrueRegular_TemporaryHoursWorked_Query=Fields!Fiscal_Period_Of_Year.Value1.00694in0.5in7.32291inExternal=First(Fields!ImageLocation.Value, "GetImage")FitProportional0.60417in0.5in7.17708in1HETGrouptruetrueHours Worked ReportTextbox30.62375in2.19667in0.25in3.26042in22pt2pt2pt2pt2.02778in9.10416in1in1in1in1in0RSDS_EnterpriseDW_SSASNonedf52df5f-a6fc-4a0f-84f4-7d5659d38bd1RSDS_EnterpriseDWNone18572d48-cb79-4474-888e-d575cf281cc0RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!PositionLocation.Value SELECT NON EMPTY { [Measures].[Hours Worked] } ON COLUMNS, NON EMPTY { ([Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS * [Date].[Month Of Year].[Month Of Year].ALLMEMBERS * [Date].[Fiscal Period Of Year].[Fiscal Period Of Year].ALLMEMBERS * [Position].[Function Description].[Function Description].ALLMEMBERS * [Assignment].[Regular Temporary].[Regular Temporary].ALLMEMBERS * [Date].[Date Name].[Date Name].ALLMEMBERS * [Time Type].[Time Type].[Time Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll]))) WHERE ( [Assignment].[Assignment Fulltime Parttime].&[Part Time], 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[Assignment].[Assignment Fulltime Parttime][Assignment].[Assignment Fulltime Parttime].&[Part Time][Date].[Fiscal Year][Date].[Fiscal Year].&[FY 2015]true[Position].[Location][Position].[Location].[All]true SELECT NON EMPTY { [Measures].[Hours Worked] } ON COLUMNS, NON EMPTY { ([Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS * [Date].[Month Of Year].[Month Of Year].ALLMEMBERS * [Date].[Fiscal Period Of Year].[Fiscal Period Of Year].ALLMEMBERS * [Position].[Function Description].[Function Description].ALLMEMBERS * [Assignment].[Regular Temporary].[Regular Temporary].ALLMEMBERS * [Date].[Date Name].[Date Name].ALLMEMBERS * [Time Type].[Time Type].[Time Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PositionLocation, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll]))) WHERE ( [Assignment].[Assignment Fulltime Parttime].&[Part Time], 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_FLAGSDateFiscalYear[Date].[Fiscal Year].&[FY 2015]
Date.Fiscal Year
[Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll])truePositionLocation[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 ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll]))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 ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll]))DateFiscalYeartrue<?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="[Date].[Fiscal Year].[Fiscal Year]" />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].[Function Description].[Function Description]" />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="[Date].[Month Of Year].[Month Of Year]" />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="[Date].[Fiscal Period Of Year].[Fiscal Period Of Year]" />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="[Assignment].[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="[Time Type].[Time Type].[Time 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="[Date].[Date Name].[Date 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="Measure" UniqueName="[Measures].[Hours Worked]" />System.Int32RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll])MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) 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_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.ValueWITH 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 ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) 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 ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) ON COLUMNS FROM [HR_Payroll]))DateFiscalYear[Date].[Fiscal Year].&[FY 2015]
Date.Fiscal Year
[Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Assignment].[Assignment Fulltime Parttime].&[Part Time] } ) 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.StringString[Date].[Fiscal Year].&[FY 2015]Date.Fiscal YearDateFiscalYearParameterValueParameterCaptionIndentedtrueString[Position].[Location].[All]LocationPositionLocationParameterValueParameterCaptionIndentedtrueInchc6a9d288-0ba3-4b7b-8d9d-b9ba1ce9dde6