Student Success
 dsGrades (Report Data Set)
Home  Diagrams  Documents  Images  Student Success  Reports  Data Sources 
Current Path:  Student Success   GradesByCourseReport.rdl   Data Sets   dsGrades
  Properties
Property Value
DataSetName dsGrades
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].[Grade I], [Measures].[Grade N], [Measures].[Grade F], [Measures].[Grade W], [Measures].[Grade U], [Measures].[Grade X], [Measures].[Grade P], [Measures].[Grade S], [Measures].[Grade By Letter Other], [Measures].[Students Enrolled and Withdrawn], [Measures].[Grade D], [Measures].[Grade A], [Measures].[Grade C], [Measures].[Grade B] } ON COLUMNS, NON EMPTY { ([Curriculum].[Instructional Classification Category].[Instructional Classification Category].ALLMEMBERS * [Curriculum].[Course Id].[Course Id].ALLMEMBERS * [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS * [Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentTermAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentFirstTimeInCollege, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentEthnicity, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentGender, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumPrimaryInstructorType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))))) WHERE ( IIF( STRTOSET(@CurriculumTermTitle, CONSTRAINED).Count = 1, STRTOSET(@CurriculumTermTitle, CONSTRAINED), [Curriculum].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumCampus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCampus, CONSTRAINED), [Curriculum].[Campus].currentmember ), IIF( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED), [Curriculum].[Delivery Method].currentmember ), IIF( STRTOSET(@CurriculumDivDept, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDivDept, CONSTRAINED), [Curriculum].[Div Dept].currentmember ), IIF( STRTOSET(@CurriculumPrimaryInstructorType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumPrimaryInstructorType, CONSTRAINED), [Curriculum].[Primary Instructor Type].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(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentFirstTimeInCollege, CONSTRAINED).Count = 1, STRTOSET(@StudentFirstTimeInCollege, CONSTRAINED), [Student].[First Time In College].currentmember ), IIF( STRTOSET(@StudentTermAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentTermAwardProgram, CONSTRAINED), [Student Term].[Award Program].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
BackgroundAlternateColor
System.String
BackgroundColor
System.String
Band1Color
System.String
Band2Color
System.String
Band3Color
System.String
Band4Color
System.String
Band5Color
System.String
Band6Color
System.String
Course_Id
System.String
Grade_A
System.Int32
Grade_B
System.Int32
Grade_By_Letter_Other
System.Int32
Grade_C
System.Int32
Grade_D
System.Int32
Grade_F
System.Int32
Grade_I
System.Int32
Grade_N
System.Int32
Grade_P
System.Int32
Grade_S
System.Int32
Grade_U
System.Int32
Grade_W
System.Int32
Grade_X
System.Int32
GradeTerm
System.String
ImageLocation
System.String
ImageType
System.String
Instructional_Classification_Category
System.String
Maximum_Class_Size
System.String
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
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
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
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
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
Reference_Number
System.String
Students_Enrolled_and_Withdrawn
System.Int32
Term_Title
System.String
  Query Parameters
Parameter Name Parameter Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumCampus
=Parameters!CurriculumCampus.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDeliveryMethod
=Parameters!CurriculumDeliveryMethod.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumDivDept
=Parameters!CurriculumDivDept.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumPrimaryInstructorType
=Parameters!CurriculumPrimaryInstructorType.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
CurriculumTermTitle
=Parameters!CurriculumTermTitle.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentEthnicity
=Parameters!StudentEthnicity.Value
StudentFirstTimeInCollege
=Parameters!StudentFirstTimeInCollege.Value
StudentFirstTimeInCollege
=Parameters!StudentFirstTimeInCollege.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentGender
=Parameters!StudentGender.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentInitialPrepStatus
=Parameters!StudentInitialPrepStatus.Value
StudentTermAwardProgram
=Parameters!StudentTermAwardProgram.Value
Powered by BI Documenter