[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]trueCurriculumDeliveryMethod[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(@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(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])CurriculumTermTitletrueCurriculumDivDept[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(@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(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))CurriculumTermTitleCurriculumDeliveryMethodtrue<?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].[Campus].[Campus]" />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].[Primary Instructor Type].[Primary Instructor Type]" />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="Level" UniqueName="[Curriculum].[Instructional Classification].[Instructional Classification]" />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].[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].[Successful]" />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].[Marginal]" />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].[Fail]" />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].[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].[Other]" />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_SSAS=Parameters!CurriculumTermTitle.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(@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(@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!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(@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(@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]trueCurriculumDeliveryMethod[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(@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(@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_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.Int32StringDefaultTermParameterValueGrade TermdsGradeTermsParameterValueGradeTermString[Curriculum].[Delivery Method].[All]Delivery MethodCurriculumDeliveryMethodParameterValueParameterCaptionIndentedString[Curriculum].[Div Dept].[All]Div DeptCurriculumDivDeptParameterValueParameterCaptionIndentedInch5b3e9213-36c5-4821-92dc-49f8f1a6f2a8