0.53125in0.73958in0.5in0.48958in1.89584in0.75in0.67709in0.65625in0.74999in1.48958in0.21875intruetrueCountTextbox402pt2pt2pt2pttruetrueStudent IdTextbox22pt2pt2pt2pttruetrueAwardTextbox42pt2pt2pt2pttruetrueProgramTextbox62pt2pt2pt2pt2truetrueEarned HrsTextbox12pt2pt2pt2pttruetrueCum GPATextbox142pt2pt2pt2pttruetrueSOAPTextbox82pt2pt2pt2pttruetrueBenchmarkTextbox72pt2pt2pt2pttruetrueProgressTextbox102pt2pt2pt2pt0.21875intruetrue=RowNumber("dsStudentSuccessTerm")Textbox412pt2pt2pt2pttruetrue=Fields!Student_Id.ValueStudent_Id2pt2pt2pt2pttruetrue=Fields!Award_Type_Code.ValueAward_Type_Code2pt2pt2pt2pttruetrue=Fields!Program_Code.ValueProgram_Code2pt2pt2pt2pttruetrue=Fields!Program.ValueProgram2pt2pt2pt2pttruetrue=Fields!Cum_Hours_Earned.ValueCum_Hours_Earned2pt2pt2pt2pttruetrue=Fields!Cum_GPA.ValueCum_GPA2pt2pt2pt2pttruetrue=switch(
Fields!SOAP_Clear.Value = 1, "Clear",
Fields!SOAP_Warning.Value = 1, "Warning",
Fields!SOAP_Suspension.Value = 1, "Suspension",
Fields!SOAP_Appeal.Value = 1, "Appeal",
Fields!SOAP_Probation.Value = 1, "Probation",
Fields!SOAP_Dismissal.Value = 1, "Dismissal",
Fields!SOAP_Other.Value = 1, "Other"
)Textbox32pt2pt2pt2pttruetrue=switch(
Fields!Degree_Benchmark_Less_Than25_Pct.Value = 1, "< 25%",
Fields!Degree_Benchmark_25_Pct.Value = 1, "25%",
Fields!Degree_Benchmark_50_Pct.Value = 1, "50%",
Fields!Degree_Benchmark_75_Pct.Value = 1, "75%",
Fields!Degree_Benchmark_100_Pct.Value = 1, "100%"
)Textbox52pt2pt2pt2pttruetrue=switch(
Fields!Graduated.Value = 1, "Graduated",
Fields!Applied_To_Graduate.Value = 1, "Applied to Graduate",
Fields!Continuing.Value = 1, "Continuing",
Fields!Not_Enrolled_For2_Terms.Value = 1, "Not Enrolled For 2+ Terms"
)Textbox112pt2pt2pt2ptAftertruedsStudentSuccessTerm0.4375in8.47916in0.4375in8.47916in1in1in1in1in0RSDS_EnterpriseDW_SSASNone0ee13c5f-eaef-402e-8cff-cf6ce299f533RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success 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!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Valuetrue=Parameters!GPA.Valuetrue=Parameters!CollegeExp.Valuetrue=Parameters!Completion.Valuetrue=Parameters!Gateway.Valuetrue=Parameters!SummerTerm.Valuetrue SELECT NON EMPTY { [Measures].[Degree Benchmark 50 Pct], [Measures].[Degree Benchmark 25 Pct], [Measures].[Degree Benchmark 100 Pct], [Measures].[Degree Benchmark 75 Pct], [Measures].[Degree Benchmark Less Than25 Pct], [Measures].[SOAP Probation], [Measures].[Attended Summer], [Measures].[SOAP Other], [Measures].[SOAP Dismissal], [Measures].[College Exp. Course], [Measures].[24 Credits], [Measures].[Gateway Course], [Measures].[67% Completed], [Measures].[GPA Cum >= 2.0], [Measures].[Applied To Graduate], [Measures].[Graduated], [Measures].[Not Enrolled For2 Terms], [Measures].[Continuing], [Measures].[Cum GPA], [Measures].[GPA None], [Measures].[GPA 000 199], [Measures].[SOAP Appeal], [Measures].[Cum Hours Attempted], [Measures].[Cum Hours Earned], [Measures].[GPA 200 249], [Measures].[SOAP Clear], [Measures].[SOAP Warning], [Measures].[SOAP Suspension], [Measures].[GPA 250 299], [Measures].[GPA 300 349], [Measures].[GPA 350 Plus] } ON COLUMNS, NON EMPTY { ([Student Success Cohort].[Student Id].[Student Id].ALLMEMBERS * [Student Success Cohort].[Cohort Term].[Cohort Term].ALLMEMBERS * [Student Success Cohort].[Cohort Term Title].[Cohort Term Title].ALLMEMBERS * [Student Success Cohort].[Award Type Code].[Award Type Code].ALLMEMBERS * [Student Success Cohort].[Program Code].[Program Code].ALLMEMBERS * [Student Success Cohort].[Program].[Program].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Yes No Bucket].[Key Column].&[1] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))) WHERE ( IIF( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED), [Student Success Cohort].[Cohort Award Program].currentmember ), IIF( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED), [Student Success Cohort].[Program Admit Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED), [Student Success Cohort].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED), [Student Success Cohort].[First Term FT PT].currentmember ), [Yes No Bucket].[Key Column].&[1] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Student Success Cohort].[Cohort Term Title][Student Success Cohort].[Cohort Term Title].&[20122]true[Student Success Cohort].[Cohort Award Program][Student Success Cohort].[Cohort Award Program].[All]true[Student Success Cohort].[Program Admit Status][Student Success Cohort].[Program Admit Status].[All]true[Student Success Cohort].[Initial Prep Status][Student Success Cohort].[Initial Prep Status].[All]true[Student Success Cohort].[First Term FT PT][Student Success Cohort].[First Term FT PT].[All]true[Yes No Bucket].[Key Column][Yes No Bucket].[Key Column].&[1] SELECT NON EMPTY { [Measures].[Degree Benchmark 50 Pct], [Measures].[Degree Benchmark 25 Pct], [Measures].[Degree Benchmark 100 Pct], [Measures].[Degree Benchmark 75 Pct], [Measures].[Degree Benchmark Less Than25 Pct], [Measures].[SOAP Probation], [Measures].[Attended Summer], [Measures].[SOAP Other], [Measures].[SOAP Dismissal], [Measures].[College Exp. Course], [Measures].[24 Credits], [Measures].[Gateway Course], [Measures].[67% Completed], [Measures].[GPA Cum >= 2.0], [Measures].[Applied To Graduate], [Measures].[Graduated], [Measures].[Not Enrolled For2 Terms], [Measures].[Continuing], [Measures].[Cum GPA], [Measures].[GPA None], [Measures].[GPA 000 199], [Measures].[SOAP Appeal], [Measures].[Cum Hours Attempted], [Measures].[Cum Hours Earned], [Measures].[GPA 200 249], [Measures].[SOAP Clear], [Measures].[SOAP Warning], [Measures].[SOAP Suspension], [Measures].[GPA 250 299], [Measures].[GPA 300 349], [Measures].[GPA 350 Plus] } ON COLUMNS, NON EMPTY { ([Student Success Cohort].[Student Id].[Student Id].ALLMEMBERS * [Student Success Cohort].[Cohort Term].[Cohort Term].ALLMEMBERS * [Student Success Cohort].[Cohort Term Title].[Cohort Term Title].ALLMEMBERS * [Student Success Cohort].[Award Type Code].[Award Type Code].ALLMEMBERS * [Student Success Cohort].[Program Code].[Program Code].ALLMEMBERS * [Student Success Cohort].[Program].[Program].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Yes No Bucket].[Key Column].&[1] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))) WHERE ( IIF( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED), [Student Success Cohort].[Cohort Award Program].currentmember ), IIF( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED), [Student Success Cohort].[Program Admit Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED), [Student Success Cohort].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortFirstTermFTPT, CONSTRAINED), [Student Success Cohort].[First Term FT PT].currentmember ), [Yes No Bucket].[Key Column].&[1] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSStudentSuccessCohortCohortTermTitle[Student Success Cohort].[Cohort Term Title].&[20122]
Cohort Term Title
[Student Success Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentSuccessCohortCohortAwardProgram[Student Success Cohort].[Cohort Award Program].[All]
Cohort Award Program
[Student Success Cohort].[Cohort Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])StudentSuccessCohortCohortTermTitletrueStudentSuccessCohortProgramAdmitStatus[Student Success Cohort].[Program Admit Status].[All]
Program Admit Status
[Student Success Cohort].[Program Admit Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramtrueStudentSuccessCohortInitialPrepStatus[Student Success Cohort].[Initial Prep Status].[All]
Initial Prep Status
[Student Success Cohort].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramStudentSuccessCohortProgramAdmitStatustrueStudentSuccessCohortFirstTermFTPT[Student Success Cohort].[First Term FT PT].[All]
First Term FT PT
[Student Success Cohort].[First Term FT PT]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[First Term FT PT].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[First Term FT PT].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramStudentSuccessCohortProgramAdmitStatusStudentSuccessCohortInitialPrepStatustrue<?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 Success Cohort].[Student Id].[Student Id]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student Success Cohort].[Cohort Term].[Cohort Term]" />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="[Student Success Cohort].[Cohort Term Title].[Cohort Term Title]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student Success Cohort].[Award Type Code].[Award Type Code]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student Success 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="[Student Success 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].[Cum Hours Attempted]" />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].[Cum Hours Earned]" />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].[Cum GPA]" />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].[GPA 000 199]" />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].[GPA None]" />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].[GPA 200 249]" />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].[GPA 250 299]" />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].[GPA 300 349]" />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].[GPA 350 Plus]" />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].[SOAP Clear]" />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].[SOAP Warning]" />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].[SOAP Suspension]" />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].[SOAP Appeal]" />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].[SOAP Probation]" />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].[SOAP Dismissal]" />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].[SOAP Other]" />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].[Degree Benchmark Less Than25 Pct]" />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].[Degree Benchmark 25 Pct]" />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].[Degree Benchmark 50 Pct]" />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].[Degree Benchmark 75 Pct]" />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].[Degree Benchmark 100 Pct]" />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]" />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].[Applied To Graduate]" />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].[Continuing]" />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 For2 Terms]" />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].[24 Credits]" />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].[GPA Cum >= 2.0]" />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].[College Exp. Course]" />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].[67% Completed]" />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].[Gateway Course]" />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].[Attended Summer]" />System.Int32=iif(Parameters!Credits.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!ID24_Credits.Value), 999, Fields!ID24_Credits.Value)
)Equal=iif(Parameters!Credits.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!Credits.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=iif(Parameters!GPA.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!GPA_Cum____2_0.Value), 999, Fields!GPA_Cum____2_0.Value)
)Equal=iif(Parameters!GPA.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!GPA.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=iif(Parameters!CollegeExp.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!College_Exp__Course.Value), 999, Fields!College_Exp__Course.Value)
)Equal=iif(Parameters!CollegeExp.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!CollegeExp.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=iif(Parameters!Completion.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!ID67__Completed.Value), 999, Fields!ID67__Completed.Value)
)Equal=iif(Parameters!Completion.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!Completion.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=iif(Parameters!Gateway.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!Gateway_Course.Value), 999, Fields!Gateway_Course.Value)
)Equal=iif(Parameters!Gateway.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!Gateway.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=iif(Parameters!SummerTerm.Value = "[Yes No Bucket].[Key Column].[All]", 0,
iif(IsNothing(Fields!Attended_Summer.Value), 999, Fields!Attended_Summer.Value)
)Equal=iif(Parameters!SummerTerm.Value = "[Yes No Bucket].[Key Column].[All]",
0,
iif(Parameters!SummerTerm.Value = "[Yes No Bucket].[Key Column].&[1]", 1, 0)
)=switch(
Parameters!GPA_Parm.Value = 0, 99,
Parameters!GPA_Parm.Value = 1, Fields!GPA_000_199.Value,
Parameters!GPA_Parm.Value = 2, Fields!GPA_200_249.Value,
Parameters!GPA_Parm.Value = 3, Fields!GPA_250_299.Value,
Parameters!GPA_Parm.Value = 4, Fields!GPA_300_349.Value,
Parameters!GPA_Parm.Value = 5, Fields!GPA_350_Plus.Value,
Parameters!GPA_Parm.Value = 9, Fields!GPA_None.Value
)Equal=iif(Parameters!GPA_Parm.Value = 0, 99, 1)=switch(
Parameters!SOAP_Parm.Value = 0, 99,
Parameters!SOAP_Parm.Value = 1, Fields!SOAP_Clear.Value,
Parameters!SOAP_Parm.Value = 2, Fields!SOAP_Warning.Value,
Parameters!SOAP_Parm.Value = 3, Fields!SOAP_Suspension.Value,
Parameters!SOAP_Parm.Value = 4, Fields!SOAP_Probation.Value,
Parameters!SOAP_Parm.Value = 5, Fields!SOAP_Appeal.Value,
Parameters!SOAP_Parm.Value = 6, Fields!SOAP_Dismissal.Value,
Parameters!SOAP_Parm.Value = 7, Fields!SOAP_Other.Value
)Equal=iif(Parameters!SOAP_Parm.Value = 0, 99, 1)=switch(
Parameters!Benchmarks_Parm.Value = 0, 99,
Parameters!Benchmarks_Parm.Value = 1, Fields!Degree_Benchmark_Less_Than25_Pct.Value,
Parameters!Benchmarks_Parm.Value = 2, Fields!Degree_Benchmark_25_Pct.Value,
Parameters!Benchmarks_Parm.Value = 3, Fields!Degree_Benchmark_50_Pct.Value,
Parameters!Benchmarks_Parm.Value = 4, Fields!Degree_Benchmark_75_Pct.Value,
Parameters!Benchmarks_Parm.Value = 5, Fields!Degree_Benchmark_100_Pct.Value
)Equal=iif(Parameters!Benchmarks_Parm.Value = 0, 99, 1)=switch(
Parameters!DegreeProgress_Parm.Value = 0, 99,
Parameters!DegreeProgress_Parm.Value = 1, Fields!Graduated.Value,
Parameters!DegreeProgress_Parm.Value = 2, Fields!Applied_To_Graduate.Value,
Parameters!DegreeProgress_Parm.Value = 3, Fields!Continuing.Value,
Parameters!DegreeProgress_Parm.Value = 4, Fields!Not_Enrolled_For2_Terms.Value
)Equal=iif(Parameters!DegreeProgress_Parm.Value = 0, 99, 1)RSDS_EnterpriseDW_SSAS=Parameters!StudentSuccessCohortCohortTermTitle.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])StudentSuccessCohortCohortTermTitle[Student Success Cohort].[Cohort Term Title].&[20122]
Cohort Term Title
[Student Success Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success 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!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))StudentSuccessCohortCohortTermTitle[Student Success Cohort].[Cohort Term Title].&[20122]
Cohort Term Title
[Student Success Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentSuccessCohortCohortAwardProgram[Student Success Cohort].[Cohort Award Program].[All]
Cohort Award Program
[Student Success Cohort].[Cohort Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])StudentSuccessCohortCohortTermTitletruetruetrue<?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!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))StudentSuccessCohortCohortTermTitle[Student Success Cohort].[Cohort Term Title].&[20122]
Cohort Term Title
[Student Success Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentSuccessCohortCohortAwardProgram[Student Success Cohort].[Cohort Award Program].[All]
Cohort Award Program
[Student Success Cohort].[Cohort Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])StudentSuccessCohortCohortTermTitletrueStudentSuccessCohortProgramAdmitStatus[Student Success Cohort].[Program Admit Status].[All]
Program Admit Status
[Student Success Cohort].[Program Admit Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramtruetruetrue<?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!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[First Term FT PT].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[First Term FT PT].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[First Term FT PT].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))StudentSuccessCohortCohortTermTitle[Student Success Cohort].[Cohort Term Title].&[20122]
Cohort Term Title
[Student Success Cohort].[Cohort Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentSuccessCohortCohortAwardProgram[Student Success Cohort].[Cohort Award Program].[All]
Cohort Award Program
[Student Success Cohort].[Cohort Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Cohort Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])StudentSuccessCohortCohortTermTitletrueStudentSuccessCohortProgramAdmitStatus[Student Success Cohort].[Program Admit Status].[All]
Program Admit Status
[Student Success Cohort].[Program Admit Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Program Admit Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Program Admit Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramtrueStudentSuccessCohortInitialPrepStatus[Student Success Cohort].[Initial Prep Status].[All]
Initial Prep Status
[Student Success Cohort].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Success Cohort].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Success Cohort].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))StudentSuccessCohortCohortTermTitleStudentSuccessCohortCohortAwardProgramStudentSuccessCohortProgramAdmitStatustruetruetrue<?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[Student Success Cohort].[Cohort Term Title].&[20122]Cohort Term TitleStudentSuccessCohortCohortTermTitleParameterValueParameterCaptionIndentedString[Student Success Cohort].[Cohort Award Program].[All]Cohort Award ProgramStudentSuccessCohortCohortAwardProgramParameterValueParameterCaptionIndentedtrueString[Student Success Cohort].[Program Admit Status].[All]Program Admit StatusStudentSuccessCohortProgramAdmitStatusParameterValueParameterCaptionIndentedString[Student Success Cohort].[Initial Prep Status].[All]Initial Prep StatusStudentSuccessCohortInitialPrepStatusParameterValueParameterCaptionIndentedtrueString[Student Success Cohort].[First Term FT PT].[All]First Term FT PTStudentSuccessCohortFirstTermFTPTParameterValueParameterCaptionIndentedString="[Yes No Bucket].[Key Column].[All]"Credits="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String="[Yes No Bucket].[Key Column].[All]"GPA="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String="[Yes No Bucket].[Key Column].[All]"CollegeExp="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String="[Yes No Bucket].[Key Column].[All]"Completion="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String="[Yes No Bucket].[Key Column].[All]"Gateway="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String="[Yes No Bucket].[Key Column].[All]"SummerTerm="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String0GPA_Parm0123459String0SOAP_Parm01234567String0Benchmarks_Parm012345String0DegreeProgress_Parm01234Inchc6a11bdc-b04a-4a06-99b2-4f6dd4fe7326