0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 7b945d79-7e23-4349-9363-1c3a7b045fca RSDS_EnterpriseDW_SSAS =Parameters!TermTermTitle.Value =Parameters!CurriculumCampus.Value =Parameters!CurriculumPrimaryInstructorType.Value SELECT NON EMPTY {[Measures].[Fee Paid Amount]} ON COLUMNS ,NON EMPTY { [Curriculum].[Campus].[Campus].ALLMEMBERS* [Curriculum].[Division].[Division].ALLMEMBERS* [Curriculum].[Department].[Department].ALLMEMBERS* [Curriculum].[Course Id].[Course Id].ALLMEMBERS* [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS* [Fee Type].[Fee Group].[Fee Group].ALLMEMBERS* [Fee Type].[Fee Type].[Fee Type].ALLMEMBERS } DIMENSION PROPERTIES MEMBER_CAPTION ,MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT StrToSet(@CurriculumCampus) ON COLUMNS FROM [Student_Financials] ) WHERE ( StrToSet(@TermTermTitle) ,StrToSet(@CurriculumPrimaryInstructorType) ) MDXQueryCurriculumCampus[Curriculum].[Campus]Campus[Curriculum].[Campus].[Campus]CampustrueCurriculumDivision[Curriculum].[Division]Division[Curriculum].[Division].[Division]DivisiontrueCurriculumDepartment[Curriculum].[Department]Department[Curriculum].[Department].[Department]DepartmenttrueCurriculumCourse Id[Curriculum].[Course Id]Course Id[Curriculum].[Course Id].[Course Id]Course IdtrueCurriculumReference Number[Curriculum].[Reference Number]Reference Number[Curriculum].[Reference Number].[Reference Number]Reference NumbertrueFee TypeFee Group[Fee Type].[Fee Group]Fee Group[Fee Type].[Fee Group].[Fee Group]Fee GrouptrueFee TypeFee Type[Fee Type].[Fee Type]Fee Type[Fee Type].[Fee Type].[Fee Type]Fee TypetrueFee Paid Amount[Measures].[Fee Paid Amount]Fee Paid AmounttrueStudent_FinancialsSELECT NON EMPTY {[Measures].[Fee Paid Amount]} ON COLUMNS ,NON EMPTY { [Curriculum].[Campus].[Campus].ALLMEMBERS* [Curriculum].[Division].[Division].ALLMEMBERS* [Curriculum].[Department].[Department].ALLMEMBERS* [Curriculum].[Course Id].[Course Id].ALLMEMBERS* [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS* [Fee Type].[Fee Group].[Fee Group].ALLMEMBERS* [Fee Type].[Fee Type].[Fee Type].ALLMEMBERS } DIMENSION PROPERTIES MEMBER_CAPTION ,MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT StrToSet(@CurriculumCampus) ON COLUMNS FROM [Student_Financials] ) WHERE ( StrToSet(@TermTermTitle) ,StrToSet(@CurriculumPrimaryInstructorType) )TermTermTitle[Term].[Term Title].&[20131]TermTermTitle[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]CurriculumCampus[Curriculum].[Campus].[All]CurriculumCampus[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM [Student_Financials]trueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]CurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS FROM [Student_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="[Curriculum].[Campus].[Campus]" /> 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="[Curriculum].[Division].[Division]" /> 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="[Curriculum].[Department].[Department]" /> 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="[Curriculum].[Course Id].[Course Id]" /> 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="[Curriculum].[Reference Number].[Reference Number]" /> 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="[Fee Type].[Fee Group].[Fee Group]" /> 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].[Fee Paid 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="[Fee Type].[Fee Type].[Fee Type]" /> 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].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS "0" --[Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption] , [Measures].[ParameterValue] , [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].Children ON ROWS FROM [Student_Financials] MDXQueryTermTerm Title[Term].[Term Title]Term Title[Term].[Term Title].[Term Title]Term TitleParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueStudent_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS "0" --[Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption] , [Measures].[ParameterValue] , [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].Children ON ROWS FROM [Student_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="[Term].[Term Title].[Term 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="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 [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM [Student_Financials] MDXQueryParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueStudent_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM [Student_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].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS FROM [Student_Financials] MDXQueryParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueStudent_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS FROM [Student_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 [Term].[Term Title].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Term].[Term Title].Children ON ROWS FROM [Student_Financials] WHERE [Term].[Default Term].&[Yes]; MDXQueryTermTerm Title[Term].[Term Title]Term Title[Term].[Term Title].[Term Title]Term TitleParameterValue[Measures].[ParameterValue]ParameterValuetrueStudent_FinancialsWITH MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Term].[Term Title].Children ON ROWS FROM [Student_Financials] WHERE [Term].[Default Term].&[Yes]; <?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="[Term].[Term Title].[Term 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="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 true true Campus =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Division =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Department =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Course Id =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Reference Number =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Fee Group =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Fee Type =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.25in 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Fee_Paid_Amount.Value) 2pt 2pt 2pt 2pt 0.25in true true Fees Paid =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Campus.Value =Fields!Campus.Value 2.29103in true true =Fields!Campus.Value 2pt 2pt 2pt 2pt =Fields!Division.Value =Fields!Division.Value 1.44792in true true =Fields!Division.Value =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Department.Value =Fields!Department.Value 2.08333in true true =Fields!Department.Value 2pt 2pt 2pt 2pt =Fields!Course_Id.Value =Fields!Course_Id.Value 1in true true =Fields!Course_Id.Value =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Reference_Number.Value =Fields!Reference_Number.Value 1in true true =Fields!Reference_Number.Value 2pt 2pt 2pt 2pt =Fields!Fee_Group.Value =Fields!Fee_Group.Value 1.60417in true true =Fields!Fee_Group.Value =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Fee_Type.Value =Fields!Fee_Type.Value 1.92708in true true =Fields!Fee_Type.Value 2pt 2pt 2pt 2pt true Fee_Group 1.92708in true true =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Reference_Number 1.60417in true true =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.92708in true true =First(Fields!Band4Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Course_Id 1in true true =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.60417in true true =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.92708in true true =First(Fields!Band3Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Department 1in true true 2pt 2pt 2pt 2pt 1in true true 2pt 2pt 2pt 2pt 1.60417in true true 2pt 2pt 2pt 2pt 1.92708in true true 2pt 2pt 2pt 2pt Before true Division 2.08333in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.60417in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt 1.92708in true true =First(Fields!Band2Color.Value, "GetColors") 2pt 2pt 2pt 2pt Before true Campus 1.44792in true true 2pt 2pt 2pt 2pt 2.08333in true true 2pt 2pt 2pt 2pt 1in true true 2pt 2pt 2pt 2pt 1in true true 2pt 2pt 2pt 2pt 1.60417in true true 2pt 2pt 2pt 2pt 1.92708in true true 2pt 2pt 2pt 2pt Before FeePaymentsForCourse_Query =IIF(Fields!Reference_Number.Value = -1,1,0) Equal 0 1.27084in 0.07292in 2in 12.60353in External =First(Fields!ImageLocation.Value, "GetImage") FitProportional 0.16604in 2.36395in 0.5in 7.17708in 1 HETGroup true true Fee Payments by Campus, Division and Department Textbox1 0.83208in 3.31187in 0.25in 5.19792in 2 2pt 2pt 2pt 2pt 3.28125in