Report Data Set - PercentageSpendingCurrentFY

Property	Value
DataSetName	PercentageSpendingCurrentFY_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
{
  [Measures].[ExpenseToPeriodAmount]
  ,[Measures].[ExpenseToPriorYearPeriodAmount]
} on Columns,
NON EMPTY
{
  [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS*
  [Compensation Type].[Compensation Category].[Compensation Category].ALLMEMBERS*
  [Is Budgeted].[Budgeted].[Budgeted].ALLMEMBERS*
  [Compensation Type].[Compensation Type].[Compensation Type].ALLMEMBERS*
[Position].[Position Fulltime Parttime].[Position Fulltime Parttime].ALLMEMBERS
}
  on rows
  FROM
  (
    SELECT
               STRTOSET(@DateFiscalYear) ON COLUMNS
  FROM
  (
    SELECT
               {[Gl Code].[Gl Class Code].&[5]} ON COLUMNS
    FROM [HR_Payroll]
  )
)
WHERE
(
STRTOSET(@OrgUnitLocationDescription)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
, STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7))
, 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
BackgroundAlternateColor	System.String
BackgroundColor	System.String
Band1Color	System.String
Band2Color	System.String
Band3Color	System.String
Band4Color	System.String
Band5Color	System.String
Band6Color	System.String
Budgeted	System.String
Calendar_Period_Filter	System.String
Compensation_Category	System.String
Compensation_Type	System.String
ExpenseToPeriodAmount	System.Int32
ExpenseToPriorYearPeriodAmount	System.Int32
Fiscal_Year	System.String
ImageLocation	System.String
ImageLocation	System.String
ImageType	System.String
ImageType	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
Position_Fulltime_Parttime	System.String

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