I have a problem to sum 2 or more matrixes. Each matrix is in a table grouped by date. I want the total from rowgroups in the different matrixes.
To be more specific. I have 1 table with a matrix in column1, column2 and so on. I want the total from rowgroup1(e.g 1st of february), rowgroup2(e.g 2nd of february). With other words I want the total of Column1-Rowgroup1+Column2-Rowgroup1.
Hope somebody know how to do this
Here is an example of what I'm trying to do(u need to have the AdventureWorks OLAP database installed):
< xml version="1.0" encoding="utf-8" >
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="Adworks_PC053">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Source=pc053;Initial Catalog="Adventure Works DW Standard Edition"</ConnectString>
<DataProvider>OLEDB-MD</DataProvider>
</ConnectionProperties>
<rdataSourceID>22909a12-66e9-44e4-95db-91dfe8271ada</rdataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rdnapToGrid>true</rdnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<List Name="list1">
<Left>0.25cm</Left>
<ReportItems>
<Table Name="table2">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Matrix Name="matrix16">
<MatrixColumns>
<MatrixColumn>
<Width>1.92031cm</Width>
</MatrixColumn>
</MatrixColumns>
<RowGroupings>
<RowGrouping>
<Width>2.32969cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox85">
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>7pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox91">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Sorting>
<SortBy>
<SortExpression>=Fields!Date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Grouping Name="matrix16_RowGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Date.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="City">
<rdefaultName>City</rdefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!City.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix16_City">
<GroupExpressions>
<GroupExpression>=Fields!City.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.93498cm</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>Data_WareHouse_Cube</DataSetName>
<ZIndex>2</ZIndex>
<Corner>
<ReportItems>
<Textbox Name="textbox93">
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</Corner>
<MatrixRows>
<MatrixRow>
<Height>0.53251cm</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox94">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>### ### ### ###</Format>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=iif(Sum(Fields!Internet_Sales_Amount.Value)>0,Sum(Fields!Internet_Sales_Amount.Value),"0")</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Matrix Name="matrix17">
<MatrixColumns>
<MatrixColumn>
<Width>1.91137cm</Width>
</MatrixColumn>
</MatrixColumns>
<RowGroupings>
<RowGrouping>
<Width>0.07937cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox95">
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<ToggleImage>
<InitialState>true</InitialState>
</ToggleImage>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox96">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Sorting>
<SortBy>
<SortExpression>=Fields!Date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Grouping Name="matrix17_RowGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Date.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="Sales_Territory_Country">
<rdefaultName>Sales_Territory_Country</rdefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Sales_Territory_Country.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix17_Sales_Territory_Country">
<GroupExpressions>
<GroupExpression>=Fields!Sales_Territory_Country.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.93498cm</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>Data_WareHouse_Cube</DataSetName>
<ZIndex>1</ZIndex>
<Corner>
<ReportItems>
<Textbox Name="textbox98">
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</Corner>
<MatrixRows>
<MatrixRow>
<Height>0.53251cm</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox99">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>### ### ### ###</Format>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=iif(Sum(Fields!Internet_Sales_Amount.Value)>0,Sum(Fields!Internet_Sales_Amount.Value),"0")</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>3.36681cm</Width>
</MatrixColumn>
</MatrixColumns>
<RowGroupings>
<RowGrouping>
<Width>0.13981cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox4">
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<ToggleImage>
<InitialState>true</InitialState>
</ToggleImage>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Sorting>
<SortBy>
<SortExpression>=Fields!Date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Grouping Name="matrix1_RowGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Date.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="textbox6">
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>#60759b</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>="Sum 2 matrixes Albington+Australia"</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_ColumnGroup1">
<GroupExpressions>
<GroupExpression>=""</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.93498cm</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>Data_WareHouse_Cube</DataSetName>
<Corner>
<ReportItems>
<Textbox Name="textbox7">
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</Corner>
<MatrixRows>
<MatrixRow>
<Height>0.53251cm</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox8">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>### ### ### ###</Format>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=""</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
</TableCell>
</TableCells>
<Height>2cm</Height>
</TableRow>
</TableRows>
</Footer>
<DataSetName>Data_WareHouse_Cube</DataSetName>
<Top>0.18254cm</Top>
<Width>9.75cm</Width>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox56">
<rdefaultName>textbox56</rdefaultName>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox57">
<rdefaultName>textbox57</rdefaultName>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rdefaultName>textbox2</rdefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>4.25cm</Width>
</TableColumn>
<TableColumn>
<Width>2cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
</TableColumns>
<Height>2.63492cm</Height>
</Table>
</ReportItems>
<DataSetName>Adworks_PC053</DataSetName>
<Top>1.25cm</Top>
<ZIndex>1</ZIndex>
<Grouping Name="list1_Details_Group">
<GroupExpressions>
<GroupExpression>=""</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>3cm</Height>
</List>
<Textbox Name="textbox1">
<rdefaultName>textbox1</rdefaultName>
<Width>12.69841cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>18pt</FontSize>
<Color>#1c3a70</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.8381cm</Height>
<Value>TestExample AdWorks</Value>
</Textbox>
</ReportItems>
<Height>11cm</Height>
</Body>
<rd:ReportID>5e2dbee6-9e12-44b8-b426-273749aecb87</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="Adworks_PC053">
<Query>
<rduppressAutoUpdate>true</rduppressAutoUpdate>
<rdesignerState><QueryDefinition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"><CommandType>MDX</CommandType><QuerySpecification xsi:type="MDXQuerySpecification"><Select><Items><Item><ID xsi:type="Level"><DimensionName>Date</DimensionName><HierarchyName>Date</HierarchyName><HierarchyUniqueName>[Date].[Date]</HierarchyUniqueName><LevelName>Date</LevelName><UniqueName>[Date].[Date].[Date]</UniqueName></ID><ItemCaption>Date</ItemCaption><UniqueName>true</UniqueName></Item><Item><ID xsi:type="Level"><DimensionName>Date</DimensionName><HierarchyName>Day of Year</HierarchyName><HierarchyUniqueName>[Date].[Day of Year]</HierarchyUniqueName><LevelName>Day of Year</LevelName><UniqueName>[Date].[Day of Year].[Day of Year]</UniqueName></ID><ItemCaption>Day of Year</ItemCaption><UniqueName>true</UniqueName></Item><Item><ID xsi:type="Level"><DimensionName>Sales Territory</DimensionName><HierarchyName>Sales Territory Country</HierarchyName><HierarchyUniqueName>[Sales Territory].[Sales Territory Country]</HierarchyUniqueName><LevelName>Sales Territory Country</LevelName><UniqueName>[Sales Territory].[Sales Territory Country].[Sales Territory Country]</UniqueName></ID><ItemCaption>Sales Territory Country</ItemCaption><UniqueName>true</UniqueName></Item><Item><ID xsi:type="Level"><DimensionName>Geography</DimensionName><HierarchyName>City</HierarchyName><HierarchyUniqueName>[Geography].[City]</HierarchyUniqueName><LevelName>City</LevelName><UniqueName>[Geography].[City].[City]</UniqueName></ID><ItemCaption>City</ItemCaption><UniqueName>true</UniqueName></Item><Item><ID xsi:type="Level"><DimensionName>Product</DimensionName><HierarchyName>Category</HierarchyName><HierarchyUniqueName>[Product].[Category]</HierarchyUniqueName><LevelName>Category</LevelName><UniqueName>[Product].[Category].[Category]</UniqueName></ID><ItemCaption>Category</ItemCaption><UniqueName>true</UniqueName></Item><Item><ID xsi:type="Measure"><MeasureName>Internet Sales Amount</MeasureName><UniqueName>[Measures].[Internet Sales Amount]</UniqueName></ID><ItemCaption>Internet Sales Amount</ItemCaption><BackColor>true</BackColor><ForeColor>true</ForeColor><FontFamily>true</FontFamily><FontSize>true</FontSize><FontWeight>true</FontWeight><FontStyle>true</FontStyle><FontDecoration>true</FontDecoration><FormattedValue>true</FormattedValue><FormatString>true</FormatString></Item></Items></Select><From>Adventure Works</From><Filter><FilterItems><FilterItem><HierarchyUniqueName>[Date].[Calendar Year]</HierarchyUniqueName><Condition xsi:type="EqualTo"><Members><Member><MemberUniqueName>[Date].[Calendar Year].&[2004]</MemberUniqueName></Member></Members></Condition></FilterItem><FilterItem><HierarchyUniqueName>[Date].[Month of Year]</HierarchyUniqueName><Condition xsi:type="EqualTo"><Members><Member><MemberUniqueName>[Date].[Month of Year].&[2]</MemberUniqueName></Member></Members></Condition></FilterItem><FilterItem><HierarchyUniqueName>[Geography].[City]</HierarchyUniqueName><Condition xsi:type="EqualTo"><Members><Member><MemberUniqueName>[Geography].[City].&[Albany]&[OR]</MemberUniqueName></Member><Member><MemberUniqueName>[Geography].[City].&[Abingdon]&[ENG]</MemberUniqueName></Member></Members></Condition></FilterItem></FilterItems></Filter><Calculations /><Aggregates /><QueryProperties /></QuerySpecification><Query><Statement> SELECT NON EMPTY { [Measures].[Internet Sales Amount] } ON COLUMNS, NON EMPTY { ([Date].[Date].[Date].ALLMEMBERS * [Date].[Day of Year].[Day of Year].ALLMEMBERS * [Sales Territory].[Sales Territory Country].[Sales Territory Country].ALLMEMBERS * [Geography].[City].[City].ALLMEMBERS * [Product].[Category].[Category].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Geography].[City].&[Albany]&[OR], [Geography].[City].&[Abingdon]&[ENG] } ) ON COLUMNS FROM ( SELECT ( { [Date].[Month of Year].&[2] } ) ON COLUMNS FROM ( SELECT ( { [Date].[Calendar Year].&[2004] } ) ON COLUMNS FROM [Adventure Works]))) WHERE ( [Date].[Calendar Year].&[2004], [Date].[Month of Year].&[2] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</Statement><ParameterDefinitions /></Query></QueryDefinition></rdesignerState>
<CommandText> SELECT NON EMPTY { [Measures].[Internet Sales Amount] } ON COLUMNS, NON EMPTY { ([Date].[Date].[Date].ALLMEMBERS * [Date].[Day of Year].[Day of Year].ALLMEMBERS * [Sales Territory].[Sales Territory Country].[Sales Territory Country].ALLMEMBERS * [Geography].[City].[City].ALLMEMBERS * [Product].[Category].[Category].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Geography].[City].&[Albany]&[OR], [Geography].[City].&[Abingdon]&[ENG] } ) ON COLUMNS FROM ( SELECT ( { [Date].[Month of Year].&[2] } ) ON COLUMNS FROM ( SELECT ( { [Date].[Calendar Year].&[2004] } ) ON COLUMNS FROM [Adventure Works]))) WHERE ( [Date].[Calendar Year].&[2004], [Date].[Month of Year].&[2] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</CommandText>
<DataSourceName>Adworks_PC053</DataSourceName>
</Query>
<Fields>
<Field Name="Date">
<rd:TypeName>System.String</rd:TypeName>
<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].[Date].[Date]" /></DataField>
</Field>
<Field Name="Day_of_Year">
<rd:TypeName>System.String</rd:TypeName>
<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].[Day of Year].[Day of Year]" /></DataField>
</Field>
<Field Name="Sales_Territory_Country">
<rd:TypeName>System.String</rd:TypeName>
<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="[Sales Territory].[Sales Territory Country].[Sales Territory Country]" /></DataField>
</Field>
<Field Name="City">
<rd:TypeName>System.String</rd:TypeName>
<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="[Geography].[City].[City]" /></DataField>
</Field>
<Field Name="Category">
<rd:TypeName>System.String</rd:TypeName>
<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="[Product].[Category].[Category]" /></DataField>
</Field>
<Field Name="Internet_Sales_Amount">
<rd:TypeName>System.Int32</rd:TypeName>
<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].[Internet Sales Amount]" /></DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>28.92646cm</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>