Integrated Financials
 ReceiptsByPaymentMethod_Query (Report Data Set)
Home  Diagrams  Documents  Images  Integrated Financials  Reports  Data Sources 
Current Path:  Integrated Financials   ReceiptsByPaymentMethod.rdl   Data Sets   ReceiptsByPaymentMethod_Query
  Properties
Property Value
DataSetName ReceiptsByPaymentMethod_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
  Query Command Text
SELECT 
  NON EMPTY 
{
    [Measures].[ReceiptPaymentsToPeriod] 
} on Columns,
NON EMPTY
 {
  [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS*
  [Date].[Calendar Period].[Calendar Period].ALLMEMBERS*
  [Receipt Payment Category].[Receipt Payment Method].[Receipt Payment Method].ALLMEMBERS*
([Receipt Payment Category].[Receipt Payment Method Code].Children
  [Receipt Payment Category].[Receipt Payment Method Code].&[CV] 
  [Receipt Payment Category].[Receipt Payment Method Code].&[OC]
  [Receipt Payment Category].[Receipt Payment Method Code].&[DP])
 }  on rows
FROM 
  (
    SELECT 
         {
               STRTOMEMBER(@DateFiscalYear + ".LAG(4)") 
              ,STRTOMEMBER(@DateFiscalYear + ".LAG(3)") 
              ,STRTOMEMBER(@DateFiscalYear + ".LAG(2)") 
              ,STRTOMEMBER(@DateFiscalYear + ".LAG(1)") 
              ,STRTOMEMBER(@DateFiscalYear) 
         } ON COLUMNS
    FROM [Student_Financials]
)
  
WHERE
(
 {STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + 
     VBA!Right(@DateCalendarPeriodFilter,7))
 , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + 
     VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(12)")
 , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + 
     VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(24)")
 , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + 
     VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(36)")
 , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + 
     VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(48)")}
)
  Fields
Field Name Field Type Field Value
Calendar_Period
System.String
Calendar_Period_Filter
System.String
Fiscal_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
Receipt_Payment_Method
System.String
Receipt_Payment_Method_Code
System.String
ReceiptPaymentsToPeriod
System.Int32
  Query Parameters
Parameter Name Parameter Value
DateCalendarPeriodFilter
=Parameters!DateCalendarPeriodFilter.Value
DateFiscalYear
=Parameters!DateFiscalYear.Value
DateFiscalYear
=Parameters!DateFiscalYear.Value
Powered by BI Documenter