0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 7b945d79-7e23-4349-9363-1c3a7b045fca RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitFunction.Value =Parameters!OrgUnitLocationDescription.Value =Parameters!UserId.Value Select NON EMPTY { [Measures].[Actuals Amount] ,[Measures].[Budget Amount] }on Columns, NON EMPTY { [Gl Code].[Gl Category Code Desc].[Gl Category Code Desc].ALLMEMBERS* [Gl Code].[Gl Sub Category Description].[Gl Sub Category Description].ALLMEMBERS* [Gl Code].[Gl Code AK].[Gl Code AK].ALLMEMBERS* [Gl Code].[Hr Classification].[Hr Classification].ALLMEMBERS* [Gl Code].[Gl Code Name].CHILDREN* [Org Unit].[Fund Code].[Fund Code].ALLMEMBERS } on rows FROM ( SELECT {[Gl Code].[Hr Classification].&[Salary],[Gl Code].[Hr Classification].&[Overtime]} ON COLUMNS FROM ( SELECT STRTOSET("[Org Unit].[Fund Code].[All]") ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET("[Org Unit].[Location Description].[All]") ,STRTOSET("[Date].[Fiscal Year].&[FY 2015]") ,STRTOSET("[Org Unit].[Function Description].[All]") ,[Gl Code].[Gl Class Code].&[5] ,{[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} ) MDXQueryGl CodeGl Category Code Desc[Gl Code].[Gl Category Code Desc]Gl Category Code Desc[Gl Code].[Gl Category Code Desc].[Gl Category Code Desc]Gl Category Code DescGl CodeGl Sub Category Description[Gl Code].[Gl Sub Category Description]Gl Sub Category Description[Gl Code].[Gl Sub Category Description].[Gl Sub Category Description]Gl Sub Category DescriptionGl CodeGl Code AK[Gl Code].[Gl Code AK]Gl Code AK[Gl Code].[Gl Code AK].[Gl Code AK]Gl Code AKGl CodeHr Classification[Gl Code].[Hr Classification]Hr Classification[Gl Code].[Hr Classification].[Hr Classification]Hr ClassificationGl CodeGl Code Name[Gl Code].[Gl Code Name]Gl Code Name[Gl Code].[Gl Code Name].[Gl Code Name]Gl Code NameOrg UnitFund Code[Org Unit].[Fund Code]Fund Code[Org Unit].[Fund Code].[Fund Code]Fund CodeActuals Amount[Measures].[Actuals Amount]Actuals AmounttrueBudget Amount[Measures].[Budget Amount]Budget AmounttrueExecutive_Integrated_FinancialsSelect NON EMPTY { [Measures].[Actuals Amount] ,[Measures].[Budget Amount] }on Columns, NON EMPTY { [Gl Code].[Gl Category Code Desc].[Gl Category Code Desc].ALLMEMBERS* [Gl Code].[Gl Sub Category Description].[Gl Sub Category Description].ALLMEMBERS* [Gl Code].[Gl Code AK].[Gl Code AK].ALLMEMBERS* [Gl Code].[Hr Classification].[Hr Classification].ALLMEMBERS* [Gl Code].[Gl Code Name].CHILDREN* [Org Unit].[Fund Code].[Fund Code].ALLMEMBERS } on rows FROM ( SELECT {[Gl Code].[Hr Classification].&[Salary],[Gl Code].[Hr Classification].&[Overtime]} ON COLUMNS FROM ( SELECT STRTOSET("[Org Unit].[Fund Code].[All]") ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET("[Org Unit].[Location Description].[All]") ,STRTOSET("[Date].[Fiscal Year].&[FY 2015]") ,STRTOSET("[Org Unit].[Function Description].[All]") ,[Gl Code].[Gl Class Code].&[5] ,{[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} )DateFiscalYear[Date].[Fiscal Year].&[FY 2013]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 [Executive_Integrated_Financials]trueOrgUnitFundCode[Org Unit].[Fund Code].[All]Fund Code[Org Unit].[Fund Code]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]trueOrgUnitLocationDescription[Org Unit].[Location Description].[All]OrgUnitLocationDescription[Org Unit].[Location Description]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]trueUserId[User].[Domain User Id].&[ad\scowan]UserId[User].[Domain User Id]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]OrgUnitFunction[Org Unit].[Function Description].[All]OrgUnitFunction[Org Unit].[Function Description]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]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="[Gl Code].[Gl Category Code Desc].[Gl Category Code Desc]" /> 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="[Gl Code].[Gl Sub Category Description].[Gl Sub Category 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].[Actuals Amount]" /> 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="Level" UniqueName="[Gl Code].[Hr Classification].[Hr Classification]" /> 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="[Gl Code].[Gl Code AK].[Gl Code 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="[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="Level" UniqueName="[Gl Code].[Gl Code Name].[Gl Code 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].[Budget 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 ParameterCaption [Measures].[ParameterCaption] ParameterCaption true ParameterValue [Measures].[ParameterValue] ParameterValue true ParameterLevel [Measures].[ParameterLevel] ParameterLevel true 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 [Executive_Integrated_Financials] WHERE [Date].[Is Current Fiscal Year].&[Y] MDXQueryDateFiscal Year[Date].[Fiscal Year]Fiscal Year[Date].[Fiscal Year].[Fiscal Year]Fiscal YearParameterValue[Measures].[ParameterValue]ParameterValuetrueExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Date].[Fiscal Year].Children ON ROWS FROM [Executive_Integrated_Financials] 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 [Executive_Integrated_Financials] ) MDXQueryDateFiscal Year[Date].[Fiscal Year]Fiscal Year[Date].[Fiscal Year].[Fiscal Year]Fiscal YearParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH 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 [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="[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] MDXQueryOrg UnitFund Code[Org Unit].[Fund Code]Fund Code[Org Unit].[Fund Code].[Fund Code]Fund CodeParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_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] MDXQueryOrg UnitFunction Description[Org Unit].[Function Description]Function Description[Org Unit].[Function Description].[Function Description]Function DescriptionParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_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] MDXQueryOrg UnitLocation Description[Org Unit].[Location Description]Location Description[Org Unit].[Location Description].[Location Description]Location DescriptionParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_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 true true Gl Category =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Job Class =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Classification =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Gl Code =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Description =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Fund =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.22917in 1.25in 0.25in true true =Sum(Fields!Budget_Amount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),True) 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Budget_Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Budget_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Budget_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) 2pt 2pt 2pt 2pt 0.25in true true Budget =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true YTD Spending =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Gl_Category_Code_Desc.Value =Fields!Gl_Category_Code_Desc.Value 3.09437in true true =Fields!Gl_Category_Code_Desc.Value 2pt 2pt 2pt 2pt =Fields!Gl_Sub_Category_Description.Value =Fields!Gl_Sub_Category_Description.Value 2.54166in true true =Fields!Gl_Sub_Category_Description.Value =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Gl_Code_AK.Value =Fields!Gl_Code_AK.Value 1in true true =Fields!Hr_Classification.Value 2pt 2pt 2pt 2pt 0.88542in true true =Fields!Gl_Code_AK.Value 2pt 2pt 2pt 2pt =Fields!Gl_Code_Name.Value =Fields!Gl_Code_Name.Value 2.37375in true true =Fields!Gl_Code_Name.Value 2pt 2pt 2pt 2pt =Fields!Fund_Code.Value =Fields!Fund_Code.Value 0.52083in true true =Fields!Fund_Code.Value =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true Gl_Sub_Category_Description 1in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.88542in true true Total =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 2.37375in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.52083in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Gl_Category_Code_Desc 2.54166in true true Total 2pt 2pt 2pt 2pt 1in true true 2pt 2pt 2pt 2pt 0.88542in true true 2pt 2pt 2pt 2pt 2.37375in true true 2pt 2pt 2pt 2pt 0.52083in true true 2pt 2pt 2pt 2pt Before 3.09437in true true Total 2pt 2pt 2pt 2pt 2.54166in true true 2pt 2pt 2pt 2pt 1in true true 2pt 2pt 2pt 2pt 0.88542in true true 2pt 2pt 2pt 2pt 2.37375in true true 2pt 2pt 2pt 2pt 0.52083in true true 2pt 2pt 2pt 2pt Before SalaryCost_Query 0.85417in 0.11458in 1.25in 12.8952in External =First(Fields!ImageLocation.Value, "GetImage") FitProportional 0.16604in 2.36396in 0.5in 7.17708in 1 HETGroup 2.85292in