Report Data Set - Tuition_and_Fees_by_Month

Property	Value
DataSetName	Tuition_and_Fees_by_Month_Query
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX	True
Query Command Type	MDX
Query Data Source Name	RSDS_EnterpriseDW_SSAS
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security

SELECT
  NON EMPTY
    {
      [Measures].[Journal Amount]
    } ON COLUMNS
,
NON EMPTY
    {
      [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
      *
        [Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
      *
      [Date].[Calendar Period].[Calendar Period].ALLMEMBERS
*
[Date].[Month Of Year].[Month Of Year].ALLMEMBERS
      }
   ON ROWS
FROM
  (
    SELECT
         {
             STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
             ,STRTOMEMBER(@DateFiscalYear)
         } ON COLUMNS
    FROM [Student_Financials]
)

WHERE
(
[Gl Code].[Gl Category Code].&[40]
, {[Gl Trans Detail].[Journal Grouping].&[Actuals]}
,STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7) +
  ".FirstSibling" + ".LAG(12)")
      :
      STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7))
)

Field Name	Field Type	Field Value
Account_Sign	System.String
Calendar_Period	System.String
Calendar_Period_Filter	System.String
Fiscal_Year	System.String
Journal_Amount	System.Int32
Month_Of_Year	System.String
ParameterCaption	System.Int32
ParameterCaption	System.Int32
ParameterCaptionIndented	System.String	=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel	System.Int32
ParameterLevel	System.Int32
ParameterValue	System.Int32
ParameterValue	System.Int32
Signed_Amount		=Fields!Journal_Amount.Value * Fields!Account_Sign.Value

Parameter Name	Parameter Value
DateCalendarPeriodFilter	=Parameters!DateCalendarPeriodFilter.Value
DateFiscalYear	=Parameters!DateFiscalYear.Value
DateFiscalYear	=Parameters!DateFiscalYear.Value