0.59375in0.84375in0.86458in1in1.32292in1.3125in1in0.84375in0.70833in0.84375in0.25intruetrueCountTextbox402pt2pt2pt2pttruetrueReference NumberTextbox12pt2pt2pt2pttruetrueCourse IdTextbox32pt2pt2pt2pttruetrueClass TitleTextbox52pt2pt2pt2pttruetrueCampusTextbox72pt2pt2pt2pttruetrueSessionTextbox202pt2pt2pt2pttruetrueClass StatusTextbox222pt2pt2pt2pttruetrueEnrollmentTextbox132pt2pt2pt2pttruetrueMax SizeTextbox112pt2pt2pt2pttruetrueOccupancyTextbox92pt2pt2pt2pt0.25intruetrue=RowNumber("dsClassCapacityDetails")Textbox412pt2pt2pt2pttruetrue=Fields!Reference_Number.ValueReference_Number2pt2pt2pt2pttruetrue=Fields!Course_Id.ValueCourse_Id2pt2pt2pt2pttruetrue=Fields!Class_Title.ValueClass_Title2pt2pt2pt2pttruetrue=Fields!Campus.ValueCampus2pt2pt2pt2pttruetrue=Fields!Session.ValueSession2pt2pt2pt2pttruetrue=Fields!Class_Status.ValueClass_Status2pt2pt2pt2pttruetrue=Fields!Enrollment.ValueEnrollment2pt2pt2pt2pttruetrue=CInt(Fields!Maximum_Class_Size.Value)Maximum_Class_Size2pt2pt2pt2pttruetrue=IIF(IsNothing(Fields!Enrollment.Value)
, 0, IIF(IsNothing(Fields!Maximum_Class_Size.Value) OR Fields!Maximum_Class_Size.Value = 0, 1 ,Fields!Enrollment.Value / Fields!Maximum_Class_Size.Value
)
)Textbox102pt2pt2pt2pt0.25intruetrueTextbox422pt2pt2pt2pttruetrueTextbox282pt2pt2pt2pttruetrueTextbox292pt2pt2pt2pttruetrueTextbox302pt2pt2pt2pttruetrueTextbox312pt2pt2pt2pttruetrueTextbox322pt2pt2pt2pttruetrueTextbox352pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)Textbox362pt2pt2pt2pttruetrue=Sum(CInt(Fields!Maximum_Class_Size.Value), "dsClassCapacityDetails")Textbox372pt2pt2pt2pttruetrue=Sum(Fields!Enrollment.Value)
/
Sum(CInt(Fields!Maximum_Class_Size.Value),
"dsClassCapacityDetails")Textbox382pt2pt2pt2ptAfterBeforetruedsClassCapacityDetails0.01042in0.75in9.33333in0.75in9.34375in400in8.5in1in1in1in1in0RSDS_EnterpriseDW_SSASNone0ee13c5f-eaef-402e-8cff-cf6ce299f533RSDS_EnterpriseDW_SSAS=Parameters!OccupancyRange.Valuetrue=Parameters!CurriculumTerm.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumSession.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumCoursePrefix.Value=Parameters!CurriculumCreditNonCreditVocationalTest.Value=Parameters!CurriculumCreditType.ValueSELECT
{[Measures].[Enrollment]} ON COLUMNS
,{
[Curriculum].[Reference Number].[Reference Number].ALLMEMBERS*
[Curriculum].[Course Id].[Course Id].ALLMEMBERS*
[Curriculum].[Class Title].[Class Title].ALLMEMBERS*
[Curriculum].[Campus].[Campus].ALLMEMBERS*
[Curriculum].[Session].[Session].ALLMEMBERS*
[Curriculum].[Class Status].[Class Status].ALLMEMBERS*
[Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet
(@CurriculumCoursePrefix
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumDeliveryMethod
,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
(@CurriculumTerm
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumCreditNonCreditVocationalTest
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumCreditType
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Dashboard]
)
)
)
)
)
)
)
)
WHERE
(
IIF
(
StrToSet(@CurriculumTerm,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumTerm
,CONSTRAINED
)
,[Curriculum].[Term].CurrentMember
)
,IIF
(
StrToSet(@CurriculumDivDept,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumDivDept
,CONSTRAINED
)
,[Curriculum].[Div Dept].CurrentMember
)
,IIF
(
StrToSet(@CurriculumDeliveryMethod,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumDeliveryMethod
,CONSTRAINED
)
,[Curriculum].[Delivery Method].CurrentMember
)
,IIF
(
StrToSet(@CurriculumCoursePrefix,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumCoursePrefix
,CONSTRAINED
)
,[Curriculum].[Course Prefix].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;MDXQueryExecutive_DashboardSELECT
{[Measures].[Enrollment]} ON COLUMNS
,{
[Curriculum].[Reference Number].[Reference Number].ALLMEMBERS*
[Curriculum].[Course Id].[Course Id].ALLMEMBERS*
[Curriculum].[Class Title].[Class Title].ALLMEMBERS*
[Curriculum].[Campus].[Campus].ALLMEMBERS*
[Curriculum].[Session].[Session].ALLMEMBERS*
[Curriculum].[Class Status].[Class Status].ALLMEMBERS*
[Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet
(@CurriculumCoursePrefix
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumDeliveryMethod
,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
(@CurriculumTerm
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumCreditNonCreditVocationalTest
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CurriculumCreditType
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Dashboard]
)
)
)
)
)
)
)
)
WHERE
(
IIF
(
StrToSet(@CurriculumTerm,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumTerm
,CONSTRAINED
)
,[Curriculum].[Term].CurrentMember
)
,IIF
(
StrToSet(@CurriculumDivDept,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumDivDept
,CONSTRAINED
)
,[Curriculum].[Div Dept].CurrentMember
)
,IIF
(
StrToSet(@CurriculumDeliveryMethod,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumDeliveryMethod
,CONSTRAINED
)
,[Curriculum].[Delivery Method].CurrentMember
)
,IIF
(
StrToSet(@CurriculumCoursePrefix,CONSTRAINED).Count = 1
,StrToSet
(@CurriculumCoursePrefix
,CONSTRAINED
)
,[Curriculum].[Course Prefix].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;CurriculumTerm[Curriculum].[Term].&[20121]
Term
[Curriculum].[Term]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Term].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Term].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Term].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Term].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]trueCurriculumSession[Curriculum].[Session].[All]
Session
[Curriculum].[Session]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 [Executive_Dashboard]trueCurriculumDivDept[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 [Executive_Dashboard]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 [Executive_Dashboard]trueCurriculumCoursePrefix[Curriculum].[Course Prefix].[All]
Course Prefix
[Curriculum].[Course Prefix]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 [Executive_Dashboard]trueCurriculumCreditNonCreditVocationalTest[Curriculum].[Credit Non Credit Vocational Test].[All]
CurriculumCreditNonCreditVocationalTest
[Curriculum].[Credit Non Credit Vocational Test]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 [Executive_Dashboard]trueCurriculumCreditType[Curriculum].[Credit Type].[All]