0 RSDS_EnterpriseDW_SSAS None bd64089d-d11f-4ab7-91ec-68dcf833c6b0 RSDS_EnterpriseDW None 272888a5-536a-4c4a-b533-468469acedb1 RSDS_EnterpriseDW_SSAS ="[Relative Day].[TermYearTypeRelativeDay].[Relative Day].&[" + Left(StrReverse(Mid(StrReverse(Parameters!DimTerm_Title_MemberUniqueName.Value),2,5)),4) + "]&[" + Mid(StrReverse(Parameters!DimTerm_Title_MemberUniqueName.Value), 2, 1) + "]&[" + Parameters!IsCurrentDate_Date.Value + "]" =Parameters!DivDept.Value =Parameters!Campus.Value =Parameters!CoursePrefix.Value =Parameters!DeliveryMethod.Value =Parameters!CurSession.Value =Parameters!CreditNonCreditVocationalTest.Value =Parameters!CreditType.Value WITH MEMBER [Measures].[RelativeDaySort] AS [Relative Day].[TermYearTypeRelativeDay].CurrentMember.Properties("Relative Day Full Description Sort 2") SELECT LastPeriods(7, ( StrToMember ( @RelativeDayTermYearTypeRelativeDay ) ) ) ON ROWS , {[Measures].[RelativeDaySort],[Measures].[Credit And Clock Hours Combined], [Measures].[Headcount], [Measures].[Credit And Clock Hours Combined - Current -1], [Measures].[Headcount - Current - 1], [Measures].[Credit And Clock Hours Combined - Current -2], [Measures].[Headcount - Current - 2]} ON COLUMNS FROM [EnrollmentSnapshot] WHERE ( StrToSet(@DivDept) ,StrToSet(@Campus) ,StrToSet(@CoursePrefix) ,StrToSet(@DeliveryMethod) ,StrToSet(@CurSession) ,StrToSet(@CreditNonCreditVocationalTest) ,StrToSet(@CreditType) ); MDXQueryRelative DayTermYearTypeRelativeDay[Relative Day].[TermYearTypeRelativeDay]Term Year[Relative Day].[TermYearTypeRelativeDay].[Term Year]Term YearRelative DayTermYearTypeRelativeDay[Relative Day].[TermYearTypeRelativeDay]Term Type Code[Relative Day].[TermYearTypeRelativeDay].[Term Type Code]Term Type CodeRelative DayTermYearTypeRelativeDay[Relative Day].[TermYearTypeRelativeDay]Relative Day[Relative Day].[TermYearTypeRelativeDay].[Relative Day]Relative DayRelativeDaySort[Measures].[RelativeDaySort]RelativeDaySorttrueCredit And Clock Hours Combined[Measures].[Credit And Clock Hours Combined]Credit And Clock Hours CombinedtrueHeadcount[Measures].[Headcount]HeadcounttrueCredit And Clock Hours Combined - Current -1[Measures].[Credit And Clock Hours Combined - Current -1]Credit And Clock Hours Combined - Current -1trueHeadcount - Current - 1[Measures].[Headcount - Current - 1]Headcount - Current - 1trueCredit And Clock Hours Combined - Current -2[Measures].[Credit And Clock Hours Combined - Current -2]Credit And Clock Hours Combined - Current -2trueHeadcount - Current - 2[Measures].[Headcount - Current - 2]Headcount - Current - 2trueEnrollmentSnapshotWITH MEMBER [Measures].[RelativeDaySort] AS [Relative Day].[TermYearTypeRelativeDay].CurrentMember.Properties("Relative Day Full Description Sort 2") SELECT LastPeriods(7, ( StrToMember ( @RelativeDayTermYearTypeRelativeDay ) ) ) ON ROWS , {[Measures].[RelativeDaySort],[Measures].[Credit And Clock Hours Combined], [Measures].[Headcount], [Measures].[Credit And Clock Hours Combined - Current -1], [Measures].[Headcount - Current - 1], [Measures].[Credit And Clock Hours Combined - Current -2], [Measures].[Headcount - Current - 2]} ON COLUMNS FROM [EnrollmentSnapshot] WHERE ( StrToSet(@DivDept) ,StrToSet(@Campus) ,StrToSet(@CoursePrefix) ,StrToSet(@DeliveryMethod) ,StrToSet(@CurSession) ,StrToSet(@CreditNonCreditVocationalTest) ,StrToSet(@CreditType) ); RelativeDayTermYearTypeRelativeDay[Relative Day].[TermYearTypeRelativeDay].[Relative Day].&[2013]&[1]&[20120901]TermYearTypeRelativeDay[Relative Day].[TermYearTypeRelativeDay]WITH MEMBER [Measures].[ParameterCaption] AS [Relative Day].[TermYearTypeRelativeDay].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Relative Day].[TermYearTypeRelativeDay].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Relative Day].[TermYearTypeRelativeDay].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Relative Day].[TermYearTypeRelativeDay].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]DivDept[Curriculum].[Div Dept].[All]DivDept[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]trueCampus[Curriculum].[Campus].[All]Campus[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 [EnrollmentSnapshot]trueCoursePrefix[Curriculum].[Course Prefix].[All]CoursePrefix[Curriculum].[Course Prefix]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Prefix].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Prefix].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Prefix].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Prefix].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]trueDeliveryMethod[Curriculum].[Delivery Method].[All]DeliveryMethod[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]trueCurSession[Curriculum].[Session].[All]CurSession[Curriculum].[Session]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Session].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Session].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Session].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Session].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]trueCreditNonCreditVocationalTest[Curriculum].[Credit Non Credit Vocational Test].[All]CreditNonCreditVocationalTest[Curriculum].[Credit Non Credit Vocational Test]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational Test].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]trueCreditType[Curriculum].[Credit Type].[All]CreditType[Curriculum].[Credit Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM [EnrollmentSnapshot]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="[Relative Day].[TermYearTypeRelativeDay].[Term Year]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Relative Day].[TermYearTypeRelativeDay].[Term Type 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="[Relative Day].[TermYearTypeRelativeDay].[Relative Day]" /> 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].[Credit And Clock Hours Combined]" /> 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].[RelativeDaySort]" /> 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].[Headcount]" /> 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].[Credit And Clock Hours Combined - Current -1]" /> 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].[Headcount - Current - 1]" /> 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].[Credit And Clock Hours Combined - Current -2]" /> 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].[Headcount - Current - 2]" /> System.Int32 RSDS_EnterpriseDW SELECT BackgroundAlternateColor AS HeaderBackgroundColor, BackgroundColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'Enrollment') HeaderBackgroundColor System.String BackgroundColor System.String Band1Color System.String Band2Color System.String Band3Color System.String Band4Color System.String Band5Color System.String Band6Color System.String RSDS_EnterpriseDW SELECT CAST(DateSK AS varchar(8)) AS IsCurrentDay_DateSK FROM DimDate WHERE (IsCurrentDay = 'Y') IsCurrentDay_DateSK System.String 1.51042in 0.66667in 0.25in true true Credit Hours Current 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_and_Clock_Hours_Combined.Value) 2pt 2pt 2pt 2pt 0.25in true true Headcount 2pt 2pt 2pt 2pt true true =Sum(Fields!Headcount.Value) 2pt 2pt 2pt 2pt 0.25in true true Credit Hours - Current -1 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_And_Clock_Hours_Combined___Current__1.Value) 2pt 2pt 2pt 2pt 0.25in true true Headcount - Current -1 2pt 2pt 2pt 2pt true true =Sum(Fields!Headcount___Current___1.Value) 2pt 2pt 2pt 2pt 0.25in true true Credit Hours - Current - 2 2pt 2pt 2pt 2pt true true =Sum(Fields!Credit_And_Clock_Hours_Combined___Current__2.Value) 2pt 2pt 2pt 2pt 0.25in true true Headcount - Current - 2 2pt 2pt 2pt 2pt true true =Sum(Fields!Headcount___Current___2.Value) 2pt 2pt 2pt 2pt 0.25in true true =First(Fields!HeaderBackgroundColor.Value, "ConfigurationColor") 2pt 2pt 2pt 2pt =Fields!Relative_Day.Value =Fields!RelativeDaySort.Value 0.25in true true =Fields!Relative_Day.Value Relative_Day =First(Fields!HeaderBackgroundColor.Value, "ConfigurationColor") 2pt 2pt 4pt 2pt Enrollment 1.75in 2.17709in EnrollmentActivityDates =Parameters!DimTerm_Title_MemberUniqueName.Value 2.29042in 0.52208in 3in 1 1.75in