Report Data Set - Actual_to_Revenue

Property	Value
DataSetName	Actual_to_Revenue_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].[ActualToPeriodAmount]
     ,[Measures].[BudgetToPeriodAmount]
    } ON COLUMNS
,
    {
        [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS*
        [Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS*
        [Date].[Month Of Year].[Month Of Year]*
        [Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
        [Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
    } ON ROWS
FROM
(
  SELECT
    {[Gl Code].[Gl Class Code].&[4]:[Gl Code].[Gl Class Code].&[7]} ON COLUMNS
  FROM
  (
    SELECT
      {
        STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
       ,STRTOMEMBER(@DateFiscalYear)     } ON COLUMNS
    FROM [Executive_Integrated_Financials]
  )
)
WHERE
(
STRTOSET(@OrgUnitLocationDescription)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
, 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
Actual_Expenses		=IIf(Fields!Gl_Class_Code.Value >= "5" and Fields!Gl_Class_Code.Value <= "7" , Fields!ActualToPeriodAmount.Value, 0)
Actual_Revenue		=IIf(Fields!Gl_Class_Code.Value = "4", Fields!ActualToPeriodAmount.Value * Fields!Account_Sign.Value, 0)
ActualToPeriodAmount	System.Int32
BackgroundAlternateColor	System.String
BackgroundColor	System.String
Band1Color	System.String
Band2Color	System.String
Band3Color	System.String
Band4Color	System.String
Band5Color	System.String
Band6Color	System.String
Budget_Expenses		=IIf(Fields!Gl_Class_Code.Value >= "5" and Fields!Gl_Class_Code.Value <= "7" , Fields!BudgetToPeriodAmount.Value * Fields!Account_Sign.Value, 0)
Budget_Revenue		=IIf(Fields!Gl_Class_Code.Value = "4", Fields!BudgetToPeriodAmount.Value * Fields!Account_Sign.Value, 0)
BudgetToPeriodAmount	System.Int32
Calendar_Period	System.String
Fiscal_Year	System.String
Fiscal_Year2	System.String
Gl_Class_Code	System.String
Month_Of_Year	System.String
ParameterCaption	System.Int32
ParameterCaptionIndented	System.String	=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel	System.Int32
ParameterValue	System.Int32

Parameter Name	Parameter 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