Report Data Set - YTD_Expenses

Property	Value
DataSetName	YTD_Expenses_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
    {
        [Gl Code].[Gl Class].[Gl Class].ALLMEMBERS
      *
        [Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
*
  [Date].[Calendar Period].[Calendar Period]
      }
  DIMENSION PROPERTIES
    MEMBER_CAPTION
   ,MEMBER_UNIQUE_NAME
   ON ROWS
FROM [Executive_Integrated_Financials]
WHERE
(
STRTOSET(@OrgUnitLocation)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
,STRTOSET(@DateFiscalYear + ".LAG(1)")
,{[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]}
, {[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)  + ".LAG(12)")
, NONEMPTY
  (
  [Org Unit].[Org Unit SK].[Org Unit SK].Members,
    (
    STRTOMEMBER(@UserId)
    ,[Measures].[Fact Org Unit User Bridge Count]
    )
   )
)

Field Name	Field Type	Field Value
Account_Sign	System.String
Calendar_Period	System.String
Calendar_Period_Filter	System.String
Gl_Class	System.String
Journal_Amount	System.Int32
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

Parameter Name	Parameter Value
DateCalendarPeriodFilter	=Parameters!DateCalendarPeriodFilter.Value
DateFiscalYear	=Parameters!DateFiscalYear.Value
DateFiscalYear	=Parameters!DateFiscalYear.Value
OrgUnitControlOrgUnit	=Parameters!OrgUnitControlOrgUnit.Value
OrgUnitFundCode	=Parameters!OrgUnitFundCode.Value
OrgUnitLocation	=Parameters!OrgUnitLocation.Value
OrgUnitOrgUnitGrouping	=Parameters!OrgUnitOrgUnitGrouping.Value
OrgUnitReportDistribution	=Parameters!OrgUnitReportDistribution.Value
UserId	=Parameters!UserId.Value