0.5625in0.56248in0.20833intruetrue=Fields!Cohort_Term_Title.ValueTextbox87LightGrey2pt2pt2pt2pt20.17709intruetrue=Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Student_Success_Term_Snapshot_CountNavajoWhite2pt2pt2pt2pttruetrueTextbox63NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!GPA_None.Value)GPA_None2pt2pt2pt2pttruetrue=Sum(Fields!GPA_None.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox132pt2pt2pt2pt0.17708intruetrue=Sum(Fields!GPA_000_199.Value)Textbox32pt2pt2pt2pttruetrue=Sum(Fields!GPA_000_199.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox42pt2pt2pt2pt0.17708intruetrue=Sum(Fields!GPA_200_249.Value)GPA_200_2492pt2pt2pt2pttruetrue=Sum(Fields!GPA_200_249.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox92pt2pt2pt2pt0.1875intruetrue=Sum(Fields!GPA_250_299.Value)GPA_250_2992pt2pt2pt2pttruetrue=Sum(Fields!GPA_250_299.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox132pt2pt2pt2pt0.1875intruetrue=Sum(Fields!GPA_300_349.Value)GPA_300_3492pt2pt2pt2pttruetrue=Sum(Fields!GPA_300_349.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox212pt2pt2pt2pt0.1875intruetrue=Sum(Fields!GPA_350_Plus.Value)GPA_350_Plus2pt2pt2pt2pttruetrue=Sum(Fields!GPA_350_Plus.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox172pt2pt2pt2pt=Fields!Cohort_Term.Value=Fields!Cohort_Term.ValueDescending2.22917intruetrueSuccess Factors By CohortTextbox85LightGrey2pt2pt2pt2pt2.22917intruetrueCumulative GPANavajoWhite2pt2pt2pt2pt0.28125intruetrueTextbox42pt2pt2pt2pt1.94792intruetrueNo GPATextbox52pt2pt2pt2pttruetoggleGPA0.28125intruetrueTextbox12pt2pt2pt2pt1.94792intruetrue0 - 1.99Textbox22pt2pt2pt2pttruetoggleGPA0.28125intruetrueTextbox62pt2pt2pt2pt1.94792intruetrue2.00 - 2.49Textbox72pt2pt2pt2pttruetoggleGPA0.28125intruetrueTextbox102pt2pt2pt2pt1.94792intruetrue2.50 - 2.99Textbox112pt2pt2pt2pttruetoggleGPA0.28125intruetrueTextbox182pt2pt2pt2pt1.94792intruetrue3.00 - 3.49Textbox192pt2pt2pt2pttruetoggleGPA0.28125intruetrueTextbox142pt2pt2pt2pt1.94792intruetrue3.50 +Textbox152pt2pt2pt2pttruetoggleGPAdsDemographics0.0057in0.00002in1.47916in3.35415in0.56252in0.56248in0.17709intruetrue=Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Student_Success_Term_Snapshot_Count2NavajoWhite2pt2pt2pt2pttruetrueTextbox194NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Graduated.Value)Textbox32pt2pt2pt2pttruetrue=Sum(Fields!Graduated.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox42pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Applied_To_Graduate.Value)GPA_200_2492pt2pt2pt2pttruetrue=Sum(Fields!Applied_To_Graduate.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox92pt2pt2pt2pt0.1875intruetrue=Sum(Fields!Continuing.Value)GPA_250_2992pt2pt2pt2pttruetrue=Sum(Fields!Continuing.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox132pt2pt2pt2pt0.1875intruetrue=Sum(Fields!Not_Enrolled_For2_Terms.Value)GPA_300_3492pt2pt2pt2pttruetrue=Sum(Fields!Not_Enrolled_For2_Terms.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox212pt2pt2pt2pt=Fields!Cohort_Term.Value=Fields!Cohort_Term.ValueDescending2.22917intruetrueDegree ProgressNavajoWhite2pt2pt2pt2pt0.28125intruetrueTextbox12pt2pt2pt2pt1.94792intruetrueGraduatedTextbox22pt2pt2pt2pttruetoggleProgress0.28125intruetrueTextbox62pt2pt2pt2pt1.94792intruetrueApplied to GraduateTextbox72pt2pt2pt2pttruetoggleProgress0.28125intruetrueTextbox102pt2pt2pt2pt1.94792intruetrueContinuingTextbox112pt2pt2pt2pttruetoggleProgress0.28125intruetrueTextbox182pt2pt2pt2pt1.94792intruetrueNot Enrolled For 2 or More TermsTextbox192pt2pt2pt2pttruetoggleProgressdsDemographics4.09697in0.90625in3.35417in10.56252in0.56248in0.17709intruetrue=Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Student_Success_Term_Snapshot_Count3NavajoWhite2pt2pt2pt2pttruetrueTextbox232NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Degree_Benchmark_Less_Than25_Pct.Value)Textbox32pt2pt2pt2pttruetrue=Sum(Fields!Degree_Benchmark_Less_Than25_Pct.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox42pt2pt2pt2pt0.17708intruetrue=Sum(Fields!Degree_Benchmark_25_Pct.Value)GPA_200_2492pt2pt2pt2pttruetrue=Sum(Fields!Degree_Benchmark_25_Pct.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox92pt2pt2pt2pt0.1875intruetrue=Sum(Fields!Degree_Benchmark_50_Pct.Value)GPA_250_2992pt2pt2pt2pttruetrue=Sum(Fields!Degree_Benchmark_50_Pct.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox132pt2pt2pt2pt0.1875intruetrue=Sum(Fields!Degree_Benchmark_75_Pct.Value)GPA_300_3492pt2pt2pt2pttruetrue=Sum(Fields!Degree_Benchmark_75_Pct.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox212pt2pt2pt2pt0.1875intruetrue=Sum(Fields!Degree_Benchmark_100_Pct.Value)Degree_Benchmark_100_Pct2pt2pt2pt2pttruetrue=Sum(Fields!Degree_Benchmark_100_Pct.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox752pt2pt2pt2pt=Fields!Cohort_Term.Value=Fields!Cohort_Term.ValueDescending2.22917intruetrueDegree BenchmarksNavajoWhite2pt2pt2pt2pt0.28125intruetrueTextbox12pt2pt2pt2pt1.94792intruetrueCompleted < 25%Textbox22pt2pt2pt2pttruetoggleBenchmarks0.28125intruetrueTextbox62pt2pt2pt2pt1.94792intruetrueCompleted 25%Textbox72pt2pt2pt2pttruetoggleBenchmarks0.28125intruetrueTextbox102pt2pt2pt2pt1.94792intruetrueCompleted 50%Textbox112pt2pt2pt2pttruetoggleBenchmarks0.28125intruetrueTextbox182pt2pt2pt2pt1.94792intruetrueCompleted 75%Textbox192pt2pt2pt2pttruetoggleBenchmarks0.28125intruetrueTextbox722pt2pt2pt2pt1.94792intruetrueCompleted 100%Textbox732pt2pt2pt2pttruetoggleBenchmarksdsDemographics2.99903in1.09375in3.35417in20.56252in0.56248in0.17709intruetrue=Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox189NavajoWhite2pt2pt2pt2pttruetrueTextbox281NavajoWhite2pt2pt2pt2pt0.17708intruetrue=Sum(Fields!SOAP_Clear.Value)Textbox32pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Clear.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox42pt2pt2pt2pt0.17708intruetrue=Sum(Fields!SOAP_Warning.Value)GPA_200_2492pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Warning.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox92pt2pt2pt2pt0.1875intruetrue=Sum(Fields!SOAP_Appeal.Value)GPA_250_2992pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Appeal.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox132pt2pt2pt2pt0.1875intruetrue=Sum(Fields!SOAP_Suspension.Value)GPA_300_3492pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Suspension.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox212pt2pt2pt2pt0.1875intruetrue=Sum(Fields!SOAP_Probation.Value)Degree_Benchmark_100_Pct2pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Probation.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox752pt2pt2pt2pt0.20833intruetrue=Sum(Fields!SOAP_Dismissal.Value)SOAP_Dismissal2pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Dismissal.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox1042pt2pt2pt2pt0.20833intruetrue=Sum(Fields!SOAP_Other.Value)SOAP_Other2pt2pt2pt2pttruetrue=Sum(Fields!SOAP_Other.Value) / Sum(Fields!Student_Success_Term_Snapshot_Count.Value)Textbox1082pt2pt2pt2pt=Fields!Cohort_Term.Value=Fields!Cohort_Term.ValueDescending2.22917intruetrueStandard Of Academic ProgressNavajoWhite2pt2pt2pt2pt0.28125intruetrueTextbox12pt2pt2pt2pt1.94792intruetrueClearTextbox22pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox62pt2pt2pt2pt1.94792intruetrueWarningTextbox72pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox102pt2pt2pt2pt1.94792intruetrueAppealTextbox112pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox182pt2pt2pt2pt1.94792intruetrueSuspensionTextbox192pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox722pt2pt2pt2pt1.94792intruetrueProbationTextbox732pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox1012pt2pt2pt2pt1.94792intruetrueDismissalTextbox1022pt2pt2pt2pttruetoggleSOAP0.28125intruetrueTextbox1052pt2pt2pt2pt1.94792intruetrueOtherTextbox1062pt2pt2pt2pttruetoggleSOAPdsDemographics1.48862in1.51041in3.35417in35.00322in3.35417in1in1in1in1in0RSDS_EnterpriseDW_SSASNone2bb535a2-9253-4024-9232-b3ac76d3ad56RSDS_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_SSASWITH 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 [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 [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_SSASWITH 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 [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 [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_SSASWITH 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 [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 [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_SSASWITH 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 [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 [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
{
[Measures].[Student Success Term Snapshot Count],
[Measures].[24 Credits], [Measures].[GPA Cum >= 2.0], [Measures].[College Exp. Course], [Measures].[67% Completed], [Measures].[Gateway Course], [Measures].[Attended Summer], [Measures].[Did not meet any],
[Measures].[GPA None], [Measures].[GPA 000 199], [Measures].[GPA 200 249], [Measures].[GPA 250 299], [Measures].[GPA 300 349], [Measures].[GPA 350 Plus],
[Measures].[SOAP Other], [Measures].[SOAP Probation], [Measures].[SOAP Suspension], [Measures].[SOAP Dismissal], [Measures].[SOAP Appeal], [Measures].[SOAP Clear], [Measures].[SOAP Warning],
[Measures].[Degree Benchmark 100 Pct], [Measures].[Degree Benchmark 25 Pct], [Measures].[Degree Benchmark 50 Pct], [Measures].[Degree Benchmark 75 Pct], [Measures].[Degree Benchmark Less Than25 Pct],
[Measures].[Graduated], [Measures].[Applied To Graduate], [Measures].[Continuing], [Measures].[Not Enrolled For2 Terms]
}
ON COLUMNS,
/* Get same term for parameter term and prior years. e.g. only get spring or fall terms depending on parameter */
NON EMPTY { (
[Student Success Cohort].[Student Id].[Student Id].ALLMEMBERS *
{
ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 0, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 2, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 4, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 6, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 8, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
} *
[Student Success Cohort].[Cohort Term].[Cohort Term].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 ( LastPeriods(10,STRTOMEMBER(@StudentSuccessCohortCohortTermTitle)) ) 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_FLAGSMDXQueryStudentSuccess SELECT
{
[Measures].[Student Success Term Snapshot Count],
[Measures].[24 Credits], [Measures].[GPA Cum >= 2.0], [Measures].[College Exp. Course], [Measures].[67% Completed], [Measures].[Gateway Course], [Measures].[Attended Summer], [Measures].[Did not meet any],
[Measures].[GPA None], [Measures].[GPA 000 199], [Measures].[GPA 200 249], [Measures].[GPA 250 299], [Measures].[GPA 300 349], [Measures].[GPA 350 Plus],
[Measures].[SOAP Other], [Measures].[SOAP Probation], [Measures].[SOAP Suspension], [Measures].[SOAP Dismissal], [Measures].[SOAP Appeal], [Measures].[SOAP Clear], [Measures].[SOAP Warning],
[Measures].[Degree Benchmark 100 Pct], [Measures].[Degree Benchmark 25 Pct], [Measures].[Degree Benchmark 50 Pct], [Measures].[Degree Benchmark 75 Pct], [Measures].[Degree Benchmark Less Than25 Pct],
[Measures].[Graduated], [Measures].[Applied To Graduate], [Measures].[Continuing], [Measures].[Not Enrolled For2 Terms]
}
ON COLUMNS,
/* Get same term for parameter term and prior years. e.g. only get spring or fall terms depending on parameter */
NON EMPTY { (
[Student Success Cohort].[Student Id].[Student Id].ALLMEMBERS *
{
ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 0, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 2, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 4, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 6, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
,ParallelPeriod ([Student Success Cohort].[Cohort Term Title].[Cohort Term Title], 8, STRTOMEMBER(@StudentSuccessCohortCohortTermTitle))
} *
[Student Success Cohort].[Cohort Term].[Cohort Term].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 ( LastPeriods(10,STRTOMEMBER(@StudentSuccessCohortCohortTermTitle)) ) 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].&[20132]
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 [StudentSuccess]trueStudentSuccessCohortProgramAdmitStatus[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 [StudentSuccess]trueStudentSuccessCohortInitialPrepStatus[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 [StudentSuccess]trueStudentSuccessCohortFirstTermFTPT[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 [StudentSuccess]true<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[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 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="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="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="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 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].[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].[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].[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].[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].[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].[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].[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 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 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].[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 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 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].[Student Success Term Snapshot Count]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[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].[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].[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].[Did not meet any]" />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)
)String[Student Success Cohort].[Cohort Term Title].&[20132]Cohort Term TitleStudentSuccessCohortCohortTermTitleParameterValueParameterCaptionIndentedString="[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]"College Experience="[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 Rate="[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 Course="[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]"Attended Summer="[Yes No Bucket].[Key Column].[All]"="[Yes No Bucket].[Key Column].&[0]"="[Yes No Bucket].[Key Column].&[1]"String[Student Success Cohort].[Cohort Award Program].[All]Cohort Award ProgramStudentSuccessCohortCohortAwardProgramParameterValueParameterCaptionIndentedtrueString[Student Success Cohort].[Program Admit Status].[All]Program Admit StatusStudentSuccessCohortProgramAdmitStatusParameterValueParameterCaptionIndentedtrueString[Student Success Cohort].[Initial Prep Status].[All]Initial Prep StatusStudentSuccessCohortInitialPrepStatusParameterValueParameterCaptionIndentedtrueString[Student Success Cohort].[First Term FT PT].[All]First Term FT PTStudentSuccessCohortFirstTermFTPTParameterValueParameterCaptionIndentedtrueInchbbb959a6-4477-436e-a18a-f7c97576d789