Student Success
 dsSwitched (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   RetentionSwitchedProgramsReport.rdl   Data Sets   dsSwitched
  Properties
Property Value
DataSetName dsSwitched
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].[Program Retention Snapshot Count], [Measures].[Switched Programs  Program Retention] } ON COLUMNS, NON EMPTY { ([Program Retention Cohort].[Award Type].[Award Type].ALLMEMBERS * [Program Retention Cohort].[Program Code].[Program Code].ALLMEMBERS * [Program Retention Cohort].[Program].[Program].ALLMEMBERS * [Program Retention Cohort].[Switched Program Code].[Switched Program Code].ALLMEMBERS * [Program Retention Cohort].[Switched Program].[Switched Program].ALLMEMBERS * [Program Retention Cohort].[Switched Award Type Code].[Switched Award Type Code].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], [Tracking Years].[Key Column].&[3], [Tracking Years].[Key Column].&[0] } ) 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(@StudentEthnicity, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentGender, 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(@StudentGender, CONSTRAINED).Count = 1, STRTOSET(@StudentGender, CONSTRAINED), [Student].[Gender].currentmember ), IIF( STRTOSET(@StudentEthnicity, CONSTRAINED).Count = 1, STRTOSET(@StudentEthnicity, CONSTRAINED), [Student].[Ethnicity].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
Award_Type
System.String
BackgroundAlternateColor
System.String
BackgroundColor
System.String
Band1Color
System.String
Band2Color
System.String
Band3Color
System.String
Band4Color
System.String
Band5Color
System.String
Band6Color
System.String
ImageLocation
System.String
ImageType
System.String
Key_Column
System.String
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
System.String
Program_Code
System.String
Program_Retention_Snapshot_Count
System.Int32
Switched_Award_Type_Code
System.String
Switched_Program
System.String
Switched_Program_Code
System.String
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
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentInternationalStudent
=Parameters!StudentInternationalStudent.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentStudentAthlete
=Parameters!StudentStudentAthlete.Value
StudentVeteranStudent
=Parameters!StudentVeteranStudent.Value
Powered by BI Documenter