0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 7b945d79-7e23-4349-9363-1c3a7b045fca RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value SELECT NON EMPTY { [Measures].[Expense Amount] } ON COLUMNS, NON EMPTY { ([Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Assignment].[Assignment AK].[Assignment AK].ALLMEMBERS * [Assignment].[Assignment Status].[Assignment Status].ALLMEMBERS * [Employee].[Full Name].[Full Name].ALLMEMBERS * [Org Unit].[Org Unit].[Org Unit].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Position].[Multiple Funds].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@DateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@DateFiscalYear, CONSTRAINED), [Date].[Fiscal Year].currentmember ), [Position].[Multiple Funds].&[Yes] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS MDXHR_Payroll[Date].[Fiscal Year][Date].[Fiscal Year].&[FY 2015]true[Position].[Multiple Funds][Position].[Multiple Funds].&[Yes] SELECT NON EMPTY { [Measures].[Expense Amount] } ON COLUMNS, NON EMPTY { ([Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Assignment].[Assignment AK].[Assignment AK].ALLMEMBERS * [Assignment].[Assignment Status].[Assignment Status].ALLMEMBERS * [Employee].[Full Name].[Full Name].ALLMEMBERS * [Org Unit].[Org Unit].[Org Unit].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Position].[Multiple Funds].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@DateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@DateFiscalYear, CONSTRAINED), [Date].[Fiscal Year].currentmember ), [Position].[Multiple Funds].&[Yes] ) 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 [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="[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="Level" UniqueName="[Assignment].[Assignment AK].[Assignment AK]" /> 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 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="[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="[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="[Org Unit].[Org Unit].[Org Unit]" /> 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].[Expense Amount]" /> System.Int32 RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] MDX Query Executive_Integrated_Financials WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] true 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="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.Value System.String RSDS_EnterpriseDW SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'GeneralLedger') BackgroundColor System.String BackgroundAlternateColor System.String Band1Color System.String Band2Color System.String Band3Color System.String Band4Color System.String Band5Color System.String Band6Color System.String RSDS_EnterpriseDW SELECT ImageType, ImageLocation, SuggestedImageSize FROM Configuration_Image WHERE (ImageType = 'Banner') ImageType System.String ImageLocation System.String SuggestedImageSize System.String RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Date].[Fiscal Year].Children ON ROWS FROM [HR_Payroll] WHERE [Date].[Is Current Fiscal Year].&[Y] MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Date].[Fiscal Year].Children ON ROWS FROM [HR_Payroll] WHERE [Date].[Is Current Fiscal Year].&[Y] <?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="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 RSDS_EnterpriseDW_SSAS 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, ORDER( {[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC ) ON ROWS FROM ( SELECT { ([Date].[Fiscal Year].[Fiscal Year].Members ,[Date].[Is Current Fiscal Year].&[Y] ,[Date].[Is Available For Finance].&[Y]) , ([Date].[Fiscal Year].[Fiscal Year].Members ,[Date].[Is Current Fiscal Year].Children ,[Date].[Is Available For Finance].&[Y] ) } 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, ORDER( {[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC ) ON ROWS FROM ( SELECT { ([Date].[Fiscal Year].[Fiscal Year].Members ,[Date].[Is Current Fiscal Year].&[Y] ,[Date].[Is Available For Finance].&[Y]) , ([Date].[Fiscal Year].[Fiscal Year].Members ,[Date].[Is Current Fiscal Year].Children ,[Date].[Is Available For Finance].&[Y] ) } ON COLUMNS FROM [HR_Payroll] ) <?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="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.Value RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] <?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="[Org Unit].[Fund Code].[Fund 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].[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.Value RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Function Description].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Function Description].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Function Description].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Function Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] MDXQueryExecutive_Integrated_Financials WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Function Description].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Function Description].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Function Description].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Function Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] <?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="[Org Unit].[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="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.Value RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials] 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="[Org Unit].[Location Description].[Location 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="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.Value System.String External =First(Fields!ImageLocation.Value, "GetImage") FitProportional 0.16604in 2.36396in 0.5in 7.17708in HETGroup true true Position Code =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Position Title =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Full Name =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Assignment =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Org Unit =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1in 0.25in true true =Sum(Fields!Expense_Amount.Value) =First(Fields!BackgroundColor.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Expense_Amount.Value) =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Expense Amount =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Position_Code.Value =Fields!Position_Code.Value 1in true true =Fields!Position_Code.Value =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Position_Title.Value =Fields!Position_Title.Value 2.05208in true true =Fields!Position_Title.Value =First(Fields!BackgroundColor.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Full_Name.Value =Fields!Full_Name.Value 2.57292in true true =Fields!Full_Name.Value =First(Fields!BackgroundColor.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Assignment_AK.Value =Fields!Assignment_AK.Value 1.91604in true true =Fields!Assignment_AK.Value =First(Fields!BackgroundColor.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Org_Unit.Value =Fields!Org_Unit.Value 2.47917in true true =Fields!Org_Unit.Value =First(Fields!BackgroundColor.Value, "GetColors") 2pt 2pt 2pt 2pt 4.625in true true =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt 1.91604in true true =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt 2.47917in true true =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt Before MultipleFunds_Query 1.32167in 0.01103in 0.75in 11.02021in 1 true true Positions with Multiple Funds Report Textbox1 0.85292in 3.50917in 0.25in 4.76042in 2 2pt 2pt 2pt 2pt 2.07167in