📄 classificationmatrix.rdl

📁 < SQL Server2005程序设计>
💻 RDL
📖 第 1 页 / 共 2 页
字号:
上一页 12
From  [CustomerProfitCategory_DT]PREDICTION JOIN  SHAPE {  OPENQUERY([Adventure Works DW],    'SELECT      [CustomerKey],      (Case  When Profit&gt;1077 Then ''High''  Else ''Low''End) AS [ProfitCategory],      [Region],      [Age],      [IncomeGroup],      [MaritalStatus],      [Gender],      [HasKidsAtHome],      [EnglishEducation],      [IsHomeOwner],      [IsCarOwner],      [CommuteDistance],      [RecencyGroup],      [NumProdGroup],      [IsNewCustomer]    FROM      [dbo].[TestingCustomers]    ORDER BY      [CustomerKey]')}  APPEND   ({OPENQUERY([Adventure Works DW],    'SELECT      [ProductCategory],      [CustomerKey]    FROM      [dbo].[vCustomerPurchases]    ORDER BY      [CustomerKey]')}    RELATE      [CustomerKey] TO [CustomerKey])    AS      [vCustomerPurchases] AS tON  [CustomerProfitCategory_DT].[Region] = t.[Region] AND  [CustomerProfitCategory_DT].[Age] = t.[Age] AND  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND  [CustomerProfitCategory_DT].[Gender] = t.[Gender] 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].[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>Chapter20</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><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;Adventure Works DW&lt;/dsvId&gt;        &lt;tableType&gt;Table&lt;/tableType&gt;        &lt;schemaName&gt;dbo&lt;/schemaName&gt;        &lt;tableName&gt;dbo_TestingCustomers&lt;/tableName&gt;        &lt;friendlyTableName&gt;TestingCustomers&lt;/friendlyTableName&gt;      &lt;/SelectedTableInfo&gt;      &lt;SelectedTableInfo&gt;        &lt;datasourceName&gt;Adventure Works DW&lt;/datasourceName&gt;        &lt;dsvId&gt;Adventure Works DW&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],      [Region],      [Age],      [IncomeGroup],      [MaritalStatus],      [Gender],      [HasKidsAtHome],      [EnglishEducation],      [IsHomeOwner],      [IsCarOwner],      [CommuteDistance],      [RecencyGroup],      [NumProdGroup],      [IsNewCustomer]    FROM      [dbo].[TestingCustomers]    ORDER BY      [CustomerKey]')}  APPEND   ({OPENQUERY([Adventure Works DW],    'SELECT      [ProductCategory],      [CustomerKey]    FROM      [dbo].[vCustomerPurchases]    ORDER BY      [CustomerKey]')}    RELATE      [CustomerKey] TO [CustomerKey])    AS      [vCustomerPurchases] AS tON  [CustomerProfitCategory_DT].[Region] = t.[Region] AND  [CustomerProfitCategory_DT].[Age] = t.[Age] AND  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND  [CustomerProfitCategory_DT].[Gender] = t.[Gender] 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].[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;CustomerProfitMining&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;Region&lt;/miningModelColumnId&gt;      &lt;tableName&gt;dbo_TestingCustomers&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_TestingCustomers&lt;/tableName&gt;      &lt;dataColumnName&gt;Age&lt;/dataColumnName&gt;    &lt;/ColumnMapping&gt;    &lt;ColumnMapping&gt;      &lt;miningModelColumnId&gt;Income Group&lt;/miningModelColumnId&gt;      &lt;tableName&gt;dbo_TestingCustomers&lt;/tableName&gt;      &lt;dataColumnName&gt;IncomeGroup&lt;/dataColumnName&gt;    &lt;/ColumnMapping&gt;    &lt;ColumnMapping&gt;      &lt;miningModelColumnId&gt;Marital Status&lt;/miningModelColumnId&gt;      &lt;tableName&gt;dbo_TestingCustomers&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_TestingCustomers&lt;/tableName&gt;      &lt;dataColumnName&gt;Gender&lt;/dataColumnName&gt;    &lt;/ColumnMapping&gt;    &lt;ColumnMapping&gt;      &lt;miningModelColumnId&gt;Has Kids At Home&lt;/miningModelColumnId&gt;      &lt;tableName&gt;dbo_TestingCustomers&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_TestingCustomers&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_TestingCustomers&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_TestingCustomers&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_TestingCustomers&lt;/tableName&gt;      &lt;dataColumnName&gt;CommuteDistance&lt;/dataColumnName&gt;    &lt;/ColumnMapping&gt;    &lt;ColumnMapping&gt;      &lt;miningModelColumnId&gt;Recency Group&lt;/miningModelColumnId&gt;      &lt;tableName&gt;dbo_TestingCustomers&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_TestingCustomers&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_TestingCustomers&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_TestingCustomers&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;GridRow&gt;      &lt;type&gt;DataColumn&lt;/type&gt;      &lt;parentType&gt;DataTable&lt;/parentType&gt;      &lt;parentId&gt;dbo_TestingCustomers&lt;/parentId&gt;      &lt;field&gt;CustomerKey&lt;/field&gt;      &lt;alias /&gt;      &lt;show&gt;true&lt;/show&gt;      &lt;group /&gt;      &lt;andOr /&gt;      &lt;criteria /&gt;    &lt;/GridRow&gt;    &lt;GridRow&gt;      &lt;type&gt;DataColumn&lt;/type&gt;      &lt;parentType&gt;DataTable&lt;/parentType&gt;      &lt;parentId&gt;dbo_TestingCustomers&lt;/parentId&gt;      &lt;field&gt;ProfitCategory&lt;/field&gt;      &lt;alias /&gt;      &lt;show&gt;true&lt;/show&gt;      &lt;group /&gt;      &lt;andOr /&gt;      &lt;criteria /&gt;    &lt;/GridRow&gt;    &lt;GridRow&gt;      &lt;type&gt;MiningColumn&lt;/type&gt;      &lt;parentType&gt;MiningModel&lt;/parentType&gt;      &lt;parentId&gt;CustomerProfitCategory_DT&lt;/parentId&gt;      &lt;field&gt;Profit Category&lt;/field&gt;      &lt;alias&gt;Predicted Profit Category&lt;/alias&gt;      &lt;show&gt;true&lt;/show&gt;      &lt;group /&gt;      &lt;andOr /&gt;      &lt;criteria /&gt;    &lt;/GridRow&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],      [Region],      [Age],      [IncomeGroup],      [MaritalStatus],      [Gender],      [HasKidsAtHome],      [EnglishEducation],      [IsHomeOwner],      [IsCarOwner],      [CommuteDistance],      [RecencyGroup],      [NumProdGroup],      [IsNewCustomer]    FROM      [dbo].[TestingCustomers]    ORDER BY      [CustomerKey]')}  APPEND   ({OPENQUERY([Adventure Works DW],    'SELECT      [ProductCategory],      [CustomerKey]    FROM      [dbo].[vCustomerPurchases]    ORDER BY      [CustomerKey]')}    RELATE      [CustomerKey] TO [CustomerKey])    AS      [vCustomerPurchases] AS tON  [CustomerProfitCategory_DT].[Region] = t.[Region] AND  [CustomerProfitCategory_DT].[Age] = t.[Age] AND  [CustomerProfitCategory_DT].[Income Group] = t.[IncomeGroup] AND  [CustomerProfitCategory_DT].[Marital Status] = t.[MaritalStatus] AND  [CustomerProfitCategory_DT].[Gender] = t.[Gender] 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].[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>8.66668in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -