<?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].&amp;[5]
, [Gl Trans Detail].[Journal Grouping].&amp;[Actuals]
,[Gl Code].[Hr Classification].&amp;[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].&amp;[5]
, [Gl Trans Detail].[Journal Grouping].&amp;[Actuals]
,[Gl Code].[Hr Classification].&amp;[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].&amp;[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].&amp;[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>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;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]" /&gt;</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Journal_Amount">
          <DataField>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;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]" /&gt;</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>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /&gt;</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ParameterValue">
          <DataField>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /&gt;</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ParameterLevel">
          <DataField>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /&gt;</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].&amp;[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].&amp;["+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>