=IIF(Sum(Fields!SOAP_Clear.Value) = 0, "",
Sum(Fields!SOAP_Clear.Value))true="Number of Students with Clear SOAP Status: "
& Sum(Fields!SOAP_Clear.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value1OutputClearShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Warning.Value) = 0, "",
Sum(Fields!SOAP_Warning.Value))true="Number of Students with Warning SOAP Status: "
& Sum(Fields!SOAP_Warning.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value2OutputWarningShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Appeal.Value) = 0, "",
Sum(Fields!SOAP_Appeal.Value))true="Number of Students with Appeal SOAP Status: "
& Sum(Fields!SOAP_Appeal.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value5OutputAppealShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Suspension.Value) = 0, "",
Sum(Fields!SOAP_Suspension.Value))true="Number of Students with Suspension SOAP Status: "
& Sum(Fields!SOAP_Suspension.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value3OutputSuspensionShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Probation.Value) = 0, "",
Sum(Fields!SOAP_Probation.Value))true="Number of Students with Probation SOAP Status: "
& Sum(Fields!SOAP_Probation.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value4OutputProbationShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Dismissal.Value) = 0, "",
Sum(Fields!SOAP_Dismissal.Value))true="Number of Students with Dismissal SOAP Status: "
& Sum(Fields!SOAP_Dismissal.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value6OutputDismissalShapePrimaryPrimaryBlack0pt=IIF(Sum(Fields!SOAP_Other.Value) = 0, "",
Sum(Fields!SOAP_Other.Value))true="Number of Students with Other SOAP Status: "
& Sum(Fields!SOAP_Other.Value)
& " out of "
& Sum(Fields!Student_Success_Term_Snapshot_Count.Value)
& " in the cohort."StudentSuccessTermDetail=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortCohortAwardProgram.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortInitialPrepStatus.Value=Parameters!StudentSuccessCohortFirstTermFTPT.Value=Parameters!Credits.Value=Parameters!GPA.Value=Parameters!CollegeExp.Value=Parameters!Completion.Value=Parameters!Gateway.Value=Parameters!SummerTerm.Value7OutputOtherShapePrimaryPrimaryBlack0pt
Axis Title
False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Axis Title
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaNtrue
BlackBlackPastel
No Data Available
dsSOAP2.61334in3.48834inWhiteNone2.61334in3.48834in1in1in1in1in0RSDS_EnterpriseDW_SSASNonec07d7944-d870-430d-99c0-6ab4b70c8e5aRSDS_EnterpriseDW_SSAS=Parameters!StudentSuccessCohortCohortTermTitle.Value=Parameters!StudentSuccessCohortProgramAdmitStatus.Value=Parameters!StudentSuccessCohortCohortAwardProgram.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].[GPA Cum >= 2.0], [Measures].[24 Credits], [Measures].[SOAP Other], [Measures].[College Exp. Course], [Measures].[Attended Summer], [Measures].[Gateway Course], [Measures].[67% Completed], [Measures].[Did not meet any], [Measures].[SOAP Clear], [Measures].[Student Success Term Snapshot Count], [Measures].[SOAP Dismissal], [Measures].[SOAP Warning], [Measures].[SOAP Probation], [Measures].[SOAP Suspension], [Measures].[SOAP Appeal] }
ON COLUMNS,
NON EMPTY { ([Student Success Cohort].[Student Id].[Student Id].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(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))
WHERE ( IIF( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED), [Student Success Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED), [Student Success Cohort].[Program Admit Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED), [Student Success Cohort].[Cohort Award Program].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].[GPA Cum >= 2.0], [Measures].[24 Credits], [Measures].[SOAP Other], [Measures].[College Exp. Course], [Measures].[Attended Summer], [Measures].[Gateway Course], [Measures].[67% Completed], [Measures].[Did not meet any], [Measures].[SOAP Clear], [Measures].[Student Success Term Snapshot Count], [Measures].[SOAP Dismissal], [Measures].[SOAP Warning], [Measures].[SOAP Probation], [Measures].[SOAP Suspension], [Measures].[SOAP Appeal] }
ON COLUMNS,
NON EMPTY { ([Student Success Cohort].[Student Id].[Student Id].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(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))
WHERE ( IIF( STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortTermTitle, CONSTRAINED), [Student Success Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortProgramAdmitStatus, CONSTRAINED), [Student Success Cohort].[Program Admit Status].currentmember ), IIF( STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentSuccessCohortCohortAwardProgram, CONSTRAINED), [Student Success Cohort].[Cohort Award Program].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]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]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]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="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="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="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].[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 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 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 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].[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].[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].[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].[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].[Attended Summer]" />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=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)
)RSDS_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].[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].[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_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.StringString[Student Success Cohort].[Cohort Term Title].&[20122]Cohort Term TitleStudentSuccessCohortCohortTermTitleParameterValueParameterCaptionIndentedString[Student Success Cohort].[Program Admit Status].[All]Program Admit StatusStudentSuccessCohortProgramAdmitStatusParameterValueParameterCaptionIndentedString[Student Success Cohort].[Cohort Award Program].[All]Cohort Award ProgramStudentSuccessCohortCohortAwardProgramParameterValueParameterCaptionIndentedtrueString[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]"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]"en-UStrueInch299801de-35e3-4702-bc2e-7f62ad99ebc6