75
63
90
180
0pt
0pt
External
true
RoundedWithWideIndentation
33
White
VerticalCenter
DimGray
None
1pt
=Code.Divide(
Fields!EnrollmentDifference.Value,
Fields!Prior_Enrollment.Value
) * 100
1
0pt
0pt
External
25
Wedge
Outside
="Percentage Change: " +
FORMAT(Code.Divide(Fields!EnrollmentDifference.Value,
Fields!Prior_Enrollment.Value) * 100,"##0.00") + "%"
15
#00ffffff
DiagonalLeft
Salmon
None
0pt
30
60
1
1
15
30
Inside
Red
DiagonalLeft
White
None
0pt
0
-10
1
0
1
30
30
Inside
White
DiagonalLeft
Green
None
0pt
0
0
1
10
1
30
30
Inside
0.5pt
LightSteelBlue
None
White
None
0pt
2
NaN
8
1
-8
1
NaN
NaN
DimGray
Cross
External
18
2
NaN
NaN
DimGray
Cross
External
8
1
0
WhiteSmoke
Cross
External
6
6
Circle
0
WhiteSmoke
Cross
External
6
6
Circle
NaN
NaN
0
true
true
7
WhiteSmoke
DiagonalLeft
Gainsboro
None
0pt
Edged
CustomSemiCircularN1
External
true
External
1.48
100
100
true
Gainsboro
DiagonalLeft
Gray
None
0pt
External
External
ExecDashEnrollGaugeQuery
1.73958in
2.36458in
White
1.73958in
2.36458in
1in
1in
1in
1in
0
RSDS_EnterpriseDW_SSAS
None
b82790cd-9eda-4055-9c8c-276350a4050d
RSDS_EnterpriseDW_SSAS
=Parameters!TermTermTitle.Value
=Parameters!CurriculumCampusCenter.Value
=Parameters!CurriculumDivDept.Value
=Parameters!CurriculumSession.Value
=Parameters!CurriculumDeliveryMethod.Value
=Parameters!CurriculumCoursePrefix.Value
=Parameters!CurriculumCreditNonCreditVocationalTest.Value
=Parameters!CurriculumCreditType.Value
SELECT
NON EMPTY
{ [Measures].[EnrollmentDifference], [Measures].[Prior Enrollment] } ON COLUMNS
FROM [Executive_Dashboard]
WHERE
(STRTOSET(@CurriculumDeliveryMethod)
,STRTOSET(@CurriculumCoursePrefix)
,STRTOSET(@CurriculumSession)
,STRTOSET(@CurriculumDivDept)
,STRTOSET(@CurriculumCampusCenter)
,STRTOSET(@TermTermTitle)
,STRTOSET(@CurriculumCreditNonCreditVocationalTest)
,STRTOSET(@CurriculumCreditType)
)
MDX
Query
Executive_Dashboard
SELECT
NON EMPTY
{ [Measures].[EnrollmentDifference], [Measures].[Prior Enrollment] } ON COLUMNS
FROM [Executive_Dashboard]
WHERE
(STRTOSET(@CurriculumDeliveryMethod)
,STRTOSET(@CurriculumCoursePrefix)
,STRTOSET(@CurriculumSession)
,STRTOSET(@CurriculumDivDept)
,STRTOSET(@CurriculumCampusCenter)
,STRTOSET(@TermTermTitle)
,STRTOSET(@CurriculumCreditNonCreditVocationalTest)
,STRTOSET(@CurriculumCreditType)
)
TermTermTitle
[Term].[Term Title].&[20141]
TermTermTitle
CurriculumCampusCenter
[Curriculum].[Campus Center].[All]
CurriculumCampusCenter
true
CurriculumDivDept
[Curriculum].[Div Dept].[All]
CurriculumDivDept
true
CurriculumSession
[Curriculum].[Session].[All]
CurriculumSession
true
CurriculumDeliveryMethod
[Curriculum].[Delivery Method].[All]
CurriculumDeliveryMethod
true
CurriculumCoursePrefix
[Curriculum].[Course Prefix].[All]
CurriculumCoursePrefix
true
CurriculumCreditNonCreditVocationalTest
[Curriculum].[Credit Non Credit Vocational Test].[All]
CurriculumCreditNonCreditVocationalTest
true
CurriculumCreditType
[Curriculum].[Credit Type].[All]
CurriculumCreditType
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].[EnrollmentDifference]" />
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 Enrollment]" />
System.Int32
String
[Term].[Term Title].&[20141]
Term
String
[Curriculum].[Campus Center].[All]
Campus Center
true
String
[Curriculum].[Div Dept].[All]
Division Department
true
String
[Curriculum].[Session].[All]
Session
true
String
[Curriculum].[Delivery Method].[All]
Delivery Method
true
String
[Curriculum].[Course Prefix].[All]
true
Course Prefix
true
String
[Curriculum].[Credit Non Credit Vocational Test].[All]
Class Type
true
String
[Curriculum].[Credit Type].[All]
Credit Type
true
Function Divide(Numerator as Double, Denominator as Double)
If Denominator = 0 Then
Return 0
Else
Return Numerator/Denominator
End If
End Function
Inch
891aaaf1-a49e-4e24-9624-eab82d674c2e