<?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <Body> <ReportItems> <Tablix Name="Tablix5"> <TablixCorner> <TablixCornerRows> <TablixCornerRow> <TablixCornerCell> <CellContents> <Textbox Name="Textbox27"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox27</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band1Color.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <ColSpan>2</ColSpan> </CellContents> </TablixCornerCell> <TablixCornerCell /> </TablixCornerRow> </TablixCornerRows> </TablixCorner> <TablixBody> <TablixColumns> <TablixColumn> <Width>0.90625in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Budget_Revenue3"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!PositionBudgetToPeriodAmount.Value)</Value> <Style> <FontSize>8pt</FontSize> <Format>N2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Budget_Revenue1</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox19"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!GlBudget0.Value)</Value> <Style> <FontSize>8pt</FontSize> <Format>N2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox10</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox5"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!ExpenseToPeriodAmt0.Value)</Value> <Style> <FontSize>8pt</FontSize> <Format>N2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox3</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox20"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!GlActual0.Value)</Value> <Style> <FontSize>8pt</FontSize> <Format>N2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox14</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox7"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox7</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember> <Group Name="Month_Of_Year"> <GroupExpressions> <GroupExpression>=Fields!Month_Of_Year.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Calendar_Period.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Month"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Month_Of_Year.Value</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Center</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Month</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band1Color.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <Group Name="Fiscal_Year4"> <GroupExpressions> <GroupExpression>=Fields!Fiscal_Year.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Fiscal_Year.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>0.58333in</Size> <CellContents> <Textbox Name="Fiscal_Year4"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Fiscal_Year.Value</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Fiscal_Year4</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1.20834in</Size> <CellContents> <Textbox Name="Textbox18"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Position Budget</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox18</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> <TablixMember> <TablixHeader> <Size>1.20834in</Size> <CellContents> <Textbox Name="Textbox31"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>GL Budget</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox30</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> <TablixMember> <TablixHeader> <Size>1.20834in</Size> <CellContents> <Textbox Name="Textbox22"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Position Expenses</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox22</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> <TablixMember> <TablixHeader> <Size>1.20834in</Size> <CellContents> <Textbox Name="Textbox26"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>GL Expenses</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox26</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> <TablixMember> <TablixHeader> <Size>1.20834in</Size> <CellContents> <Textbox Name="Textbox6"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox6</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundColor.Value, "GetColors")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>Actual_to_Revenue_Query</DataSetName> <Height>1.5in</Height> <Width>2.69792in</Width> <Style> <Border> <Style>None</Style> </Border> </Style> </Tablix> </ReportItems> <Height>1.54041in</Height> <Style /> </Body> <Width>2.76042in</Width> <Page> <LeftMargin>1in</LeftMargin> <RightMargin>1in</RightMargin> <TopMargin>1in</TopMargin> <BottomMargin>1in</BottomMargin> <Style /> </Page> <AutoRefresh>0</AutoRefresh> <DataSources> <DataSource Name="RSDS_EnterpriseDW_SSAS"> <DataSourceReference>RSDS_EnterpriseDW_SSAS</DataSourceReference> <rd:SecurityType>None</rd:SecurityType> <rd:DataSourceID>95e0f472-c858-414f-a622-ca1d5b24daa5</rd:DataSourceID> </DataSource> <DataSource Name="RSDS_EnterpriseDW"> <DataSourceReference>RSDS_EnterpriseDW</DataSourceReference> <rd:SecurityType>None</rd:SecurityType> <rd:DataSourceID>7a877ce5-e9eb-445f-985d-6c4044eb2286</rd:DataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="Actual_to_Revenue_Query"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <QueryParameters> <QueryParameter Name="DateFiscalYear"> <Value>=Parameters!DateFiscalYear.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitFundCode"> <Value>=Parameters!OrgUnitFundCode.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitReportDistribution"> <Value>=Parameters!OrgUnitReportDistribution.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitControlOrgUnit"> <Value>=Parameters!OrgUnitControlOrgUnit.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitOrgUnitGrouping"> <Value>=Parameters!OrgUnitOrgUnitGrouping.Value</Value> </QueryParameter> <QueryParameter Name="UserId"> <Value>=Parameters!UserId.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitLocationDescription"> <Value>=Parameters!OrgUnitLocationDescription.Value</Value> </QueryParameter> </QueryParameters> <CommandText>SELECT { [Measures].[GLActualsToPeriodAmount] ,[Measures].[GLBudgetToPeriodAmount] ,[Measures].[ExpenseToPeriodAmount] ,[Measures].[PositionBudgetToPeriodAmount] } ON COLUMNS , { [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS* [Date].[Month Of Year].[Month Of Year] } ON ROWS FROM ( SELECT {[Gl Code].[Gl Class Code].&[5]} ON COLUMNS FROM ( SELECT { STRTOMEMBER(@DateFiscalYear + ".LAG(1)") ,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS FROM [HR_Payroll] ) ) 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] ) ) )</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <Type>Query</Type> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Level"> <DimensionName>Date</DimensionName> <HierarchyName>Fiscal Year</HierarchyName> <HierarchyUniqueName>[Date].[Fiscal Year]</HierarchyUniqueName> <LevelName>Fiscal Year</LevelName> <UniqueName>[Date].[Fiscal Year].[Fiscal Year]</UniqueName> </ID> <ItemCaption>Fiscal Year</ItemCaption> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Date</DimensionName> <HierarchyName>FiscalCalendar</HierarchyName> <HierarchyUniqueName>[Date].[FiscalCalendar]</HierarchyUniqueName> <LevelName>Fiscal Year</LevelName> <UniqueName>[Date].[FiscalCalendar].[Fiscal Year]</UniqueName> </ID> <ItemCaption>Fiscal Year</ItemCaption> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Date</DimensionName> <HierarchyName>FiscalCalendar</HierarchyName> <HierarchyUniqueName>[Date].[FiscalCalendar]</HierarchyUniqueName> <LevelName>Calendar Period</LevelName> <UniqueName>[Date].[FiscalCalendar].[Calendar Period]</UniqueName> </ID> <ItemCaption>Calendar Period</ItemCaption> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Date</DimensionName> <HierarchyName>Month Of Year</HierarchyName> <HierarchyUniqueName>[Date].[Month Of Year]</HierarchyUniqueName> <LevelName>Month Of Year</LevelName> <UniqueName>[Date].[Month Of Year].[Month Of Year]</UniqueName> </ID> <ItemCaption>Month Of Year</ItemCaption> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>GLActualsToPeriodAmount</MeasureName> <UniqueName>[Measures].[GLActualsToPeriodAmount]</UniqueName> </ID> <ItemCaption>GLActualsToPeriodAmount</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>GLBudgetToPeriodAmount</MeasureName> <UniqueName>[Measures].[GLBudgetToPeriodAmount]</UniqueName> </ID> <ItemCaption>GLBudgetToPeriodAmount</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ExpenseToPeriodAmount</MeasureName> <UniqueName>[Measures].[ExpenseToPeriodAmount]</UniqueName> </ID> <ItemCaption>ExpenseToPeriodAmount</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>PositionBudgetToPeriodAmount</MeasureName> <UniqueName>[Measures].[PositionBudgetToPeriodAmount]</UniqueName> </ID> <ItemCaption>PositionBudgetToPeriodAmount</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>HR_Payroll</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>SELECT { [Measures].[GLActualsToPeriodAmount] ,[Measures].[GLBudgetToPeriodAmount] ,[Measures].[ExpenseToPeriodAmount] ,[Measures].[PositionBudgetToPeriodAmount] } ON COLUMNS , { [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS* [Date].[Month Of Year].[Month Of Year] } ON ROWS FROM ( SELECT {[Gl Code].[Gl Class Code].&[5]} ON COLUMNS FROM ( SELECT { STRTOMEMBER(@DateFiscalYear + ".LAG(1)") ,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS FROM [HR_Payroll] ) ) 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] ) ) )</Statement> <ParameterDefinitions> <ParameterDefinition> <Name>DateFiscalYear</Name> <DefaultValues> <DefaultValue>[Date].[Fiscal Year].&[FY 2013]</DefaultValue> </DefaultValues> <Caption>Date.Fiscal Year</Caption> <HierarchyUniqueName>[Date].[Fiscal Year]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitFundCode</Name> <DefaultValues> <DefaultValue>[Org Unit].[Fund Code].[All]</DefaultValue> </DefaultValues> <Caption>Fund Code</Caption> <HierarchyUniqueName>[Org Unit].[Fund Code]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitControlOrgUnit</Name> <DefaultValues> <DefaultValue>[Org Unit].[Control Org Unit].[All]</DefaultValue> </DefaultValues> <Caption>OrgUnitControlOrgUnit</Caption> <HierarchyUniqueName>[Org Unit].[Control Org Unit]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Control Org Unit].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitReportDistribution</Name> <DefaultValues> <DefaultValue>[Org Unit].[Report Distribution].[All]</DefaultValue> </DefaultValues> <Caption>Report Distribution</Caption> <HierarchyUniqueName>[Org Unit].[Report Distribution]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Report Distribution].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Report Distribution].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Report Distribution].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Report Distribution].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitOrgUnitGrouping</Name> <DefaultValues> <DefaultValue>[Org Unit].[Org Unit Grouping].[All]</DefaultValue> </DefaultValues> <Caption>Org Unit Grouping</Caption> <HierarchyUniqueName>[Org Unit].[Org Unit Grouping]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit Grouping].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>UserId</Name> <DefaultValues> <DefaultValue>[User].[Domain User Id].&[ad\scowan]</DefaultValue> </DefaultValues> <Caption>UserId</Caption> <HierarchyUniqueName>[User].[Domain User Id]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitLocationDescription</Name> <DefaultValues> <DefaultValue>[Org Unit].[Location Description].[All]</DefaultValue> </DefaultValues> <Caption>OrgUnitLocationDescription</Caption> <HierarchyUniqueName>[Org Unit].[Location Description]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> </ParameterDefinitions> </Query> </QueryDefinition> </rd:DesignerState> </Query> <Fields> <Field Name="Fiscal_Year"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Fiscal Year].[Fiscal Year]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Fiscal_Year2"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[FiscalCalendar].[Fiscal Year]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Month_Of_Year"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Month Of Year].[Month Of Year]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Calendar_Period"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[FiscalCalendar].[Calendar Period]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="GLActualsToPeriodAmount"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[GLActualsToPeriodAmount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="GLBudgetToPeriodAmount"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[GLBudgetToPeriodAmount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ExpenseToPeriodAmount"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ExpenseToPeriodAmount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="PositionBudgetToPeriodAmount"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[PositionBudgetToPeriodAmount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ExpenseToPeriodAmt0"> <Value>=IIF(IsNothing(Fields!ExpenseToPeriodAmount.Value),0,Fields!ExpenseToPeriodAmount.Value)</Value> </Field> <Field Name="GlBudget0"> <Value>=IIF(IsNothing(Fields!GLBudgetToPeriodAmount.Value),0,Fields!GLBudgetToPeriodAmount.Value)</Value> </Field> <Field Name="GlActual0"> <Value>=IIF(IsNothing(Fields!GLActualsToPeriodAmount.Value),0,Fields!GLActualsToPeriodAmount.Value)</Value> </Field> </Fields> </DataSet> <DataSet Name="UserId"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [HR_Payroll]</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <Type>Query</Type> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Level"> <DimensionName>User</DimensionName> <HierarchyName>Domain User Id</HierarchyName> <HierarchyUniqueName>[User].[Domain User Id]</HierarchyUniqueName> <LevelName>Domain User Id</LevelName> <UniqueName>[User].[Domain User Id].[Domain User Id]</UniqueName> </ID> <ItemCaption>Domain User Id</ItemCaption> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterCaption</MeasureName> <UniqueName>[Measures].[ParameterCaption]</UniqueName> </ID> <ItemCaption>ParameterCaption</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterValue</MeasureName> <UniqueName>[Measures].[ParameterValue]</UniqueName> </ID> <ItemCaption>ParameterValue</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterLevel</MeasureName> <UniqueName>[Measures].[ParameterLevel]</UniqueName> </ID> <ItemCaption>ParameterLevel</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>HR_Payroll</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [HR_Payroll]</Statement> <ParameterDefinitions /> </Query> </QueryDefinition> </rd:DesignerState> <rd:Hidden>true</rd:Hidden> </Query> <Fields> <Field Name="Domain_User_Id"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[User].[Domain User Id].[Domain User Id]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ParameterCaption"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterValue"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterLevel"> <DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterCaptionIndented"> <Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> <DataSet Name="GetColors"> <Query> <DataSourceName>RSDS_EnterpriseDW</DataSourceName> <CommandText>SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'GeneralLedger')</CommandText> </Query> <Fields> <Field Name="BackgroundColor"> <DataField>BackgroundColor</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="BackgroundAlternateColor"> <DataField>BackgroundAlternateColor</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band1Color"> <DataField>Band1Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band2Color"> <DataField>Band2Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band3Color"> <DataField>Band3Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band4Color"> <DataField>Band4Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band5Color"> <DataField>Band5Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band6Color"> <DataField>Band6Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> </DataSets> <ReportParameters> <ReportParameter Name="DateFiscalYear"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Date].[Fiscal Year].&[FY 2013]</Value> </Values> </DefaultValue> <Prompt>Date.Fiscal Year</Prompt> </ReportParameter> <ReportParameter Name="OrgUnitFundCode"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Fund Code].[All]</Value> </Values> </DefaultValue> <Prompt>Fund Code</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="OrgUnitReportDistribution"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Report Distribution].[All]</Value> </Values> </DefaultValue> <Prompt>Report Distribution</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="OrgUnitOrgUnitGrouping"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Org Unit Grouping].[All]</Value> </Values> </DefaultValue> <Prompt>Org Unit Grouping</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="UserId"> <DataType>String</DataType> <DefaultValue> <Values> <Value>="[User].[Domain User Id].&["+User!UserID+"]"</Value> </Values> </DefaultValue> <Hidden>true</Hidden> </ReportParameter> <ReportParameter Name="OrgUnitControlOrgUnit"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Control Org Unit].[All]</Value> </Values> </DefaultValue> <Prompt>OrgUnitControlOrgUnit</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="OrgUnitLocationDescription"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Location Description].[All]</Value> </Values> </DefaultValue> <Prompt>OrgUnitLocationDescription</Prompt> <MultiValue>true</MultiValue> </ReportParameter> </ReportParameters> <Code>Private bOddRow As Boolean Function AlternateColor (ByVal OddColor As String, ByVal EvenColor As String, ByVal Toggle As Boolean) As String If Toggle Then bOddRow = Not bOddRow If bOddRow Then Return OddColor Else Return EvenColor End If End Function</Code> <rd:ReportUnitType>Inch</rd:ReportUnitType> <rd:ReportID>ba2cb72b-2313-457d-8a5d-af4cb89bf676</rd:ReportID> </Report>