0.84375in0.52083in0.6875in0.5625in0.77083in0.57292in0.63542in0.5625in0.69792in0.54167in0.20833intruetrue=Fields!Key_Column.ValueKey_Column1=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pt100.19792intruetrueCohort CountTextbox164=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrue%Textbox367=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrueSwitchedTextbox168=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrue%Textbox370=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrueNot EnrolledTextbox172=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrue%Textbox373=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrueEnrolledTextbox176=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrue%Textbox380=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrueGraduatedTextbox180=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pttruetrue%Textbox377=IIF(Fields!Key_Column.Value = "1 Year Mark", "SkyBlue", "LightSteelBlue")2pt2pt2pt2pt0.17709intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Program_Retention_Snapshot_Count1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALLALLALLNavajoWhite2pt2pt2pt2pttruetrueTextbox368NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Textbox188NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)
/ Sum(Fields!Program_Retention_Snapshot_Count.Value,"Years")Textbox371NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Textbox186NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)
/ Sum(Fields!Program_Retention_Snapshot_Count.Value,"Years")Textbox374NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Textbox184NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)
/ Sum(Fields!Program_Retention_Snapshot_Count.Value,"Years")Textbox381NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Textbox182NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)
/ Sum(Fields!Program_Retention_Snapshot_Count.Value,"Years")Textbox378NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Switched_Programs___Program_Retention1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)=Fields!Gender.ValueALLALLALL2pt2pt2pt2pttruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)
/ Sum(Fields!Program_Retention_Snapshot_Count.Value,"Years")Textbox3692pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Switched_Programs___Program_Retention22pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)
/ Sum(Fields!Switched_Programs___Program_Retention.Value,"Years")Textbox3722pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Not_Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)
/ Sum(Fields!Not_Enrolled___Program_Retention.Value,"Years")Textbox3752pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)
/ Sum(Fields!Enrolled___Program_Retention.Value,"Years")Textbox3822pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Graduated___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)
/ Sum(Fields!Graduated___Program_Retention.Value,"Years")Textbox3792pt2pt2pt2pt=Fields!Key_Column.Value=Fields!Key_Column.Value1.58333intruetrueTextbox85LightGrey2pt2pt2pt2pt1.58333intruetrueDemographicTextbox162LightGrey2pt2pt2pt2pt1.58333intruetrueGenderNavajoWhite2pt2pt2pt2pt=Fields!Gender.Value=Fields!Gender.Value0.28125intruetrueTextbox42pt2pt2pt2pt1.30208intruetrue=Fields!Gender.ValueTextbox52pt2pt2pt2pttruetoggleGPAdsGender0.00521in0.76042in7.97917in0.84375in0.52083in0.6875in0.5625in0.77083in0.57292in0.63542in0.5625in0.69792in0.54167in0.17709intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Program_Retention_Snapshot_Count1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALLALLALLNavajoWhite2pt2pt2pt2pttruetrueTextbox368NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Textbox188NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years2")Textbox371NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Textbox186NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years2")Textbox374NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Textbox184NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years2")Textbox381NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Textbox182NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years2")Textbox378NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Switched_Programs___Program_Retention1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALL=Fields!Ethnicity.ValueALLALL2pt2pt2pt2pttruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years2")Textbox3692pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Switched_Programs___Program_Retention22pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Switched_Programs___Program_Retention.Value, "Years2")Textbox3722pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Not_Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Not_Enrolled___Program_Retention.Value, "Years2")Textbox3752pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Enrolled___Program_Retention.Value, "Years2")Textbox3822pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Graduated___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Graduated___Program_Retention.Value, "Years2")Textbox3792pt2pt2pt2pt=Fields!Key_Column.Value=Fields!Key_Column.Value1.58854intruetrueEthnicityNavajoWhite2pt2pt2pt2pt=Fields!Ethnicity.Value=Fields!Ethnicity.Value0.28125intruetrueTextbox42pt2pt2pt2pt1.30729intruetrue=Fields!Ethnicity.ValueTextbox52pt2pt2pt2pttruetoggleGPA2dsEthnicity0.76667in0.35417in7.98438in10.84375in0.52083in0.6875in0.5625in0.77083in0.57292in0.63542in0.5625in0.69792in0.54167in0.17709intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Program_Retention_Snapshot_Count1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALLALLALLNavajoWhite2pt2pt2pt2pttruetrueTextbox368NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Textbox188NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years3")Textbox371NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Textbox186NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years3")Textbox374NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Textbox184NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years3")Textbox381NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Textbox182NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years3")Textbox378NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Switched_Programs___Program_Retention1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALL=Fields!Initial_Prep_Status.ValueALL2pt2pt2pt2pttruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years3")Textbox3692pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Switched_Programs___Program_Retention22pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Switched_Programs___Program_Retention.Value, "Years3")Textbox3722pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Not_Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Not_Enrolled___Program_Retention.Value, "Years3")Textbox3752pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Enrolled___Program_Retention.Value, "Years3")Textbox3822pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Graduated___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Graduated___Program_Retention.Value, "Years3")Textbox3792pt2pt2pt2pt=Fields!Key_Column.Value=Fields!Key_Column.Value1.58854intruetrueInitial Prep StatusNavajoWhite2pt2pt2pt2pt=Fields!Initial_Prep_Status.Value=Fields!Initial_Prep_Status.Value0.28125intruetrueTextbox42pt2pt2pt2pt1.30729intruetrue=Fields!Initial_Prep_Status.ValueTextbox52pt2pt2pt2pttruetoggleGPA3dsPrep1.12292in0.35417in7.98438in20.84375in0.52083in0.6875in0.5625in0.77083in0.57292in0.63542in0.5625in0.69792in0.54167in0.17709intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Program_Retention_Snapshot_Count1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALLALLALLNavajoWhite2pt2pt2pt2pttruetrueTextbox368NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Textbox188NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years4")Textbox371NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Textbox186NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years4")Textbox374NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Textbox184NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years4")Textbox381NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Textbox182NavajoWhite2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years4")Textbox378NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value)Switched_Programs___Program_Retention1ProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueALL=switch(
Fields!Key_Column.Value = "1 Year Mark", 1,
Fields!Key_Column.Value = "2 Year Mark", 2
)ALLALLALL=Fields!Age_Range_At_Program_Retention_Cohort.Value2pt2pt2pt2pttruetrue=Sum(Fields!Program_Retention_Snapshot_Count.Value) / Sum(Fields!Program_Retention_Snapshot_Count.Value, "Years4")Textbox3692pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value)Switched_Programs___Program_Retention22pt2pt2pt2pttruetrue=Sum(Fields!Switched_Programs___Program_Retention.Value) / Sum(Fields!Switched_Programs___Program_Retention.Value, "Years4")Textbox3722pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value)Not_Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled___Program_Retention.Value) / Sum(Fields!Not_Enrolled___Program_Retention.Value, "Years4")Textbox3752pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value)Enrolled___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Enrolled___Program_Retention.Value) / Sum(Fields!Enrolled___Program_Retention.Value, "Years4")Textbox3822pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value)Graduated___Program_Retention2pt2pt2pt2pttruetrue=Sum(Fields!Graduated___Program_Retention.Value) / Sum(Fields!Graduated___Program_Retention.Value, "Years4")Textbox3792pt2pt2pt2pt=Fields!Key_Column.Value=Fields!Key_Column.Value1.58854intruetrueAge Range at CohortNavajoWhite2pt2pt2pt2pt=Fields!Age_Range_At_Program_Retention_Cohort.Value=Fields!Age_Range_Sort.Value0.28125intruetrueTextbox42pt2pt2pt2pt1.30729intruetrue=Fields!Age_Range_At_Program_Retention_Cohort.ValueTextbox52pt2pt2pt2pttruetoggleGPA4dsAgeRange1.48125in0.35417in7.98438in31.84792in7.98438in1in1in1in1in0RSDS_EnterpriseDW_SSASNone2bb535a2-9253-4024-9232-b3ac76d3ad56RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]truetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]truetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletruetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustruetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtruetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustruetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))ProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudenttruetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Gender].[Gender].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Program Retention Cohort].[Cohort Term Title][Program Retention Cohort].[Cohort Term Title].&[20111]true[Student].[Home Campus][Student].[Home Campus].[All]true[Program Retention Cohort].[Pgm Ret Award Program][Program Retention Cohort].[Pgm Ret Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[International Student][Student].[International Student].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Tracking Years].[Key Column][Tracking Years].[Key Column].&[1][Tracking Years].[Key Column].&[2] SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Gender].[Gender].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudenttrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudentStudentStudentAthletetrue<?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="[Student].[Gender].[Gender]" />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].[Program Retention Snapshot Count]" />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="[Tracking Years].[Key Column].[Key Column]" />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].[Switched Programs - Program Retention]" />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].[Not Enrolled - Program Retention]" />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].[Enrolled - Program Retention]" />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].[Graduated - Program Retention]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Ethnicity].[Ethnicity].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Program Retention Cohort].[Cohort Term Title][Program Retention Cohort].[Cohort Term Title].&[20111]true[Student].[Home Campus][Student].[Home Campus].[All]true[Program Retention Cohort].[Pgm Ret Award Program][Program Retention Cohort].[Pgm Ret Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[International Student][Student].[International Student].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Tracking Years].[Key Column][Tracking Years].[Key Column].&[1][Tracking Years].[Key Column].&[2] SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Ethnicity].[Ethnicity].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudenttrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudentStudentStudentAthletetrue<?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="[Student].[Ethnicity].[Ethnicity]" />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="[Tracking Years].[Key Column].[Key Column]" />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].[Program Retention Snapshot Count]" />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].[Switched Programs - Program Retention]" />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].[Not Enrolled - Program Retention]" />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].[Enrolled - Program Retention]" />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].[Graduated - Program Retention]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Initial Prep Status].[Initial Prep Status].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Program Retention Cohort].[Cohort Term Title][Program Retention Cohort].[Cohort Term Title].&[20111]true[Student].[Home Campus][Student].[Home Campus].[All]true[Program Retention Cohort].[Pgm Ret Award Program][Program Retention Cohort].[Pgm Ret Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[International Student][Student].[International Student].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Tracking Years].[Key Column][Tracking Years].[Key Column].&[1][Tracking Years].[Key Column].&[2] SELECT NON EMPTY { [Measures].[Graduated - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Initial Prep Status].[Initial Prep Status].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudenttrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudentStudentStudentAthletetrue<?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="[Student].[Initial Prep Status].[Initial Prep Status]" />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="[Tracking Years].[Key Column].[Key Column]" />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].[Program Retention Snapshot Count]" />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].[Switched Programs - Program Retention]" />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].[Not Enrolled - Program Retention]" />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].[Enrolled - Program Retention]" />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].[Graduated - Program Retention]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value SELECT NON EMPTY { [Measures].[Switched Programs - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Graduated - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Program Retention Cohort].[Age Range At Program Retention Cohort].[Age Range At Program Retention Cohort].ALLMEMBERS * [Program Retention Cohort].[Age Range Sort].[Age Range Sort].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Program Retention Cohort].[Cohort Term Title][Program Retention Cohort].[Cohort Term Title].&[20111]true[Student].[Home Campus][Student].[Home Campus].[All]true[Program Retention Cohort].[Pgm Ret Award Program][Program Retention Cohort].[Pgm Ret Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[International Student][Student].[International Student].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Tracking Years].[Key Column][Tracking Years].[Key Column].&[1][Tracking Years].[Key Column].&[2] SELECT NON EMPTY { [Measures].[Switched Programs - Program Retention], [Measures].[Not Enrolled - Program Retention], [Measures].[Enrolled - Program Retention], [Measures].[Graduated - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Program Retention Cohort].[Age Range At Program Retention Cohort].[Age Range At Program Retention Cohort].ALLMEMBERS * [Program Retention Cohort].[Age Range Sort].[Age Range Sort].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSProgramRetentionCohortCohortTermTitle[Program Retention Cohort].[Cohort Term Title].&[20111]
Cohort Term Title
[Program Retention Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])ProgramRetentionCohortCohortTermTitletrueProgramRetentionCohortPgmRetAwardProgram[Program Retention Cohort].[Pgm Ret Award Program].[All]
Pgm Ret Award Program
[Program Retention Cohort].[Pgm Ret Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Program Retention Cohort].[Pgm Ret Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))ProgramRetentionCohortCohortTermTitleStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramtrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatustrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudenttrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))ProgramRetentionCohortCohortTermTitleStudentHomeCampusProgramRetentionCohortPgmRetAwardProgramStudentInitialPrepStatusStudentInternationalStudentStudentStudentAthletetrue<?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="[Program Retention Cohort].[Age Range At Program Retention Cohort].[Age Range At Program Retention Cohort]" />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="[Program Retention Cohort].[Age Range Sort].[Age Range Sort]" />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="[Tracking Years].[Key Column].[Key Column]" />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].[Program Retention Snapshot Count]" />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].[Switched Programs - Program Retention]" />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].[Not Enrolled - Program Retention]" />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].[Enrolled - Program Retention]" />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].[Graduated - Program Retention]" />System.Int32String[Program Retention Cohort].[Cohort Term Title].&[20111]Cohort Term TitleProgramRetentionCohortCohortTermTitleParameterValueParameterCaptionIndentedString[Student].[Home Campus].[All]Home CampusStudentHomeCampusParameterValueParameterCaptionIndentedString[Program Retention Cohort].[Pgm Ret Award Program].[All]Pgm Ret Award ProgramProgramRetentionCohortPgmRetAwardProgramParameterValueParameterCaptionIndentedtrueString[Student].[Initial Prep Status].[All]Initial Prep StatusStudentInitialPrepStatusParameterValueParameterCaptionIndentedtrueString[Student].[International Student].[All]International StudentStudentInternationalStudentParameterValueParameterCaptionIndentedString[Student].[Student Athlete].[All]Student AthleteStudentStudentAthleteParameterValueParameterCaptionIndentedString[Student].[Veteran Student].[All]Veteran StudentStudentVeteranStudentParameterValueParameterCaptionIndentedInchbbb959a6-4477-436e-a18a-f7c97576d789