Student Success
 dsProgress (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   StudentSuccessProgress.rdl   Data Sets   dsProgress
  Properties
Property Value
DataSetName dsProgress
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  
{ [Measures].[College Exp. Course], [Measures].[GPA Cum >= 2.0], [Measures].[Did not meet any], [Measures].[Attended Summer], [Measures].[Gateway Course], [Measures].[67% Completed], [Measures].[Continuing], [Measures].[Not Enrolled For2 Terms], [Measures].[24 Credits], [Measures].[Student Success Term Snapshot Count], [Measures].[Graduated], [Measures].[Applied To Graduate] } 
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_FLAGS
  Fields
Field Name Field Type Field Value
Applied_To_Graduate
System.Int32
Attended_Summer
System.Int32
College_Exp__Course
System.Int32
Continuing
System.Int32
Did_not_meet_any
System.Int32
Gateway_Course
System.Int32
GPA_Cum____2_0
System.Int32
Graduated
System.Int32
ID24_Credits
System.Int32
ID67__Completed
System.Int32
Not_Enrolled_For2_Terms
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
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
Student_Id
System.String
Student_Success_Term_Snapshot_Count
System.Int32
  Query Parameters
Parameter Name Parameter Value
CollegeExp
=Parameters!CollegeExp.Value
Completion
=Parameters!Completion.Value
Credits
=Parameters!Credits.Value
Gateway
=Parameters!Gateway.Value
GPA
=Parameters!GPA.Value
StudentSuccessCohortCohortAwardProgram
=Parameters!StudentSuccessCohortCohortAwardProgram.Value
StudentSuccessCohortCohortTermTitle
=Parameters!StudentSuccessCohortCohortTermTitle.Value
StudentSuccessCohortFirstTermFTPT
=Parameters!StudentSuccessCohortFirstTermFTPT.Value
StudentSuccessCohortInitialPrepStatus
=Parameters!StudentSuccessCohortInitialPrepStatus.Value
StudentSuccessCohortProgramAdmitStatus
=Parameters!StudentSuccessCohortProgramAdmitStatus.Value
SummerTerm
=Parameters!SummerTerm.Value
Powered by BI Documenter