7563901800pt0ptExternaltrueRoundedWithWideIndentation33WhiteVerticalCenterDimGrayNone1pt=IIF(SUM(Fields!Prior_Full_Time_Equivalent.Value) = 0 OR IsNothing(SUM(Fields!Prior_Full_Time_Equivalent.Value)) OR SUM(Fields!FTEDifference.Value) = 0 OR IsNothing(SUM(Fields!FTEDifference.Value))
, 0
, (SUM(Fields!FTEDifference.Value) / SUM(Fields!Prior_Full_Time_Equivalent.Value)) * 100)10pt0ptExternal25WedgeOutside="Percentage Change: " +
FORMAT(IIF(SUM(Fields!FTEDifference.Value) = 0 OR IsNothing(SUM(Fields!FTEDifference.Value)) OR SUM(Fields!FTEDifference.Value) = 0 OR IsNothing(SUM(Fields!FTEDifference.Value)), 0,
Code.Divide(SUM(Fields!FTEDifference.Value),
SUM(Fields!Prior_Full_Time_Equivalent.Value)) * 100),"##0.00") + "%"15#00ffffffDiagonalLeftSalmonNone0pt3060111530InsideRedDiagonalLeftWhiteNone0pt0-101013030InsideWhiteDiagonalLeftGreenNone0pt0011013030Inside0.5ptLightSteelBlueNoneWhiteNone0pt2NaN81-81NaNNaNDimGrayCrossExternal182NaNNaNDimGrayCrossExternal810WhiteSmokeCrossExternal66Circle0WhiteSmokeCrossExternal66CircleNaNNaN0truetrue7WhiteSmokeDiagonalLeftGainsboroNone0ptEdgedCustomSemiCircularN1ExternaltrueExternal1.48100100trueGainsboroDiagonalLeftGrayNone0ptExternalExternalExecDashEnrollGaugeQuery1.78125in2.59375inWhite1.80208in2.625in1in1in1in1in0RSDS_EnterpriseDW_SSASNoneb82790cd-9eda-4055-9c8c-276350a4050dRSDS_EnterpriseDW_SSAS=Parameters!TermTermTitle.Value=Parameters!CurriculumCampus.Value=Parameters!CurriculumDivDept.Value=Parameters!CurriculumSession.Value=Parameters!CurriculumDeliveryMethod.Value=Parameters!CurriculumCoursePrefix.Value=Parameters!CurriculumCreditNonCreditVocational.Value=Parameters!CurriculumCreditType.ValueSELECT
// NON EMPTY
{
[Measures].[Prior Full Time Equivalent]
,[Measures].[FTEDifference]
} ON COLUMNS
FROM
[Executive_Dashboard]
WHERE
(
STRTOSET(@TermTermTitle)
,STRTOSET(@CurriculumDeliveryMethod)
,STRTOSET(@CurriculumCoursePrefix)
,STRTOSET(@CurriculumSession)
,STRTOSET(@CurriculumDivDept)
,STRTOSET(@CurriculumCampus)
,STRTOSET(@CurriculumCreditNonCreditVocational)
,STRTOSET(@CurriculumCreditType)
)MDXQueryExecutive_DashboardSELECT
// NON EMPTY
{
[Measures].[Prior Full Time Equivalent]
,[Measures].[FTEDifference]
} ON COLUMNS
FROM
[Executive_Dashboard]
WHERE
(
STRTOSET(@TermTermTitle)
,STRTOSET(@CurriculumDeliveryMethod)
,STRTOSET(@CurriculumCoursePrefix)
,STRTOSET(@CurriculumSession)
,STRTOSET(@CurriculumDivDept)
,STRTOSET(@CurriculumCampus)
,STRTOSET(@CurriculumCreditNonCreditVocational)
,STRTOSET(@CurriculumCreditType)
)TermTermTitle[Term].[Term Title].&[20141]
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 [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]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]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]trueCurriculumCreditNonCreditVocational[Curriculum].[Credit Non Credit Vocational].[All]
Credit Non Credit Vocational
[Curriculum].[Credit Non Credit Vocational]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]trueCurriculumCreditType[Curriculum].[Credit Type].[All]
Credit Type
[Curriculum].[Credit Type]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 [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].[FTEDifference]" />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].[Prior Full Time Equivalent]" />System.Int32="1"RSDS_EnterpriseDW_SSASWITH 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]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]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!CurriculumCreditNonCreditVocational.ValueWITH
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
(@CurriculumCreditNonCreditVocational
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Dashboard]
);MDXQueryExecutive_DashboardWITH
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
(@CurriculumCreditNonCreditVocational
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Dashboard]
);CurriculumCreditNonCreditVocational[Curriculum].[Credit Non Credit Vocational].[All]
CurriculumCreditNonCreditVocational
[Curriculum].[Credit Non Credit Vocational]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational].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="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="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Non Credit Vocational].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Non Credit Vocational].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]truetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSASWITH
MEMBER [Measures].[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]
;MDXQueryExecutive_DashboardWITH
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]
;<?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].[Div Dept].[Division]" />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].[Div Dept].[Department]" />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].[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.Int32String[Term].[Term Title].&[20141]TermString[Curriculum].[Div Dept].[All]Division DepartmentCurriculumDivDeptParameterValueParameterCaptiontrueString[Curriculum].[Session].[All]SessiontrueString[Curriculum].[Delivery Method].[All]Delivery MethodtrueString[Curriculum].[Course Prefix].[All]trueCourse PrefixtrueString[Curriculum].[Campus].[All]CurriculumCampusCurriculumCampusParameterValueParameterCaptionIndentedtrueString[Curriculum].[Credit Non Credit Vocational].[All]CurriculumCreditNonCreditVocationalCurriculumCreditNonCreditVocationalParameterValueParameterCaptionIndentedtrueString[Curriculum].[Credit Type].[All]Credit TypeCurriculumCreditTypeParameterValueParameterCaptionIndentedtrueFunction Divide(Numerator as Double, Denominator as Double)
If Denominator = 0 Then
Return 0
Else
Return Numerator/Denominator
End If
End Function
Inch891aaaf1-a49e-4e24-9624-eab82d674c2e