0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 5808608d-7763-4c67-9517-32c135fbe065 RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!DateCalendarPeriodFilter.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitControlOrgUnit.Value =Parameters!UserId.Value SELECT NON EMPTY { [Measures].[Amount] ,[Measures].[Actuals Amount Debit] ,[Measures].[Commitment Amount Debit] ,[Measures].[Encumbrance Amount Debit] ,[Measures].[Actuals Amount Credit] ,[Measures].[Commitment Amount Credit] ,[Measures].[Encumbrance Amount Credit] ,[Measures].[Budget Amount Debit] ,[Measures].[Budget Amount Credit] } on Columns, NON EMPTY { [Date].[Calendar Period].[Calendar Period].ALLMEMBERS* [Org Unit].[Fund Code].[Fund Code].ALLMEMBERS* [Org Unit].[Fund].[Fund].ALLMEMBERS* [Gl Code].[Gl Class].Children* [Gl Code].[Gl Class Code].Children* [Gl Code].[Gl Category Code Desc].Children* [Gl Code].[Gl Sub Category Description].Children* [Gl Code].[Gl Code AK].Children* [Gl Code].[Gl Code Name].Children } on rows FROM ( SELECT STRTOSET(@DateFiscalYear) ON COLUMNS FROM ( SELECT STRTOSET(@OrgUnitFundCode) ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitControlOrgUnit) ,{STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".FirstSibling") : STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7))} , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) MDXQueryDateCalendar Period[Date].[Calendar Period]Calendar Period[Date].[Calendar Period].[Calendar Period]Calendar PeriodOrg UnitFund Code[Org Unit].[Fund Code]Fund Code[Org Unit].[Fund Code].[Fund Code]Fund CodeOrg UnitFund[Org Unit].[Fund]Fund[Org Unit].[Fund].[Fund]FundGl CodeGl Class[Gl Code].[Gl Class]Gl Class[Gl Code].[Gl Class].[Gl Class]Gl ClassGl CodeGl Class Code[Gl Code].[Gl Class Code]Gl Class Code[Gl Code].[Gl Class Code].[Gl Class Code]Gl Class CodeGl 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 CodeGl Code Name[Gl Code].[Gl Code Name]Gl Code Name[Gl Code].[Gl Code Name].[Gl Code Name]Gl Code NameAmount[Measures].[Amount]AmounttrueActuals Amount Debit[Measures].[Actuals Amount Debit]Actuals Amount DebittrueCommitment Amount Debit[Measures].[Commitment Amount Debit]Commitment Amount DebittrueEncumbrance Amount Debit[Measures].[Encumbrance Amount Debit]Encumbrance Amount DebittrueActuals Amount Credit[Measures].[Actuals Amount Credit]Actuals Amount CredittrueCommitment Amount Credit[Measures].[Commitment Amount Credit]Commitment Amount CredittrueEncumbrance Amount Credit[Measures].[Encumbrance Amount Credit]Encumbrance Amount CredittrueBudget Amount Debit[Measures].[Budget Amount Debit]Budget Amount DebittrueBudget Amount Credit[Measures].[Budget Amount Credit]Budget Amount CredittrueExecutive_Integrated_FinancialsSELECT NON EMPTY { [Measures].[Amount] ,[Measures].[Actuals Amount Debit] ,[Measures].[Commitment Amount Debit] ,[Measures].[Encumbrance Amount Debit] ,[Measures].[Actuals Amount Credit] ,[Measures].[Commitment Amount Credit] ,[Measures].[Encumbrance Amount Credit] ,[Measures].[Budget Amount Debit] ,[Measures].[Budget Amount Credit] } on Columns, NON EMPTY { [Date].[Calendar Period].[Calendar Period].ALLMEMBERS* [Org Unit].[Fund Code].[Fund Code].ALLMEMBERS* [Org Unit].[Fund].[Fund].ALLMEMBERS* [Gl Code].[Gl Class].Children* [Gl Code].[Gl Class Code].Children* [Gl Code].[Gl Category Code Desc].Children* [Gl Code].[Gl Sub Category Description].Children* [Gl Code].[Gl Code AK].Children* [Gl Code].[Gl Code Name].Children } on rows FROM ( SELECT STRTOSET(@DateFiscalYear) ON COLUMNS FROM ( SELECT STRTOSET(@OrgUnitFundCode) ON COLUMNS FROM [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitControlOrgUnit) ,{STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".FirstSibling") : STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7))} , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) 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]DateCalendarPeriodFilter[Date].[Calendar Period Filter].&[201304]Date.Calendar Period Filter[Date].[Calendar Period Filter]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Calendar Period Filter].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]OrgUnitFundCode[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]trueOrgUnitControlOrgUnit[Org Unit].[Control Org Unit].[All]Control Org Unit[Org Unit].[Control Org Unit]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Control Org Unit].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]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="[Date].[Calendar Period].[Calendar Period]" /> 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="[Org Unit].[Fund].[Fund]" /> 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 Class].[Gl Class]" /> 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 Class Code].[Gl Class 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 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="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="[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].[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="Measure" UniqueName="[Measures].[Actuals Amount Debit]" /> 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].[Commitment Amount Debit]" /> 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].[Encumbrance Amount Debit]" /> 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].[Actuals Amount Credit]" /> System.Int32 =Iif(Fields!Gl_Class_Code.Value = "3",Fields!Actuals_Amount_Debit.Value + Fields!Commitment_Amount_Debit.Value + Fields!Encumbrance_Amount_Debit.Value + Fields!Budget_Amount_Debit.Value, Fields!Actuals_Amount_Debit.Value) <?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].[Commitment Amount Credit]" /> 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].[Budget Amount Debit]" /> System.Int32 =iif(Fields!Gl_Class_Code.Value = "3", Fields!Actuals_Amount_Credit.Value + Fields!Commitment_Amount_Credit.Value + Fields!Encumbrance_Amount_Credit.Value + Fields!Budget_Amount_Credit.Value, Fields!Actuals_Amount_Credit.Value) <?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 Credit]" /> 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].[Encumbrance Amount Credit]" /> System.Int32 =Fields!Amount.Value + Fields!Debit_Amount.Value - Fields!Credit_Amount.Value 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_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] ) 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="[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 System.String RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] ) MDXQueryDateCalendar Period Filter[Date].[Calendar Period Filter]Calendar Period Filter[Date].[Calendar Period Filter].[Calendar Period Filter]Calendar Period FilterParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] )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]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="Level" UniqueName="[Date].[Calendar Period Filter].[Calendar Period Filter]" /> 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 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] 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].[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 System.String RSDS_EnterpriseDW_SSAS =Parameters!OrgUnitFundCode.Value WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Control Org Unit].ALLMEMBERS ON ROWS FROM ( SELECT StrToSet (@OrgUnitFundCode ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] ) MDXQueryOrg UnitControl Org Unit[Org Unit].[Control Org Unit]Control Org Unit[Org Unit].[Control Org Unit].[Control Org Unit]Control Org UnitParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Org Unit].[Control Org Unit].ALLMEMBERS ON ROWS FROM ( SELECT StrToSet (@OrgUnitFundCode ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] )OrgUnitFundCode[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]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="Level" UniqueName="[Org Unit].[Control Org Unit].[Control 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].[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_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] MDXQueryParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH 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_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 SELECT ImageType, ImageLocation, SuggestedImageSize FROM Configuration_Image WHERE (ImageType = 'Banner') ImageType System.String ImageLocation System.String SuggestedImageSize System.String true true Fund =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Gl Class =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Gl Category =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Gl Sub Category =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Gl Code =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.53125in 1.34375in 1.17708in 1.17708in 1.21875in 0.25in true true =Fields!Gl_Code_Name.Value =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),True) 2pt 2pt 2pt 2pt true true =Sum(Fields!Amount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true true =Sum(Fields!Debit_Amount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_Amount.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true true =Sum(Fields!Balance.Value) =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt 0.25in true true =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Amount.Value) =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Debit_Amount.Value) =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_Amount.Value) =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Balance.Value) =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true =Sum(Fields!Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Debit_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Balance.Value) 2pt 2pt 2pt 2pt 0.25in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Debit_Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Balance.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true =Sum(Fields!Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Debit_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Balance.Value) 2pt 2pt 2pt 2pt 0.25in true true Gl Code Name =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Beginning Balance Textbox7 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Year to Date Debit Textbox81 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Year to Date Credit Textbox87 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Balance Textbox13 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Fund.Value =Fields!Fund_Code.Value 2in true true =Fields!Fund.Value 2pt 2pt 2pt 2pt =Fields!Gl_Class.Value =Fields!Gl_Class_Code.Value 1in true true =Fields!Gl_Class.Value =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Gl_Category_Code_Desc.Value =Fields!Gl_Category_Code_Desc.Value 1.91667in 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.02084in true true =Fields!Gl_Sub_Category_Description.Value =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Gl_Code_AK.Value =Fields!Gl_Code_AK.Value 0.92708in true true =Fields!Gl_Code_AK.Value =Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundAlternateColor.Value, "GetColors"),False) 2pt 2pt 2pt 2pt true Gl_Sub_Category_Description 0.92708in true true Total =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt true Gl_Category_Code_Desc 2.02084in true true 2pt 2pt 2pt 2pt 0.92708in true true 2pt 2pt 2pt 2pt Before true Gl_Class 1.91667in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 2.02084in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.92708in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Fund 1in true true 2pt 2pt 2pt 2pt 1.91667in true true 2pt 2pt 2pt 2pt 2.02084in true true 2pt 2pt 2pt 2pt 0.92708in true true 2pt 2pt 2pt 2pt Before TrialBalance_Query 1.0925in 0.01959in 1.5in 14.3125in External =First(Fields!ImageLocation.Value, "GetImage") FitProportional 0.28062in 3.69667in 0.5in 7.17708in 1 HETGroup 2.5925in