Student Success
 dsDemographics (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   StudentSuccessDemographics.rdl   Data Sets   dsDemographics
  Properties
Property Value
DataSetName dsDemographics
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].[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_FLAGS
  Fields
Field Name Field Type Field Value
Applied_To_Graduate
System.Int32
Attended_Summer
System.Int32
Cohort_Term
System.String
Cohort_Term_Title
System.String
College_Exp__Course
System.Int32
Continuing
System.Int32
Degree_Benchmark_100_Pct
System.Int32
Degree_Benchmark_25_Pct
System.Int32
Degree_Benchmark_50_Pct
System.Int32
Degree_Benchmark_75_Pct
System.Int32
Degree_Benchmark_Less_Than25_Pct
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
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
SOAP_Appeal
System.Int32
SOAP_Clear
System.Int32
SOAP_Dismissal
System.Int32
SOAP_Other
System.Int32
SOAP_Probation
System.Int32
SOAP_Suspension
System.Int32
SOAP_Warning
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