2.46875in1.15625in0.21875intruetrueProgramTextbox8CornflowerBlue2pt2pt2pt2pttruetrueSwitchedTextbox3CornflowerBlue2pt2pt2pt2pt0.21875intruetruetrue=Fields!Program_Code.Value & " - " & Fields!Program.ValueProgram_CodeProgramRetentionDetail=Parameters!ProgramRetentionCohortCohortTermTitle.Value=Parameters!StudentHomeCampus.Value=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value(0)=Parameters!StudentInitialPrepStatus.Value(0)=Parameters!StudentInternationalStudent.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Fields!Program_Code.Value2ALLALLALLALL=IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", Nothing)2pt2pt2pt2pttruetruetruetrue=Fields!Switched_Programs___Program_Retention.Value
& " / " & Fields!Program_Retention_Snapshot_Count.Value
& " = " & FormatPercent(Fields!Switched_Percent.Value,2)Switched_Programs___Program_Retention=IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", Nothing)2pt2pt2pt2ptdsSwitched=Fields!Switched_Percent.ValueDescending0.4375in3.625in0.4375in3.625in1in1in1in1in0RSDS_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.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].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Program Retention Cohort].[Program Code].[Program Code].ALLMEMBERS * [Program Retention Cohort].[Program].[Program].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [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 ), [Tracking Years].[Key Column].&[2] ) 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].&[2] SELECT NON EMPTY { [Measures].[Switched Programs - Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Program Retention Cohort].[Program Code].[Program Code].ALLMEMBERS * [Program Retention Cohort].[Program].[Program].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [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 ), [Tracking Years].[Key Column].&[2] ) 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].[Program Code].[Program Code]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Program Retention Cohort].[Program].[Program]" />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].[Program Retention Snapshot Count]" />System.Int32=Fields!Switched_Programs___Program_Retention.Value
/ Fields!Program_Retention_Snapshot_Count.Value=Fields!Program_Retention_Snapshot_Count.ValueGreaterThanOrEqual10=Fields!Switched_Percent.ValueTopN10RSDS_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.StringString[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