=Sum(Fields!Fee_Paid_Amount.Value)
true
Output
=Fields!Payment_Source.Value
Shape
Pyramid
Primary
Primary
Black
0pt
Axis Title
False
0.5
NaN
NaN
NaN
Axis Title
False
0.5
NaN
Opposite
NaN
NaN
Axis Title
0.5
NaN
NaN
NaN
Axis Title
0.5
NaN
Opposite
NaN
NaN
true
BottomCenter
Black
Black
Pastel
No Data Available
FeePaymentBreakdown_Query
2.77083in
2.75in
White
None
2.77083in
2.75in
1in
1in
1in
1in
0
RSDS_EnterpriseDW_SSAS
None
0c543ad8-85db-4c30-bdf7-b70b2a00a390
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_SSAS
=Parameters!TermTermTitle.Value
SELECT NON EMPTY { [Measures].[Fee Paid Amount] } ON COLUMNS, NON EMPTY { ([Payment Source].[Payment Source].[Payment Source].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ) ) 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].[Fee Paid Amount] } ON COLUMNS, NON EMPTY { ([Payment Source].[Payment Source].[Payment Source].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ) ) 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="[Payment Source].[Payment Source].[Payment Source]" />
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].[Fee Paid Amount]" />
System.Int32
String
[Term].[Term Title].&[20132]
Term.Term Title
TermTermTitle
ParameterValue
ParameterCaptionIndented
Inch
3627d803-4f00-4eda-9e6d-deea5b9d90a0