classification matrix.rdl

< SQL Server2005程序设计>

            </TableRow>
          </TableRows>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>1.375in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.125in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.625in</Width>
          </TableColumn>
        </TableColumns>
        <Height>1in</Height>
      </Table>
    </ReportItems>
    <Height>2in</Height>
  </Body>
  <rd:ReportID>96d657c2-18a4-4a17-bf47-d626f45b2c9c</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="CustomerProfitMining">
      <Query>
        <rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>
        <CommandText>SELECT
  t.[CustomerKey],
  t.[ProfitCategory],
  ([CustomerProfitCategory_DT].[Profit Category]) as [Predicted Profit Category]
From
  [CustomerProfitCategory_DT]
PREDICTION JOIN
  SHAPE {
  OPENQUERY([Adventure Works DW],
    'SELECT
      [CustomerKey],
      (Case
  When Profit &gt; 1077 Then ''High''
  Else ''Low''
End) AS [ProfitCategory],
      [MaritalStatus],
      [Gender],
      [IncomeGroup],
      [HasKidsAtHome],
      [EnglishEducation],
      [IsHomeOwner],
      [IsCarOwner],
      [CommuteDistance],
      [Region],
      [Age],
      [RecencyGroup],
      [NumProdGroup],
      [IsNewCustomer]
    FROM
      [dbo].[vCustomerProfitability]
    ORDER BY
      [CustomerKey]')}
  APPEND 
  ({OPENQUERY([Adventure Works DW],
    'SELECT
      [ProductCategory],
      [CustomerKey]
    FROM
      [dbo].[vCustomerPurchases]
    ORDER BY
      [CustomerKey]')}
    RELATE
      [CustomerKey] TO [CustomerKey])
    AS
      [vCustomerPurchases] AS t
ON
  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND
  [CustomerProfitCategory_DT].[Gender] = t.[Gender] AND
  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND
  [CustomerProfitCategory_DT].[Has Kids At Home] = t.[HasKidsAtHome] AND
  [CustomerProfitCategory_DT].[English Education] = t.[EnglishEducation] AND
  [CustomerProfitCategory_DT].[Is Home Owner] = t.[IsHomeOwner] AND
  [CustomerProfitCategory_DT].[Is Car Owner] = t.[IsCarOwner] AND
  [CustomerProfitCategory_DT].[Commute Distance] = t.[CommuteDistance] AND
  [CustomerProfitCategory_DT].[Region] = t.[Region] AND
  [CustomerProfitCategory_DT].[Age] = t.[Age] AND
  [CustomerProfitCategory_DT].[Recency Group] = t.[RecencyGroup] AND
  [CustomerProfitCategory_DT].[Num Prod Group] = t.[NumProdGroup] AND
  [CustomerProfitCategory_DT].[Is New Customer] = t.[IsNewCustomer] AND
  [CustomerProfitCategory_DT].[Profit Category] = t.[ProfitCategory] AND
  [CustomerProfitCategory_DT].[v Customer Purchases].[Product Category] = t.[vCustomerPurchases].[ProductCategory]</CommandText>
        <DataSourceName>CustomerProfitMining</DataSourceName>
        <rd:MdxQuery><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>DMX</CommandType><Type>Query</Type><QuerySpecification xsi:type="DMXQuerySpecification"><Select><Items><Item><ID xsi:type="Column"><ColumnName>CustomerKey</ColumnName></ID><ItemCaption>CustomerKey</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>ProfitCategory</ColumnName></ID><ItemCaption>ProfitCategory</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Predicted Profit Category</ColumnName></ID><ItemCaption>Predicted Profit Category</ItemCaption></Item></Items></Select><Data>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;DataminingQueryBuilderState xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
  &lt;SelectTablesControlState&gt;
    &lt;Tables&gt;
      &lt;SelectedTableInfo&gt;
        &lt;datasourceName&gt;Adventure Works DW&lt;/datasourceName&gt;
        &lt;dsvId&gt;CustomerProfitability&lt;/dsvId&gt;
        &lt;tableType&gt;View&lt;/tableType&gt;
        &lt;schemaName&gt;dbo&lt;/schemaName&gt;
        &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
        &lt;friendlyTableName&gt;vCustomerProfitability&lt;/friendlyTableName&gt;
      &lt;/SelectedTableInfo&gt;
      &lt;SelectedTableInfo&gt;
        &lt;datasourceName&gt;Adventure Works DW&lt;/datasourceName&gt;
        &lt;dsvId&gt;CustomerProfitability&lt;/dsvId&gt;
        &lt;tableType&gt;View&lt;/tableType&gt;
        &lt;schemaName&gt;dbo&lt;/schemaName&gt;
        &lt;tableName&gt;dbo_vCustomerPurchases&lt;/tableName&gt;
        &lt;friendlyTableName&gt;vCustomerPurchases&lt;/friendlyTableName&gt;
        &lt;relations&gt;
          &lt;CaseNestedTableRelation&gt;
            &lt;caseKeyColumnName&gt;
              &lt;string&gt;CustomerKey&lt;/string&gt;
            &lt;/caseKeyColumnName&gt;
            &lt;nestedKeyColumnName&gt;
              &lt;string&gt;CustomerKey&lt;/string&gt;
            &lt;/nestedKeyColumnName&gt;
            &lt;descriptions /&gt;
          &lt;/CaseNestedTableRelation&gt;
        &lt;/relations&gt;
      &lt;/SelectedTableInfo&gt;
    &lt;/Tables&gt;
  &lt;/SelectTablesControlState&gt;
  &lt;IsSingletonQuery&gt;false&lt;/IsSingletonQuery&gt;
  &lt;View&gt;Text&lt;/View&gt;
  &lt;QueryText&gt;SELECT
  t.[CustomerKey],
  t.[ProfitCategory],
  ([CustomerProfitCategory_DT].[Profit Category]) as [Predicted Profit Category]
From
  [CustomerProfitCategory_DT]
PREDICTION JOIN
  SHAPE {
  OPENQUERY([Adventure Works DW],
    'SELECT
      [CustomerKey],
      (Case
  When Profit &amp;gt; 1077 Then ''High''
  Else ''Low''
End) AS [ProfitCategory],
      [MaritalStatus],
      [Gender],
      [IncomeGroup],
      [HasKidsAtHome],
      [EnglishEducation],
      [IsHomeOwner],
      [IsCarOwner],
      [CommuteDistance],
      [Region],
      [Age],
      [RecencyGroup],
      [NumProdGroup],
      [IsNewCustomer]
    FROM
      [dbo].[vCustomerProfitability]
    ORDER BY
      [CustomerKey]')}
  APPEND 
  ({OPENQUERY([Adventure Works DW],
    'SELECT
      [ProductCategory],
      [CustomerKey]
    FROM
      [dbo].[vCustomerPurchases]
    ORDER BY
      [CustomerKey]')}
    RELATE
      [CustomerKey] TO [CustomerKey])
    AS
      [vCustomerPurchases] AS t
ON
  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND
  [CustomerProfitCategory_DT].[Gender] = t.[Gender] AND
  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND
  [CustomerProfitCategory_DT].[Has Kids At Home] = t.[HasKidsAtHome] AND
  [CustomerProfitCategory_DT].[English Education] = t.[EnglishEducation] AND
  [CustomerProfitCategory_DT].[Is Home Owner] = t.[IsHomeOwner] AND
  [CustomerProfitCategory_DT].[Is Car Owner] = t.[IsCarOwner] AND
  [CustomerProfitCategory_DT].[Commute Distance] = t.[CommuteDistance] AND
  [CustomerProfitCategory_DT].[Region] = t.[Region] AND
  [CustomerProfitCategory_DT].[Age] = t.[Age] AND
  [CustomerProfitCategory_DT].[Recency Group] = t.[RecencyGroup] AND
  [CustomerProfitCategory_DT].[Num Prod Group] = t.[NumProdGroup] AND
  [CustomerProfitCategory_DT].[Is New Customer] = t.[IsNewCustomer] AND
  [CustomerProfitCategory_DT].[Profit Category] = t.[ProfitCategory] AND
  [CustomerProfitCategory_DT].[v Customer Purchases].[Product Category] = t.[vCustomerPurchases].[ProductCategory]&lt;/QueryText&gt;
  &lt;DatabaseId&gt;Chapter20&lt;/DatabaseId&gt;
  &lt;MiningStructureId&gt;CustomerProfitCategory&lt;/MiningStructureId&gt;
  &lt;MiningModelId&gt;CustomerProfitCategory_DT&lt;/MiningModelId&gt;
  &lt;ColumnMappings&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Marital Status&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;MaritalStatus&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Gender&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;Gender&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Income Group&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;IncomeGroup&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Has Kids At Home&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;HasKidsAtHome&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;English Education&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;EnglishEducation&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Is Home Owner&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;IsHomeOwner&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Is Car Owner&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;IsCarOwner&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Commute Distance&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;CommuteDistance&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Region&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;Region&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Age&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;Age&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Recency Group&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;RecencyGroup&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Num Prod Group&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;NumProdGroup&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Is New Customer&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;IsNewCustomer&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;miningModelColumnId&gt;Profit Category&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerProfitability&lt;/tableName&gt;
      &lt;dataColumnName&gt;ProfitCategory&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
    &lt;ColumnMapping&gt;
      &lt;tableMiningModelColumnId&gt;v Customer Purchases&lt;/tableMiningModelColumnId&gt;
      &lt;miningModelColumnId&gt;Product Category&lt;/miningModelColumnId&gt;
      &lt;tableName&gt;dbo_vCustomerPurchases&lt;/tableName&gt;
      &lt;dataColumnName&gt;ProductCategory&lt;/dataColumnName&gt;
    &lt;/ColumnMapping&gt;
  &lt;/ColumnMappings&gt;
  &lt;GridRows /&gt;
&lt;/DataminingQueryBuilderState&gt;</Data></QuerySpecification><Query><Statement>SELECT
  t.[CustomerKey],
  t.[ProfitCategory],
  ([CustomerProfitCategory_DT].[Profit Category]) as [Predicted Profit Category]
From
  [CustomerProfitCategory_DT]
PREDICTION JOIN
  SHAPE {
  OPENQUERY([Adventure Works DW],
    'SELECT
      [CustomerKey],
      (Case
  When Profit &gt; 1077 Then ''High''
  Else ''Low''
End) AS [ProfitCategory],
      [MaritalStatus],
      [Gender],
      [IncomeGroup],
      [HasKidsAtHome],
      [EnglishEducation],
      [IsHomeOwner],
      [IsCarOwner],
      [CommuteDistance],
      [Region],
      [Age],
      [RecencyGroup],
      [NumProdGroup],
      [IsNewCustomer]
    FROM
      [dbo].[vCustomerProfitability]
    ORDER BY
      [CustomerKey]')}
  APPEND 
  ({OPENQUERY([Adventure Works DW],
    'SELECT
      [ProductCategory],
      [CustomerKey]
    FROM
      [dbo].[vCustomerPurchases]
    ORDER BY
      [CustomerKey]')}
    RELATE
      [CustomerKey] TO [CustomerKey])
    AS
      [vCustomerPurchases] AS t
ON
  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND
  [CustomerProfitCategory_DT].[Gender] = t.[Gender] AND
  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND
  [CustomerProfitCategory_DT].[Has Kids At Home] = t.[HasKidsAtHome] AND
  [CustomerProfitCategory_DT].[English Education] = t.[EnglishEducation] AND
  [CustomerProfitCategory_DT].[Is Home Owner] = t.[IsHomeOwner] AND
  [CustomerProfitCategory_DT].[Is Car Owner] = t.[IsCarOwner] AND
  [CustomerProfitCategory_DT].[Commute Distance] = t.[CommuteDistance] AND
  [CustomerProfitCategory_DT].[Region] = t.[Region] AND
  [CustomerProfitCategory_DT].[Age] = t.[Age] AND
  [CustomerProfitCategory_DT].[Recency Group] = t.[RecencyGroup] AND
  [CustomerProfitCategory_DT].[Num Prod Group] = t.[NumProdGroup] AND
  [CustomerProfitCategory_DT].[Is New Customer] = t.[IsNewCustomer] AND
  [CustomerProfitCategory_DT].[Profit Category] = t.[ProfitCategory] AND
  [CustomerProfitCategory_DT].[v Customer Purchases].[Product Category] = t.[vCustomerPurchases].[ProductCategory]</Statement><ParameterDefinitions /></Query></QueryDefinition></rd:MdxQuery>
      </Query>
      <Fields>
        <Field Name="CustomerKey">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>CustomerKey</DataField>
        </Field>
        <Field Name="ProfitCategory">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>ProfitCategory</DataField>
        </Field>
        <Field Name="Predicted_Profit_Category">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Predicted Profit Category</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>6.50001in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>