[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttrueStudentGender[Student].[Gender].[All]
Gender
[Student].[Gender]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypetrueStudentEthnicity[Student].[Ethnicity].[All]
Ethnicity
[Student].[Ethnicity]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGendertrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicitytrueStudentFirstTimeInCollege[Student].[First Time In College].[All]
First Time In College
[Student].[First Time In College]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicityStudentInitialPrepStatustrueStudentTermAwardProgram[Student Term].[Award Program].[All]
Award Program
[Student Term].[Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Term].[Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Term].[Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Term].[Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Term].[Award Program].ALLMEMBERS ON ROWS 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])))))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student Term].[Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Term].[Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Term].[Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Term].[Award Program].ALLMEMBERS ON ROWS 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])))))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicityStudentInitialPrepStatusStudentFirstTimeInCollegetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Reference Number].[Reference Number]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Instructional Classification Category].[Instructional Classification Category]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Maximum Class Size].[Maximum Class Size]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Course Id].[Course Id]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade A]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Students Enrolled and Withdrawn]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade B]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade C]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade D]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade F]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade W]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade By Letter Other]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade I]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade N]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade P]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade S]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade U]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Grade X]" />System.Int32RSDS_EnterpriseDWSELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color
FROM Configuration_Color
WHERE (ReportType = 'Enrollment')BackgroundColorSystem.StringBackgroundAlternateColorSystem.StringBand1ColorSystem.StringBand2ColorSystem.StringBand3ColorSystem.StringBand4ColorSystem.StringBand5ColorSystem.StringBand6ColorSystem.StringRSDS_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
{HEAD([Grade Terms],1)} ON ROWS
FROM [StudentSuccess]MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterValue]
AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
{HEAD([Grade Terms],1)} ON ROWS
FROM [StudentSuccess]
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Term Title].[Term Title]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]truetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
{[Grade Terms]} ON ROWS
FROM [StudentSuccess]MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterValue]
AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
{[Grade Terms]} ON ROWS
FROM [StudentSuccess]
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Curriculum].[Term Title].[Term Title]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]truetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]truetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumPrimaryInstructorType.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumPrimaryInstructorType.Value=Parameters!StudentGender.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttrueStudentGender[Student].[Gender].[All]
Gender
[Student].[Gender]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypetruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumPrimaryInstructorType.Value=Parameters!StudentGender.Value=Parameters!StudentEthnicity.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttrueStudentGender[Student].[Gender].[All]
Gender
[Student].[Gender]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypetrueStudentEthnicity[Student].[Ethnicity].[All]
Ethnicity
[Student].[Ethnicity]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGendertruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumPrimaryInstructorType.Value=Parameters!StudentGender.Value=Parameters!StudentEthnicity.Value=Parameters!StudentInitialPrepStatus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttrueStudentGender[Student].[Gender].[All]
Gender
[Student].[Gender]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypetrueStudentEthnicity[Student].[Ethnicity].[All]
Ethnicity
[Student].[Ethnicity]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGendertrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicitytruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!CurriculumTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumPrimaryInstructorType.Value=Parameters!StudentGender.Value=Parameters!StudentEthnicity.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentFirstTimeInCollege.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Term].[Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Term].[Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Term].[Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Term].[Award Program].ALLMEMBERS ON ROWS 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])))))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Term].[Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Term].[Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Term].[Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Term].[Award Program].ALLMEMBERS ON ROWS 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])))))))))CurriculumTermTitle[Curriculum].[Term Title].&[20122]
Term Title
[Curriculum].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term Title].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDeliveryMethod[Curriculum].[Delivery Method].[All]
Delivery Method
[Curriculum].[Delivery Method]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Delivery Method].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Delivery Method].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Delivery Method].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Delivery Method].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumCampustrueCurriculumDivDept[Curriculum].[Div Dept].[All]
Div Dept
[Curriculum].[Div Dept]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Div Dept].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Div Dept].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Div Dept].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Div Dept].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodtrueCurriculumPrimaryInstructorType[Curriculum].[Primary Instructor Type].[All]
Primary Instructor Type
[Curriculum].[Primary Instructor Type]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Primary Instructor Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Primary Instructor Type].ALLMEMBERS ON ROWS 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]))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDepttrueStudentGender[Student].[Gender].[All]
Gender
[Student].[Gender]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Gender].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Gender].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Gender].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Gender].ALLMEMBERS ON ROWS 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])))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypetrueStudentEthnicity[Student].[Ethnicity].[All]
Ethnicity
[Student].[Ethnicity]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Ethnicity].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Ethnicity].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Ethnicity].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Ethnicity].ALLMEMBERS ON ROWS 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]))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGendertrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS 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])))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicitytrueStudentFirstTimeInCollege[Student].[First Time In College].[All]
First Time In College
[Student].[First Time In College]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[First Time In College].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[First Time In College].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[First Time In College].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[First Time In College].ALLMEMBERS ON ROWS 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]))))))))CurriculumTermTitleCurriculumCampusCurriculumDeliveryMethodCurriculumDivDeptCurriculumPrimaryInstructorTypeStudentGenderStudentEthnicityStudentInitialPrepStatustruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringStringDefaultTermParameterValueTerm TitledsGradeTermsParameterValueGradeTermString[Curriculum].[Campus].[All]CampusCurriculumCampusParameterValueParameterCaptionIndentedString[Curriculum].[Delivery Method].[All]Delivery MethodCurriculumDeliveryMethodParameterValueParameterCaptionIndentedString[Curriculum].[Div Dept].[All]Div DeptCurriculumDivDeptParameterValueParameterCaptionIndentedString[Curriculum].[Primary Instructor Type].[All]Primary Instructor TypeCurriculumPrimaryInstructorTypeParameterValueParameterCaptionIndentedString[Student].[Gender].[All]GenderStudentGenderParameterValueParameterCaptionIndentedString[Student].[Ethnicity].[All]EthnicityStudentEthnicityParameterValueParameterCaptionIndentedString[Student].[Initial Prep Status].[All]Initial Prep StatusStudentInitialPrepStatusParameterValueParameterCaptionIndentedString[Student].[First Time In College].[All]First Time In CollegeStudentFirstTimeInCollegeParameterValueParameterCaptionIndentedString[Student Term].[Award Program].[All]Award ProgramStudentTermAwardProgramParameterValueParameterCaptionIndentedInch5b3e9213-36c5-4821-92dc-49f8f1a6f2a8