1in1in1in1in0.85417in0.83333in0.25intruetrueCapacityTextbox3=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pttruetrueEnrolledTextbox5=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pttruetruePaid EnrolledPaid_Enrollment5=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pttruetrueAvailableTextbox132=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pttruetrueOccupancyTextbox143=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pttruetrueFTETextbox17=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt0.25intruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox342pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)Enrollment32pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment12pt2pt2pt2pttruetrue=sum(CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.Value)Textbox1332pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value) / Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox1492pt2pt2pt2pttruetrue=Sum(Fields!Full_Time_Equivalent.Value)Textbox1202pt2pt2pt2pt0.25intruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox34=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)Enrollment1=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment1=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.Value)Textbox133=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value) / Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox149=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Full_Time_Equivalent.Value)Textbox111=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox342pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)Enrollment22pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment12pt2pt2pt2pttruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.Value)Textbox1332pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value) / Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox1492pt2pt2pt2pttruetrue=Sum(Fields!Full_Time_Equivalent.Value)Textbox1022pt2pt2pt2pt0.25intruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox34=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment6=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment1=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.Value)Textbox133=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value) / Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox149=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Full_Time_Equivalent.Value)Textbox126=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value))Textbox342pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)Textbox402pt2pt2pt2pttruetrue=Sum(Fields!Paid_Enrollment.Value)Paid_Enrollment72pt2pt2pt2pttruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.Value)Textbox1332pt2pt2pt2pttruetrue=sum(Fields!Enrollment.Value) / sum(CInt(Fields!Maximum_Class_Size.Value))Textbox1492pt2pt2pt2pttruetrue=Sum(Fields!Full_Time_Equivalent.Value)Textbox412pt2pt2pt2pt0.25intruetrue=Fields!Maximum_Class_Size.ValueMaximum_Class_Size=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=Fields!Enrollment.ValueEnrollment=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=Fields!Paid_Enrollment.ValuePaid_Enrollment=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=CInt(Fields!Maximum_Class_Size.Value) - Fields!Enrollment.ValueTextbox138=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=Fields!Enrollment.Value / CInt(Fields!Maximum_Class_Size.Value)Textbox149=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=Fields!Full_Time_Equivalent.ValueFull_Time_Equivalent=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt1.88542intruetrueCampusTextbox7=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt1.25intruetrueCredit TypeTextbox9=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt1.03125intruetrueCourse IdTextbox11=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt0.92708intruetrueTime BlockTextbox13=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt1intruetrueSessionTextbox15=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt0.79167intruetrueSectionsTextbox19=First(Fields!Band1Color.Value, "GetColors")Bottom2pt2pt2pt2pt=Fields!Campus.Value=Fields!Campus.Value1.88542intruetrue=Fields!Campus.ValueCampus2pt2pt2pt2pt1.25intruetrueTextbox1132pt2pt2pt2pt1.03125intruetrueTextbox1142pt2pt2pt2pt0.92708intruetrueTextbox1152pt2pt2pt2pt1intruetrueTextbox1162pt2pt2pt2pt0.79167intruetrue=Count(Fields!Reference_Number.Value)Textbox1222pt2pt2pt2ptAfter=Fields!Credit_Type.Value=Fields!Credit_Type.Value1.25intruetrue=Fields!Credit_Type.ValueCredit_Type=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1.03125intruetrueTextbox113=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt0.92708intruetrueTextbox106=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueTextbox107=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt0.79167intruetrue=Count(Fields!Reference_Number.Value)Textbox122=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2ptAfter=Fields!Course_Id.Value=Fields!Course_Id.Value1.03125intruetrue=Fields!Course_Id.ValueCourse_Id2pt2pt2pt2pt0.92708intruetrueTextbox1132pt2pt2pt2pt1intruetrueTextbox982pt2pt2pt2pt0.79167intruetrue=Count(Fields!Reference_Number.Value)Textbox1222pt2pt2pt2ptAfter=Fields!Time_Block.Value=Fields!Time_Block.Value0.92708intruetrue=Fields!Time_Block.ValueTime_Block=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueTextbox113=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.79167intruetrue=count(Fields!Reference_Number.Value)Textbox123=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2ptAfter=Fields!Session.Value=Fields!Session.Value1intruetrue=Fields!Session.ValueSession2pt2pt2pt2pt0.79167intruetrue=count(Fields!Reference_Number.Value)Textbox1222pt2pt2pt2pt=Fields!Reference_Number.Value=Fields!Reference_Number.Value0.79167intruetrue=Fields!Reference_Number.ValueReference_Number1=iif(rownumber("Session") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttrueSessiontrueTime_BlocktrueCourse_IdtrueCredit_TypetrueCampusEnrollmentByCreditType1.31125in0.30084in1.75in12.57292intruetrueEnrollment By Credit TypeTextbox1790.8425in0.30084in0.25in12.57292in12pt2pt2pt2ptExternal=First(Fields!ImageLocation.Value, "GetImage")FitProportional0.11396in3.18167in0.5in7.17708in2HETGroup3.31125in13.87376in8.5in11in0.5in0.5in0.5in0.5in0RSDS_EnterpriseDW_SSASNone71845a7a-0d70-42bb-b0d3-aab292dbe466RSDS_EnterpriseDWNoneb055e883-70a9-44f3-98d4-27f983e01cc6RSDS_EnterpriseDW_SSAS=Parameters!CurriculumCampus.Value=Parameters!TermTermTitle.Value=Parameters!CurriculumClassStatus.Value=Parameters!CurriculumDeliveryMethod.Value SELECT NON EMPTY { [Measures].[Enrollment], [Measures].[Paid Enrollment], [Measures].[Full Time Equivalent] } ON COLUMNS, NON EMPTY { ([Curriculum].[Credit Type].[Credit Type].ALLMEMBERS * [Curriculum].[Course Id].[Course Id].ALLMEMBERS * [Curriculum].[Time Block].[Time Block].ALLMEMBERS * [Curriculum].[Session].[Session].ALLMEMBERS * [Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS * [Curriculum].[Campus].[Campus].ALLMEMBERS * [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumClassStatus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumClassStatus, CONSTRAINED), [Curriculum].[Class Status].currentmember ), IIF( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED), [Curriculum].[Delivery Method].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXExecutive_Dashboard[Curriculum].[Campus][Curriculum].[Campus].[All]true[Term].[Term Title][Term].[Term Title].[All]true[Curriculum].[Class Status][Curriculum].[Class Status].[All]true[Curriculum].[Delivery Method][Curriculum].[Delivery Method].[All]true SELECT NON EMPTY { [Measures].[Enrollment], [Measures].[Paid Enrollment], [Measures].[Full Time Equivalent] } ON COLUMNS, NON EMPTY { ([Curriculum].[Credit Type].[Credit Type].ALLMEMBERS * [Curriculum].[Course Id].[Course Id].ALLMEMBERS * [Curriculum].[Time Block].[Time Block].ALLMEMBERS * [Curriculum].[Session].[Session].ALLMEMBERS * [Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS * [Curriculum].[Campus].[Campus].ALLMEMBERS * [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumClassStatus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumClassStatus, CONSTRAINED), [Curriculum].[Class Status].currentmember ), IIF( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED), [Curriculum].[Delivery Method].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSCurriculumCampus[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 [Executive_Dashboard]trueTermTermTitle[Term].[Term Title].[All]
Term.Term Title
[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])CurriculumCampustrueCurriculumClassStatus[Curriculum].[Class Status].[All]
Class Status
[Curriculum].[Class Status]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))CurriculumCampusTermTermTitletrueCurriculumDeliveryMethod[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(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))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(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))CurriculumCampusTermTermTitleCurriculumClassStatustrue<?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].[Credit Type].[Credit 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].[Time Block].[Time Block]" />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].[Session].[Session]" />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="Measure" UniqueName="[Measures].[Enrollment]" />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="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].[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="Measure" UniqueName="[Measures].[Full Time Equivalent]" />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].[Paid Enrollment]" />System.Int32RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS
[Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue]
AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel]
AS
"0"
SELECT
{
[Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures].[ParameterLevel]
} ON COLUMNS
, {[Curriculum].[Campus].ALLMEMBERS - [Curriculum].[Campus].&[N/A]}
ON ROWS
FROM [Executive_Dashboard]MDXQueryExecutive_DashboardWITH 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 [Executive_Dashboard]true<?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!CurriculumCampus.ValueWITH MEMBER [Measures].[ParameterCaption]
AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue]
AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel]
AS "0"
--[Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL
SELECT {[Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures].[ParameterLevel]}
ON COLUMNS , [Term].[Term Title].Children
ON ROWS
FROM
( SELECT ( { [Term].[Active Term].&[Yes] } )
ON COLUMNS FROM [Executive_Dashboard])MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])CurriculumCampus[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 [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!CurriculumCampus.Value=Parameters!TermTermTitle.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))CurriculumCampus[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 [Executive_Dashboard]trueTermTermTitle[Term].[Term Title].[All]
Term.Term Title
[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])CurriculumCampustruetruetrue<?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!CurriculumCampus.Value=Parameters!TermTermTitle.Value=Parameters!CurriculumClassStatus.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(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))MDXQueryExecutive_DashboardWITH 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(@CurriculumClassStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))CurriculumCampus[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 [Executive_Dashboard]trueTermTermTitle[Term].[Term Title].[All]
Term.Term Title
[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])CurriculumCampustrueCurriculumClassStatus[Curriculum].[Class Status].[All]
Class Status
[Curriculum].[Class Status]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Class Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Class Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Class Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Class Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))CurriculumCampusTermTermTitletruetruetrue<?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_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.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Term].[Term Title].Children ON ROWS
FROM [Executive_Dashboard]
WHERE [Term].[Default Term].&[Yes];<?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="[Term].[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.StringString[Curriculum].[Campus].[All]CampusCurriculumCampusParameterValueParameterCaptionIndentedtrueStringDefaultTermParameterValueTerm.Term TitleTermTermTitleParameterValueParameterCaptionIndentedString[Curriculum].[Class Status].[All]Class StatusCurriculumClassStatusParameterValueParameterCaptionIndentedtrueString[Curriculum].[Delivery Method].[All]Delivery MethodCurriculumDeliveryMethodParameterValueParameterCaptionIndentedtrueInch5b3e9213-36c5-4821-92dc-49f8f1a6f2a8