true
true
Textbox4
=First(Fields!Band2Color.Value, "GetColor")
2pt
2pt
2pt
2pt
2
1in
1in
1in
0.25in
true
true
=Sum(Fields!CurrentPercentage.Value)
CurrentPercentage
=First(Fields!BackgroundAlternateColor.Value, "GetColor")
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!PriorPercentage.Value)
PriorPercentage
=First(Fields!BackgroundAlternateColor.Value, "GetColor")
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Prior2Percentage.Value)
Prior2Percentage
=First(Fields!BackgroundAlternateColor.Value, "GetColor")
2pt
2pt
2pt
2pt
0.25in
true
true
=Sum(Fields!CurrentPercentage.Value)
Textbox19
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!PriorPercentage.Value)
Textbox27
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Prior2Percentage.Value)
Textbox30
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Term_Title.Value
Textbox2
=First(Fields!Band2Color.Value, "GetColor")
2pt
2pt
2pt
2pt
0.25in
true
true
Term Year - 1
Textbox25
=First(Fields!Band2Color.Value, "GetColor")
2pt
2pt
2pt
2pt
0.25in
true
true
Term Year - 2
Textbox28
=First(Fields!Band2Color.Value, "GetColor")
2pt
2pt
2pt
2pt
=Fields!Payment_Source_Label.Value
=IIF(Fields!CurrentPercentage.Value > 0 OR Fields!PriorPercentage.Value > 0 OR Fields!Prior2Percentage.Value > 0,1,0)
Equal
1
=Fields!Payment_Source_Code.Value
1.82292in
true
true
=Fields!Payment_Source_Label.Value
Payment_Source_Label
=First(Fields!Band2Color.Value, "GetColor")
2pt
2pt
2pt
2pt
=Fields!Payment_Category_Label.Value
=Fields!Payment_Category_Code.Value
2.0925in
true
true
=Fields!Payment_Category_Label.Value
Payment_Category_Label
2pt
2pt
2pt
2pt
true
Payment_Source_Label
2.0925in
true
true
Textbox32
2pt
2pt
2pt
2pt
Before
StudentPaymentMethod_Query
0.75in
6.91542in
0.77083in
6.91542in
1in
1in
1in
1in
0
RSDS_EnterpriseDW_SSAS
None
90644677-b268-4954-ade6-f897e1dbc60a
RSDS_EnterpriseDW
None
a53caa46-91ee-4a86-96ee-95d86477fda5
RSDS_EnterpriseDW_SSAS
=Parameters!TermTermTitle.Value
SELECT NON EMPTY { [Measures].[Prior 2Year Term Student Total Fee Count], [Measures].[Prior Year Term Student Total Fee Count], [Measures].[Fact Student Total Fees Count], [Measures].[Prior 2Year HeadCount], [Measures].[Prior Year HeadCount], [Measures].[EOT Headcount] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Term].[Term Title].[Term Title].ALLMEMBERS * [Payment Source].[Payment Source Code].[Payment Source Code].ALLMEMBERS * [Payment Source].[Payment Source Label].[Payment Source Label].ALLMEMBERS * [Payment Source].[Payment Category Code].[Payment Category Code].ALLMEMBERS * [Payment Source].[Payment Category Label].[Payment Category Label].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
MDX
Student_Financials
[Term].[Term Title]
true
SELECT NON EMPTY { [Measures].[Prior 2Year Term Student Total Fee Count], [Measures].[Prior Year Term Student Total Fee Count], [Measures].[Fact Student Total Fees Count], [Measures].[Prior 2Year HeadCount], [Measures].[Prior Year HeadCount], [Measures].[EOT Headcount] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Term].[Term Title].[Term Title].ALLMEMBERS * [Payment Source].[Payment Source Code].[Payment Source Code].ALLMEMBERS * [Payment Source].[Payment Source Label].[Payment Source Label].ALLMEMBERS * [Payment Source].[Payment Category Code].[Payment Category Code].ALLMEMBERS * [Payment Source].[Payment Category Label].[Payment Category Label].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
TermTermTitle
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 [Student_Financials]
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="Level" UniqueName="[Term].[Term SK].[Term SK]" />
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="[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="Level" UniqueName="[Payment Source].[Payment Source Code].[Payment Source Code]" />
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="[Payment Source].[Payment Source Label].[Payment Source Label]" />
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].[Fact Student Total Fees Count]" />
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="[Payment Source].[Payment Category Code].[Payment Category Code]" />
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].[Prior Year Term Student Total Fee Count]" />
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 2Year Term Student Total Fee Count]" />
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="[Payment Source].[Payment Category Label].[Payment Category Label]" />
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].[EOT Headcount]" />
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 Year HeadCount]" />
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 2Year HeadCount]" />
System.Int32
=IIF(IsNothing(Fields!Fact_Student_Total_Fees_Count.Value),0,
(Fields!Fact_Student_Total_Fees_Count.Value / Fields!EOT_Headcount.Value))
=IIF(IsNothing(Fields!Prior_Year_Term_Student_Total_Fee_Count.Value),0,
(Fields!Prior_Year_Term_Student_Total_Fee_Count.Value / Fields!Prior_Year_HeadCount.Value))
=IIF(IsNothing(Fields!Prior_2Year_Term_Student_Total_Fee_Count.Value),0,
(Fields!Prior_2Year_Term_Student_Total_Fee_Count.Value / Fields!Prior_2Year_HeadCount.Value))
RSDS_EnterpriseDW_SSAS
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 [Student_Financials]
MDX
Query
Student_Financials
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 [Student_Financials]
true
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.Value
System.String
RSDS_EnterpriseDW
SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color
FROM Configuration_Color
WHERE (ReportType = 'StudentFinancials')
BackgroundColor
System.String
BackgroundAlternateColor
System.String
Band1Color
System.String
Band2Color
System.String
Band3Color
System.String
Band4Color
System.String
Band5Color
System.String
Band6Color
System.String
String
[Term].[Term Title].&[20132]
Term.Term Title
TermTermTitle
ParameterValue
ParameterCaptionIndented
Inch
8673de80-e40b-4a32-ba63-32462f87acb2