Student Success
 dsPrep (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   RetentionDemographics.rdl   Data Sets   dsPrep
  Properties
Property Value
DataSetName dsPrep
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX True
Query Command Type MDX
Query Data Source Name RSDS_EnterpriseDW_SSAS
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security
  Query Command Text
 SELECT NON EMPTY { [Measures].[Graduated  Program Retention], [Measures].[Not Enrolled  Program Retention], [Measures].[Enrolled  Program Retention], [Measures].[Switched Programs  Program Retention], [Measures].[Program Retention Snapshot Count] } ON COLUMNS, NON EMPTY { ([Student].[Initial Prep Status].[Initial Prep Status].ALLMEMBERS * [Tracking Years].[Key Column].[Key Column].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Tracking Years].[Key Column].&[1], [Tracking Years].[Key Column].&[2] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))) WHERE ( IIF( STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortCohortTermTitle, CONSTRAINED), [Program Retention Cohort].[Cohort Term Title].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@ProgramRetentionCohortPgmRetAwardProgram, CONSTRAINED), [Program Retention Cohort].[Pgm Ret Award Program].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
  Fields
Field Name Field Type Field Value
Age_Range_At_Program_Retention_Cohort
System.String
Age_Range_Sort
System.String
Enrolled___Program_Retention
System.Int32
Enrolled___Program_Retention
System.Int32
Enrolled___Program_Retention
System.Int32
Enrolled___Program_Retention
System.Int32
Ethnicity
System.String
Gender
System.String
Graduated___Program_Retention
System.Int32
Graduated___Program_Retention
System.Int32
Graduated___Program_Retention
System.Int32
Graduated___Program_Retention
System.Int32
Initial_Prep_Status
System.String
Key_Column
System.String
Key_Column
System.String
Key_Column
System.String
Key_Column
System.String
Not_Enrolled___Program_Retention
System.Int32
Not_Enrolled___Program_Retention
System.Int32
Not_Enrolled___Program_Retention
System.Int32
Not_Enrolled___Program_Retention
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
Program_Retention_Snapshot_Count
System.Int32
Program_Retention_Snapshot_Count
System.Int32
Program_Retention_Snapshot_Count
System.Int32
Program_Retention_Snapshot_Count
System.Int32
Switched_Programs___Program_Retention
System.Int32
Switched_Programs___Program_Retention
System.Int32
Switched_Programs___Program_Retention
System.Int32
Switched_Programs___Program_Retention
System.Int32
  Query Parameters
Parameter Name Parameter Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortCohortTermTitle
=Parameters!ProgramRetentionCohortCohortTermTitle.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
ProgramRetentionCohortPgmRetAwardProgram
=Parameters!ProgramRetentionCohortPgmRetAwardProgram.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentHomeCampus
=Parameters!StudentHomeCampus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentVeteranStudent
=Parameters!StudentVeteranStudent.Value
StudentVeteranStudent
=Parameters!StudentVeteranStudent.Value
StudentVeteranStudent
=Parameters!StudentVeteranStudent.Value
StudentVeteranStudent
=Parameters!StudentVeteranStudent.Value
Powered by BI Documenter