<?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> <Chart Name="YTD_Compensation"> <ChartCategoryHierarchy> <ChartMembers> <ChartMember> <Group Name="YTD_Compensation_CategoryGroup"> <GroupExpressions> <GroupExpression>=Fields!Function_Description.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Function_Description.Value</Value> </SortExpression> </SortExpressions> <Label>=Fields!Function_Description.Value</Label> </ChartMember> </ChartMembers> </ChartCategoryHierarchy> <ChartSeriesHierarchy> <ChartMembers> <ChartMember> <Label>Journal Amount</Label> </ChartMember> </ChartMembers> </ChartSeriesHierarchy> <ChartData> <ChartSeriesCollection> <ChartSeries Name="Journal_Amount"> <ChartDataPoints> <ChartDataPoint> <ChartDataPointValues> <X>=Fields!Function_Description.Value</X> <Y>=Sum(Fields!Journal_Amount.Value)</Y> </ChartDataPointValues> <ChartDataLabel> <Style /> <Label>#PERCENT</Label> <Visible>true</Visible> </ChartDataLabel> <ToolTip>=FORMAT(Sum(Fields!Journal_Amount.Value),"C2")</ToolTip> <Style /> <ChartMarker> <Style /> </ChartMarker> <DataElementOutput>Output</DataElementOutput> </ChartDataPoint> </ChartDataPoints> <Type>Shape</Type> <Subtype>Pyramid</Subtype> <Style /> <ChartEmptyPoints> <Style /> <ChartMarker> <Style /> </ChartMarker> <ChartDataLabel> <Style /> </ChartDataLabel> </ChartEmptyPoints> <ValueAxisName>Primary</ValueAxisName> <CategoryAxisName>Primary</CategoryAxisName> <ChartSmartLabel> <CalloutLineColor>Black</CalloutLineColor> <MinMovingDistance>0pt</MinMovingDistance> </ChartSmartLabel> </ChartSeries> </ChartSeriesCollection> </ChartData> <ChartAreas> <ChartArea Name="Default"> <ChartCategoryAxes> <ChartAxis Name="Primary"> <Style> <FontSize>8pt</FontSize> </Style> <ChartAxisTitle> <Caption>Axis Title</Caption> <Style> <FontSize>8pt</FontSize> </Style> </ChartAxisTitle> <ChartMajorGridLines> <Enabled>False</Enabled> <Style> <Border> <Color>Gainsboro</Color> </Border> </Style> </ChartMajorGridLines> <ChartMinorGridLines> <Style> <Border> <Color>Gainsboro</Color> <Style>Dotted</Style> </Border> </Style> </ChartMinorGridLines> <ChartMinorTickMarks> <Length>0.5</Length> </ChartMinorTickMarks> <CrossAt>NaN</CrossAt> <Minimum>NaN</Minimum> <Maximum>NaN</Maximum> <ChartAxisScaleBreak> <Style /> </ChartAxisScaleBreak> </ChartAxis> <ChartAxis Name="Secondary"> <Style> <FontSize>8pt</FontSize> </Style> <ChartAxisTitle> <Caption>Axis Title</Caption> <Style> <FontSize>8pt</FontSize> </Style> </ChartAxisTitle> <ChartMajorGridLines> <Enabled>False</Enabled> <Style> <Border> <Color>Gainsboro</Color> </Border> </Style> </ChartMajorGridLines> <ChartMinorGridLines> <Style> <Border> <Color>Gainsboro</Color> <Style>Dotted</Style> </Border> </Style> </ChartMinorGridLines> <ChartMinorTickMarks> <Length>0.5</Length> </ChartMinorTickMarks> <CrossAt>NaN</CrossAt> <Location>Opposite</Location> <Minimum>NaN</Minimum> <Maximum>NaN</Maximum> <ChartAxisScaleBreak> <Style /> </ChartAxisScaleBreak> </ChartAxis> </ChartCategoryAxes> <ChartValueAxes> <ChartAxis Name="Primary"> <Style> <FontSize>8pt</FontSize> </Style> <ChartAxisTitle> <Caption>Axis Title</Caption> <Style> <FontSize>8pt</FontSize> </Style> </ChartAxisTitle> <ChartMajorGridLines> <Style> <Border> <Color>Gainsboro</Color> </Border> </Style> </ChartMajorGridLines> <ChartMinorGridLines> <Style> <Border> <Color>Gainsboro</Color> <Style>Dotted</Style> </Border> </Style> </ChartMinorGridLines> <ChartMinorTickMarks> <Length>0.5</Length> </ChartMinorTickMarks> <CrossAt>NaN</CrossAt> <Minimum>NaN</Minimum> <Maximum>NaN</Maximum> <ChartAxisScaleBreak> <Style /> </ChartAxisScaleBreak> </ChartAxis> <ChartAxis Name="Secondary"> <Style> <FontSize>8pt</FontSize> </Style> <ChartAxisTitle> <Caption>Axis Title</Caption> <Style> <FontSize>8pt</FontSize> </Style> </ChartAxisTitle> <ChartMajorGridLines> <Style> <Border> <Color>Gainsboro</Color> </Border> </Style> </ChartMajorGridLines> <ChartMinorGridLines> <Style> <Border> <Color>Gainsboro</Color> <Style>Dotted</Style> </Border> </Style> </ChartMinorGridLines> <ChartMinorTickMarks> <Length>0.5</Length> </ChartMinorTickMarks> <CrossAt>NaN</CrossAt> <Location>Opposite</Location> <Minimum>NaN</Minimum> <Maximum>NaN</Maximum> <ChartAxisScaleBreak> <Style /> </ChartAxisScaleBreak> </ChartAxis> </ChartValueAxes> <Style> <BackgroundGradientType>None</BackgroundGradientType> </Style> </ChartArea> </ChartAreas> <ChartLegends> <ChartLegend Name="Default"> <Style> <BackgroundGradientType>None</BackgroundGradientType> <FontSize>8pt</FontSize> </Style> <Position>RightCenter</Position> <ChartLegendTitle> <Caption /> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <TextAlign>Center</TextAlign> </Style> </ChartLegendTitle> <HeaderSeparatorColor>Black</HeaderSeparatorColor> <ColumnSeparatorColor>Black</ColumnSeparatorColor> </ChartLegend> </ChartLegends> <Palette>Pastel</Palette> <ChartBorderSkin> <Style> <BackgroundColor>Gray</BackgroundColor> <BackgroundGradientType>None</BackgroundGradientType> <Color>White</Color> </Style> </ChartBorderSkin> <ChartNoDataMessage Name="NoDataMessage"> <Caption>No Data Available</Caption> <Style> <BackgroundGradientType>None</BackgroundGradientType> <TextAlign>General</TextAlign> <VerticalAlign>Top</VerticalAlign> </Style> </ChartNoDataMessage> <DataSetName>YTD_Salary_Function_Query</DataSetName> <Height>3.11334in</Height> <Width>5.32291in</Width> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>White</BackgroundColor> <BackgroundGradientType>None</BackgroundGradientType> </Style> </Chart> </ReportItems> <Height>3.11334in</Height> <Style /> </Body> <Width>5.32291in</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> </DataSources> <DataSets> <DataSet Name="YTD_Salary_Function_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="GlCodeGlCategory"> <Value>=Parameters!GlCodeGlCategory.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitLocation"> <Value>=Parameters!OrgUnitLocation.Value</Value> </QueryParameter> <QueryParameter Name="UserId"> <Value>=Parameters!UserId.Value</Value> </QueryParameter> <QueryParameter Name="GlCodeHrTimeStatus"> <Value>=Parameters!GlCodeHrTimeStatus.Value</Value> </QueryParameter> <QueryParameter Name="OrgUnitFunction"> <Value>=Parameters!OrgUnitFunction.Value</Value> </QueryParameter> </QueryParameters> <CommandText>Select NON EMPTY ( [Measures].[Journal Amount] ) on Columns, NON EMPTY { [Org Unit].[Function Description].[Function Description].ALLMEMBERS } on rows FROM [Executive_Integrated_Financials] WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitFundCode) ,STRTOSET(@DateFiscalYear) ,STRTOSET(@GlCodeHrTimeStatus) ,STRTOSET(@GlCodeGlCategory) ,[Gl Code].[Gl Class Code].&[5] , [Gl Trans Detail].[Journal Grouping].&[Actuals] ,[Gl Code].[Hr Classification].&[Salary] , 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>Org Unit</DimensionName> <HierarchyName>Function Description</HierarchyName> <HierarchyUniqueName>[Org Unit].[Function Description]</HierarchyUniqueName> <LevelName>Function Description</LevelName> <UniqueName>[Org Unit].[Function Description].[Function Description]</UniqueName> </ID> <ItemCaption>Function Description</ItemCaption> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Journal Amount</MeasureName> <UniqueName>[Measures].[Journal Amount]</UniqueName> </ID> <ItemCaption>Journal Amount</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>Executive_Integrated_Financials</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>Select NON EMPTY ( [Measures].[Journal Amount] ) on Columns, NON EMPTY { [Org Unit].[Function Description].[Function Description].ALLMEMBERS } on rows FROM [Executive_Integrated_Financials] WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitFundCode) ,STRTOSET(@DateFiscalYear) ,STRTOSET(@GlCodeHrTimeStatus) ,STRTOSET(@GlCodeGlCategory) ,[Gl Code].[Gl Class Code].&[5] , [Gl Trans Detail].[Journal Grouping].&[Actuals] ,[Gl Code].[Hr Classification].&[Salary] , 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 [Executive_Integrated_Financials]</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 [Executive_Integrated_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitLocation</Name> <DefaultValues> <DefaultValue>[Org Unit].[Location Description].[All]</DefaultValue> </DefaultValues> <Caption>Location</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 [Executive_Integrated_Financials]</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 [Executive_Integrated_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> </ParameterDefinition> <ParameterDefinition> <Name>GlCodeGlCategory</Name> <DefaultValues> <DefaultValue>[Gl Code].[Gl Category].[All]</DefaultValue> </DefaultValues> <Caption>GlCodeGlCategory</Caption> <HierarchyUniqueName>[Gl Code].[Gl Category]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Gl Code].[Gl Category].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Gl Code].[Gl Category].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Gl Code].[Gl Category].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Gl Code].[Gl Category].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>GlCodeHrTimeStatus</Name> <DefaultValues> <DefaultValue>[Gl Code].[Hr Time Status].[All]</DefaultValue> </DefaultValues> <Caption>GlCodeHrTimeStatus</Caption> <HierarchyUniqueName>[Gl Code].[Hr Time Status]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Gl Code].[Hr Time Status].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>OrgUnitFunction</Name> <DefaultValues> <DefaultValue>[Org Unit].[Function Description].[All]</DefaultValue> </DefaultValues> <Caption>OrgUnitFunction</Caption> <HierarchyUniqueName>[Org Unit].[Function Description]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Function Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Function Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Function Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Function Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> </ParameterDefinitions> </Query> </QueryDefinition> </rd:DesignerState> </Query> <Fields> <Field Name="Function_Description"> <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="[Org Unit].[Function Description].[Function Description]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Journal_Amount"> <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].[Journal Amount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </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 [Executive_Integrated_Financials]</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="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>Executive_Integrated_Financials</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 [Executive_Integrated_Financials]</Statement> <ParameterDefinitions /> </Query> </QueryDefinition> </rd:DesignerState> <rd:AutoGenerated>true</rd:AutoGenerated> <rd:Hidden>true</rd:Hidden> </Query> <Fields> <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> </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="OrgUnitLocation"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Location Description].[All]</Value> </Values> </DefaultValue> <Prompt>Location</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="GlCodeGlCategory"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Gl Code].[Gl Category].[All]</Value> </Values> </DefaultValue> <Prompt>GlCodeGlCategory</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="GlCodeHrTimeStatus"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Gl Code].[Hr Time Status].[All]</Value> </Values> </DefaultValue> <Prompt>GlCodeHrTimeStatus</Prompt> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="OrgUnitFunction"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Org Unit].[Function Description].[All]</Value> </Values> </DefaultValue> <Prompt>OrgUnitFunction</Prompt> <MultiValue>true</MultiValue> </ReportParameter> </ReportParameters> <rd:ReportUnitType>Inch</rd:ReportUnitType> <rd:ReportID>ba2cb72b-2313-457d-8a5d-af4cb89bf676</rd:ReportID> </Report>