ClassFeePaymentAverage_Query0.01958in2.42709in6.27083inWhiteNone2.44667in6.27083in1in1in1in1in0RSDS_EnterpriseDW_SSASNone0c543ad8-85db-4c30-bdf7-b70b2a00a390RSDS_EnterpriseDW_SSASWITH 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]MDXQueryStudent_FinancialsWITH 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]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!TermTermTitle.Value=Parameters!CurriculumCreditType.Value=Parameters!CurriculumCourseLevel.Value SELECT NON EMPTY { [Measures].[Fee Paid Amount], [Measures].[EOT Headcount] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Payment Source].[Payment Source Key].[Payment Source Key].ALLMEMBERS * [Payment Source].[Payment Category Short].[Payment Category Short].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), [Fee Type].[Fee Category Code].CurrentMember, IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ), IIF( STRTOSET(@CurriculumCourseLevel, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCourseLevel, CONSTRAINED), [Curriculum].[Course Level].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudent_Financials[Term].[Term Title]true[Fee Type].[Fee Category Code][Fee Type].[Fee Category Code].&[S][Fee Type].[Fee Category Code].&[C][Curriculum].[Credit Type]true[Curriculum].[Course Level]true SELECT NON EMPTY { [Measures].[Fee Paid Amount], [Measures].[EOT Headcount] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Payment Source].[Payment Source Key].[Payment Source Key].ALLMEMBERS * [Payment Source].[Payment Category Short].[Payment Category Short].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), [Fee Type].[Fee Category Code].CurrentMember, IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ), IIF( STRTOSET(@CurriculumCourseLevel, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCourseLevel, CONSTRAINED), [Curriculum].[Course Level].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermTermTitle
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]trueCurriculumCreditType
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 ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))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 ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))TermTermTitletrueCurriculumCourseLevel
Course Level
[Curriculum].[Course Level]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))TermTermTitleCurriculumCreditTypetrue<?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="[Payment Source].[Payment Category Short].[Payment Category Short]" />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 Key].[Payment Source Key]" />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<?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=IIF(IsNothing(Fields!Fee_Paid_Amount.Value),0,
IIF(IsNothing(Fields!EOT_Headcount.Value),0,
(Fields!Fee_Paid_Amount.Value / Fields!EOT_Headcount.Value)))=IIF(IsNothing(Fields!Fee_Paid_Amount.Value),0,1)Equal1RSDS_EnterpriseDW_SSAS=Parameters!TermTermTitle.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 ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))MDXQueryStudent_FinancialsWITH 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 ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))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]truetruetrue<?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!TermTermTitle.Value=Parameters!CurriculumCreditType.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))MDXQueryStudent_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])))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]trueCurriculumCreditType
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 ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))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 ( SELECT ( { [Fee Type].[Fee Category Code].&[S], [Fee Type].[Fee Category Code].&[C] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))TermTermTitletruetruetrue<?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.StringString[Term].[Term Title].&[20132]Term.Term TitleTermTermTitleParameterValueParameterCaptionIndentedString[Curriculum].[Credit Type].[All]Credit TypeCurriculumCreditTypeParameterValueParameterCaptionIndentedtrueString[Curriculum].[Course Level].[All]Course LevelCurriculumCourseLevelParameterValueParameterCaptionIndentedtrueInch3627d803-4f00-4eda-9e6d-deea5b9d90a0