<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Chart Name="Chart2">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Label />
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Label>Filled 0 20</Label>
</ChartMember>
<ChartMember>
<Label>Filled 20 40</Label>
</ChartMember>
<ChartMember>
<Label>Filled 40 60</Label>
</ChartMember>
<ChartMember>
<Label>Filled 60 80</Label>
</ChartMember>
<ChartMember>
<Label>Filled 80 100</Label>
</ChartMember>
<ChartMember>
<Label>Filled 100 plus</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="Filled_0_20">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_0_20.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
<UseValueAsLabel>true</UseValueAsLabel>
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_0_20.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>0</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>< 20%</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Filled_20_40">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_20_40.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_20_40.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>20</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>20% < 40%</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Filled_40_60">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_40_60.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_40_60.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>40</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>40% < 60%</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Filled_60_80">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_60_80.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_60_80.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>60</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>60% < 80%</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Filled_80_100">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_80_100.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_80_100.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>80</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>80% < 100%</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
<ChartSeries Name="Filled_100_plus">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!Filled_100_plus.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<ToolTip>=Cstr(Sum(Fields!Filled_100_plus.Value))</ToolTip>
<ActionInfo>
<Actions>
<Action>
<Drillthrough>
<ReportName>ClassCapacityDetails</ReportName>
<Parameters>
<Parameter Name="OccupancyRange">
<Value>100</Value>
</Parameter>
<Parameter Name="CurriculumTerm">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]", "[Curriculum].[Term]")</Value>
</Parameter>
<Parameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</Parameter>
<Parameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</Parameter>
<Parameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</Parameter>
<Parameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</Parameter>
<Parameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</Parameter>
<Parameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
</Actions>
</ActionInfo>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<CustomProperties>
<CustomProperty>
<Name>PointWidth</Name>
<Value>1.5</Value>
</CustomProperty>
</CustomProperties>
<ChartItemInLegend>
<LegendText>100% +</LegendText>
</ChartItemInLegend>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
</ChartSeriesCollection>
</ChartData>
<ChartAreas>
<ChartArea Name="Default">
<ChartCategoryAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Class Enrollment / Capacity</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartCategoryAxes>
<ChartValueAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Number of Classes</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartValueAxes>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<FontSize>8pt</FontSize>
</Style>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption />
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>No Data Available</Caption>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>ClassCapacity</DataSetName>
<Height>2.10417in</Height>
<Width>5.40625in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
</ReportItems>
<Height>2.10417in</Height>
<Style />
</Body>
<Width>5.40625in</Width>
<Page>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="RSDS_EnterpriseDW_SSAS">
<DataSourceReference>RSDS_EnterpriseDW_SSAS</DataSourceReference>
<rd:SecurityType>None</rd:SecurityType>
<rd:DataSourceID>b2bacdae-3d59-4a79-85a8-0439546a73a4</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="ClassCapacity">
<Query>
<DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName>
<QueryParameters>
<QueryParameter Name="CurriculumTermTitle">
<Value>=Replace(Parameters!CurriculumTermTitle.Value,
"[Term].[Term Title]",
"[Curriculum].[Term]")</Value>
</QueryParameter>
<QueryParameter Name="CurriculumCampus">
<Value>=Parameters!CurriculumCampus.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumSession">
<Value>=Parameters!CurriculumSession.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumDivDept">
<Value>=Parameters!CurriculumDivDept.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumCoursePrefix">
<Value>=Parameters!CurriculumCoursePrefix.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumDeliveryMethod">
<Value>=Parameters!CurriculumDeliveryMethod.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumCreditNonCreditVocationalTest">
<Value>=Parameters!CurriculumCreditNonCreditVocationalTest.Value</Value>
</QueryParameter>
<QueryParameter Name="CurriculumCreditType">
<Value>=Parameters!CurriculumCreditType.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText> SELECT NON EMPTY { [Measures].[Enrollment], [Measures].[Maximum Class Size] } ON COLUMNS, NON EMPTY { ([Curriculum].[Reference Number].[Reference Number].ALLMEMBERS * [Curriculum].[Class Status].[Class Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))))) WHERE ( IIF( STRTOSET(@CurriculumTermTitle, CONSTRAINED).Count = 1, STRTOSET(@CurriculumTermTitle, CONSTRAINED), [Curriculum].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumCampus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCampus, CONSTRAINED), [Curriculum].[Campus].currentmember ), IIF( STRTOSET(@CurriculumSession, CONSTRAINED).Count = 1, STRTOSET(@CurriculumSession, CONSTRAINED), [Curriculum].[Session].currentmember ), IIF( STRTOSET(@CurriculumDivDept, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDivDept, CONSTRAINED), [Curriculum].[Div Dept].currentmember ), IIF( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCoursePrefix, CONSTRAINED), [Curriculum].[Course Prefix].currentmember ), IIF( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED), [Curriculum].[Delivery Method].currentmember ), IIF( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED), [Curriculum].[Credit Non Credit Vocational Test].currentmember ), IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</CommandText>
<rd:DesignerState>
<QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition">
<CommandType>MDX</CommandType>
<QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Select>
<Items>
<Item>
<ID xsi:type="Level">
<DimensionName>Curriculum</DimensionName>
<HierarchyName>Reference Number</HierarchyName>
<HierarchyUniqueName>[Curriculum].[Reference Number]</HierarchyUniqueName>
<LevelName>Reference Number</LevelName>
<UniqueName>[Curriculum].[Reference Number].[Reference Number]</UniqueName>
</ID>
<ItemCaption>Reference Number</ItemCaption>
<UniqueName>true</UniqueName>
</Item>
<Item>
<ID xsi:type="Level">
<DimensionName>Curriculum</DimensionName>
<HierarchyName>Class Status</HierarchyName>
<HierarchyUniqueName>[Curriculum].[Class Status]</HierarchyUniqueName>
<LevelName>Class Status</LevelName>
<UniqueName>[Curriculum].[Class Status].[Class Status]</UniqueName>
</ID>
<ItemCaption>Class Status</ItemCaption>
<UniqueName>true</UniqueName>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>Enrollment</MeasureName>
<UniqueName>[Measures].[Enrollment]</UniqueName>
</ID>
<ItemCaption>Enrollment</ItemCaption>
<BackColor>true</BackColor>
<ForeColor>true</ForeColor>
<FontFamily>true</FontFamily>
<FontSize>true</FontSize>
<FontWeight>true</FontWeight>
<FontStyle>true</FontStyle>
<FontDecoration>true</FontDecoration>
<FormattedValue>true</FormattedValue>
<FormatString>true</FormatString>
</Item>
<Item>
<ID xsi:type="Measure">
<MeasureName>Maximum Class Size</MeasureName>
<UniqueName>[Measures].[Maximum Class Size]</UniqueName>
</ID>
<ItemCaption>Maximum Class Size</ItemCaption>
<BackColor>true</BackColor>
<ForeColor>true</ForeColor>
<FontFamily>true</FontFamily>
<FontSize>true</FontSize>
<FontWeight>true</FontWeight>
<FontStyle>true</FontStyle>
<FontDecoration>true</FontDecoration>
<FormattedValue>true</FormattedValue>
<FormatString>true</FormatString>
</Item>
</Items>
</Select>
<From>Executive_Dashboard</From>
<Filter>
<FilterItems>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Term Title]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members />
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Campus]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Campus].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Session]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Session].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Div Dept]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Div Dept].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Course Prefix]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Course Prefix].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Delivery Method]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Delivery Method].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Credit Non Credit Vocational Test]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Credit Non Credit Vocational Test].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
<FilterItem>
<HierarchyUniqueName>[Curriculum].[Credit Type]</HierarchyUniqueName>
<Condition xsi:type="EqualTo">
<Members>
<Member>
<MemberUniqueName>[Curriculum].[Credit Type].[All]</MemberUniqueName>
</Member>
</Members>
<Parametrized>true</Parametrized>
</Condition>
</FilterItem>
</FilterItems>
</Filter>
<Calculations />
<Aggregates />
<QueryProperties />
</QuerySpecification>
<Query>
<Statement> SELECT NON EMPTY { [Measures].[Enrollment], [Measures].[Maximum Class Size] } ON COLUMNS, NON EMPTY { ([Curriculum].[Reference Number].[Reference Number].ALLMEMBERS * [Curriculum].[Class Status].[Class Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))))) WHERE ( IIF( STRTOSET(@CurriculumTermTitle, CONSTRAINED).Count = 1, STRTOSET(@CurriculumTermTitle, CONSTRAINED), [Curriculum].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumCampus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCampus, CONSTRAINED), [Curriculum].[Campus].currentmember ), IIF( STRTOSET(@CurriculumSession, CONSTRAINED).Count = 1, STRTOSET(@CurriculumSession, CONSTRAINED), [Curriculum].[Session].currentmember ), IIF( STRTOSET(@CurriculumDivDept, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDivDept, CONSTRAINED), [Curriculum].[Div Dept].currentmember ), IIF( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCoursePrefix, CONSTRAINED), [Curriculum].[Course Prefix].currentmember ), IIF( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED).Count = 1, STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED), [Curriculum].[Delivery Method].currentmember ), IIF( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED), [Curriculum].[Credit Non Credit Vocational Test].currentmember ), IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</Statement>
<ParameterDefinitions>
<ParameterDefinition>
<Name>CurriculumTermTitle</Name>
<DefaultValues />
<Caption>Term Title</Caption>
<HierarchyUniqueName>[Curriculum].[Term Title]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>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 [Executive_Dashboard]</Statement>
<ParameterizedStatement>
<ReferencedParameters />
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumCampus</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Campus].[All]</DefaultValue>
</DefaultValues>
<Caption>Campus</Caption>
<HierarchyUniqueName>[Curriculum].[Campus]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>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 [Executive_Dashboard])</Statement>
<ParameterizedStatement>
<Statement>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 [Executive_Dashboard])</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumSession</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Session].[All]</DefaultValue>
</DefaultValues>
<Caption>Session</Caption>
<HierarchyUniqueName>[Curriculum].[Session]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Session].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Session].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Session].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Session].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))</Statement>
<ParameterizedStatement>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Session].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Session].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Session].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Session].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumDivDept</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Div Dept].[All]</DefaultValue>
</DefaultValues>
<Caption>Div Dept</Caption>
<HierarchyUniqueName>[Curriculum].[Div Dept]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>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(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))</Statement>
<ParameterizedStatement>
<Statement>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(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumSession</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumCoursePrefix</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Course Prefix].[All]</DefaultValue>
</DefaultValues>
<Caption>Course Prefix</Caption>
<HierarchyUniqueName>[Curriculum].[Course Prefix]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Prefix].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Prefix].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Prefix].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Prefix].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))))</Statement>
<ParameterizedStatement>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Prefix].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Prefix].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Prefix].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Prefix].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumSession</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDivDept</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumDeliveryMethod</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Delivery Method].[All]</DefaultValue>
</DefaultValues>
<Caption>Delivery Method</Caption>
<HierarchyUniqueName>[Curriculum].[Delivery Method]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>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(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))</Statement>
<ParameterizedStatement>
<Statement>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(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumSession</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDivDept</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCoursePrefix</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumCreditNonCreditVocationalTest</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Credit Non Credit Vocational Test].[All]</DefaultValue>
</DefaultValues>
<Caption>Credit Non Credit Vocational Test</Caption>
<HierarchyUniqueName>[Curriculum].[Credit Non Credit Vocational Test]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational Test].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))))))</Statement>
<ParameterizedStatement>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational Test].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational Test].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard]))))))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumSession</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDivDept</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCoursePrefix</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDeliveryMethod</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
<ParameterDefinition>
<Name>CurriculumCreditType</Name>
<DefaultValues>
<DefaultValue>[Curriculum].[Credit Type].[All]</DefaultValue>
</DefaultValues>
<Caption>Credit Type</Caption>
<HierarchyUniqueName>[Curriculum].[Credit Type]</HierarchyUniqueName>
<ParameterValuesQuery>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))))</Statement>
<ParameterizedStatement>
<Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditNonCreditVocationalTest, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDeliveryMethod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCoursePrefix, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumDivDept, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumSession, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])))))))</Statement>
<ReferencedParameters>
<ReferencedParameter>
<Name>CurriculumTermTitle</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCampus</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumSession</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDivDept</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCoursePrefix</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumDeliveryMethod</Name>
</ReferencedParameter>
<ReferencedParameter>
<Name>CurriculumCreditNonCreditVocationalTest</Name>
</ReferencedParameter>
</ReferencedParameters>
</ParameterizedStatement>
</ParameterValuesQuery>
<MultipleValues>true</MultipleValues>
</ParameterDefinition>
</ParameterDefinitions>
</Query>
</QueryDefinition>
</rd:DesignerState>
</Query>
<Fields>
<Field Name="Reference_Number">
<DataField><?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]" /></DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Class_Status">
<DataField><?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].[Class Status].[Class Status]" /></DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Enrollment">
<DataField><?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]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="Maximum_Class_Size">
<DataField><?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].[Maximum Class Size]" /></DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentageFilled">
<Value>=Int
(IIF(IsNothing(Fields!Enrollment.Value)
, 0, IIF(IsNothing(Fields!Maximum_Class_Size.Value) OR Fields!Maximum_Class_Size.Value = 0, 100 ,Fields!Enrollment.Value / Fields!Maximum_Class_Size.Value * 100
)
)
)</Value>
</Field>
<Field Name="Filled_0_20">
<Value>=IIF(Fields!PercentageFilled.Value < 20, 1, 0)</Value>
</Field>
<Field Name="Filled_20_40">
<Value>=IIF(Fields!PercentageFilled.Value >= 20 AND
Fields!PercentageFilled.Value < 40, 1, 0)</Value>
</Field>
<Field Name="Filled_40_60">
<Value>=IIF(Fields!PercentageFilled.Value >= 40 AND
Fields!PercentageFilled.Value < 60, 1, 0)</Value>
</Field>
<Field Name="Filled_60_80">
<Value>=IIF(Fields!PercentageFilled.Value >= 60 AND
Fields!PercentageFilled.Value < 80, 1, 0)</Value>
</Field>
<Field Name="Filled_80_100">
<Value>=IIF(Fields!PercentageFilled.Value >= 80 AND
Fields!PercentageFilled.Value < 100, 1, 0)</Value>
</Field>
<Field Name="Filled_100_plus">
<Value>=IIF(Fields!PercentageFilled.Value >= 100, 1, 0)</Value>
</Field>
</Fields>
<Filters>
<Filter>
<FilterExpression>=Fields!Class_Status.Value</FilterExpression>
<Operator>NotEqual</Operator>
<FilterValues>
<FilterValue>Cancelled</FilterValue>
</FilterValues>
</Filter>
</Filters>
</DataSet>
</DataSets>
<ReportParameters>
<ReportParameter Name="CurriculumTermTitle">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Term Title].&[20132]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Term Title</Prompt>
</ReportParameter>
<ReportParameter Name="CurriculumCampus">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Campus].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Campus</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumSession">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Session].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Session</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumDivDept">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Div Dept].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Div Dept</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumCoursePrefix">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Course Prefix].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Course Prefix</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumDeliveryMethod">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Delivery Method].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Delivery Method</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumCreditNonCreditVocationalTest">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Credit Non Credit Vocational Test].[All]</Value>
</Values>
</DefaultValue>
<Prompt>Class Type</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="CurriculumCreditType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[Curriculum].[Credit Type].[All]</Value>
</Values>
</DefaultValue>
<Prompt>Credit Type</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
</ReportParameters>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
<rd:ReportID>1277f55e-0e6a-4c7f-b843-4cd2e1181f95</rd:ReportID>
</Report>