Integrated Financials
 Monthly_Accumulator_Query (Report Data Set)
Home  Diagrams  Documents  Images  Integrated Financials  Reports  Data Sources 
Current Path:  Integrated Financials   Monthly_Accumulators_GLC.rdl   Data Sets   Monthly_Accumulator_Query
  Properties
Property Value
DataSetName Monthly_Accumulator_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].[Budget Amount]
     ,[Measures].[Summary Amount]
    } ON COLUMNS
 ,
 NON EMPTY 
    {
        [Org Unit].[State Org Unit].[State Org Unit].ALLMEMBERS*
        [Org Unit].[Qual1].[Qual1].ALLMEMBERS*
        [Org Unit].[Location Code].[Location Code].ALLMEMBERS*
        [Org Unit].[Org Unit Name].[Org Unit Name].ALLMEMBERS*
        [Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
        [Gl Code].[Glc].[Glc].ALLMEMBERS*
        [Date].[Calendar Period].[Calendar Period].ALLMEMBERS*
        [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
    }
  DIMENSION PROPERTIES 
    MEMBER_CAPTION
   ,MEMBER_UNIQUE_NAME
   ON ROWS
FROM 
(
  SELECT 
    [Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7] ON COLUMNS
  FROM 
  (
    SELECT 
      StrToSet(@DateFiscalYear) ON COLUMNS
    FROM 
    (
      SELECT 
        StrToSet(@GlCodeGlc) ON COLUMNS
      FROM 
      (
        SELECT 
          StrToSet(@OrgUnitOrgUnit) ON COLUMNS
        FROM 
        (
          SELECT 
            StrToSet(@OrgUnitLocationDescription) ON COLUMNS
        FROM 
        (
          SELECT 
            StrToSet(@OrgUnitUserGroup) ON COLUMNS
        FROM 
        (
          SELECT 
            StrToSet(@OrgUnitBudgetManager) ON COLUMNS           
          FROM 
          (
            SELECT 
              StrToSet(@OrgUnitFundCode) ON COLUMNS
            FROM [Executive_Integrated_Financials]
          )
        )
      )
    )
  )
)
)
)
WHERE
 NONEMPTY
  (
  [Org Unit].[Org Unit SK].[Org Unit SK].Members,
    (
    STRTOMEMBER(@UserId)
    ,[Measures].[Fact Org Unit User Bridge Count]
    )
   )
  Fields
Field Name Field Type Field Value
Apr_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "04", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Aug_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "08", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
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_Amount
System.Int32
Budget_Manager
System.String
Calendar_Period
System.String
Dec_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "12", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Feb_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "02", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Fiscal_Year
System.String
Fiscal_Year
System.String
Fiscal_Year
System.String
Fund_Code
System.String
Gl_Class_Code
System.String
Glc
System.String
Glc
System.String
ImageLocation
System.String
ImageType
System.String
Jan_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "01", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Jul_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "07", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Jun_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "06", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Location_Code
System.String
Location_Code
System.String
Mar_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "03", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
May_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "05", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Nov_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "11", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Oct_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "10", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
Org_Unit
System.String
Org_Unit_Name
System.String
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
Qual1
System.String
Sep_Amt
=IIF(Right(Fields!Calendar_Period.Value,2) = "09", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)
State_Org_Unit
System.String
SuggestedImageSize
System.String
Summary_Amount
System.Int32
User_Group
System.String
  Query Parameters
Parameter Name Parameter Value
DateFiscalYear
=Parameters!DateFiscalYear.Value
GlCodeGlc
=Parameters!GlCodeGlc.Value
OrgUnitBudgetManager
=Parameters!OrgUnitBudgetManager.Value
OrgUnitFundCode
=Parameters!OrgUnitFundCode.Value
OrgUnitFundCode
=Parameters!OrgUnitFundCode.Value
OrgUnitFundCode
=Parameters!OrgUnitFundCode.Value
OrgUnitFundCode
=Parameters!OrgUnitFundCode.Value
OrgUnitFundCode
=Parameters!OrgUnitFundCode.Value
OrgUnitLocationDescription
=Parameters!OrgUnitLocationDescription.Value
OrgUnitOrgUnit
=Parameters!OrgUnitOrgUnit.Value
OrgUnitUserGroup
=Parameters!OrgUnitUserGroup.Value
UserId
=Parameters!UserId.Value
Powered by BI Documenter