Student Success
 dsGPARanges (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   StudentSuccessGPARanges.rdl   Data Sets   dsGPARanges
  Properties
Property Value
DataSetName dsGPARanges
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].[24 Credits], 
[Measures].[Attended Summer], 
[Measures].[Gateway Course], 
[Measures].[67% Completed], 
[Measures].[Did not meet any], 
[Measures].[GPA None],
[Measures].[GPA 000 199], 
[Measures].[GPA 350 Plus], 
[Measures].[GPA 300 349], 
[Measures].[GPA 250 299], 
[Measures].[GPA 200 249],
[Measures].[Student Success Term Snapshot Count] }
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
Attended_Summer
System.Int32
College_Exp__Course
System.Int32
Did_not_meet_any
System.Int32
Gateway_Course
System.Int32
GPA_000_199
System.Int32
GPA_200_249
System.Int32
GPA_250_299
System.Int32
GPA_300_349
System.Int32
GPA_350_Plus
System.Int32
GPA_Cum____2_0
System.Int32
GPA_None
System.Int32
ID24_Credits
System.Int32
ID67__Completed
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