report3.rdl

< SQL Server2005程序设计>

                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <ZIndex>15</ZIndex>
                      <Style>
                        <TextAlign>Right</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Profit</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox11">
                      <rd:DefaultName>textbox11</rd:DefaultName>
                      <ZIndex>14</ZIndex>
                      <Style>
                        <TextAlign>Left</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>CLUSTER</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox5">
                      <rd:DefaultName>textbox5</rd:DefaultName>
                      <ZIndex>13</ZIndex>
                      <Style>
                        <TextAlign>Right</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>DISTANCE</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox14">
                      <rd:DefaultName>textbox14</rd:DefaultName>
                      <ZIndex>12</ZIndex>
                      <Style>
                        <TextAlign>Right</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>PROBABILITY</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>1.75in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.625in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.375in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.625in</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.5in</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.625in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.75in</Height>
      </Table>
    </ReportItems>
    <Height>2in</Height>
  </Body>
  <rd:ReportID>d64606c3-61b5-4557-a0b8-d6f1d383456a</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="dsMining">
      <Query>
        <rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>
        <CommandText>--6. Cluster assignment and probability distribution for 250 customers
--Using FLATTENED keyword
SELECT   FLATTENED TOP 250 t.FirstName, t.LastName, t.Profit
         , ClusterProbability('Cluster 5'), PredictHistogram(Cluster())
FROM     CustomerProfitCategory_CL5
PREDICTION JOIN
	SHAPE {OpenQuery([Adventure Works DW],
           'SELECT     c.FirstName, c.LastName, tc.*
            FROM       TestingCustomers tc
            INNER JOIN dimCustomer c ON
                       tc.CustomerKey = c.CustomerKey
            ORDER BY   tc.CustomerKey')
          }
	APPEND({OPENQUERY([Adventure Works DW],
            'SELECT   CustomerKey, ProductCategory
             FROM     vCustomerPurchases
             ORDER BY CustomerKey')
            }
            RELATE CustomerKey To CustomerKey
           )
           AS PurchaseCategory 
    AS t
    ON t.Age = CustomerProfitCategory_CL5.Age AND
       t.CommuteDistance = CustomerProfitCategory_CL5.[Commute Distance] AND
       t.EnglishEducation = CustomerProfitCategory_CL5.[English Education] AND
       t.Gender = CustomerProfitCategory_CL5.Gender AND
       t.HasKidsAtHome = CustomerProfitCategory_CL5.[Has Kids At Home] AND
       t.IncomeGroup = CustomerProfitCategory_CL5.[Income Group] AND
       t.IsCarOwner = CustomerProfitCategory_CL5.[Is Car Owner] AND
       t.IsHomeOwner = CustomerProfitCategory_CL5.[Is Home Owner] AND
       t.IsNewCustomer = CustomerProfitCategory_CL5.[Is New Customer] AND
       t.MaritalStatus = CustomerProfitCategory_CL5.[Marital Status] AND
       t.NumProdGroup = CustomerProfitCategory_CL5.[Num Prod Group] AND
       t.RecencyGroup = CustomerProfitCategory_CL5.[Recency Group] AND 
       t.Region = CustomerProfitCategory_CL5.Region AND
       t.PurchaseCategory.ProductCategory = CustomerProfitCategory_CL5.[v Customer Purchases].[Product Category]
ORDER BY ClusterProbability('Cluster 5') DESC</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><Type>Query</Type><QuerySpecification xsi:type="DMXQuerySpecification"><Select><Items><Item><ID xsi:type="Column"><ColumnName>FirstName</ColumnName></ID><ItemCaption>FirstName</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>LastName</ColumnName></ID><ItemCaption>LastName</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Profit</ColumnName></ID><ItemCaption>Profit</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Expression</ColumnName></ID><ItemCaption>Expression</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Expression.$CLUSTER</ColumnName></ID><ItemCaption>Expression.$CLUSTER</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Expression.$DISTANCE</ColumnName></ID><ItemCaption>Expression.$DISTANCE</ItemCaption></Item><Item><ID xsi:type="Column"><ColumnName>Expression.$PROBABILITY</ColumnName></ID><ItemCaption>Expression.$PROBABILITY</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;/SelectTablesControlState&gt;
  &lt;IsSingletonQuery&gt;false&lt;/IsSingletonQuery&gt;
  &lt;View&gt;Text&lt;/View&gt;
  &lt;QueryText&gt;--6. Cluster assignment and probability distribution for 250 customers
--Using FLATTENED keyword
SELECT   FLATTENED TOP 250 t.FirstName, t.LastName, t.Profit
         , ClusterProbability('Cluster 5'), PredictHistogram(Cluster())
FROM     CustomerProfitCategory_CL5
PREDICTION JOIN
	SHAPE {OpenQuery([Adventure Works DW],
           'SELECT     c.FirstName, c.LastName, tc.*
            FROM       TestingCustomers tc
            INNER JOIN dimCustomer c ON
                       tc.CustomerKey = c.CustomerKey
            ORDER BY   tc.CustomerKey')
          }
	APPEND({OPENQUERY([Adventure Works DW],
            'SELECT   CustomerKey, ProductCategory
             FROM     vCustomerPurchases
             ORDER BY CustomerKey')
            }
            RELATE CustomerKey To CustomerKey
           )
           AS PurchaseCategory 
    AS t
    ON t.Age = CustomerProfitCategory_CL5.Age AND
       t.CommuteDistance = CustomerProfitCategory_CL5.[Commute Distance] AND
       t.EnglishEducation = CustomerProfitCategory_CL5.[English Education] AND
       t.Gender = CustomerProfitCategory_CL5.Gender AND
       t.HasKidsAtHome = CustomerProfitCategory_CL5.[Has Kids At Home] AND
       t.IncomeGroup = CustomerProfitCategory_CL5.[Income Group] AND
       t.IsCarOwner = CustomerProfitCategory_CL5.[Is Car Owner] AND
       t.IsHomeOwner = CustomerProfitCategory_CL5.[Is Home Owner] AND
       t.IsNewCustomer = CustomerProfitCategory_CL5.[Is New Customer] AND
       t.MaritalStatus = CustomerProfitCategory_CL5.[Marital Status] AND
       t.NumProdGroup = CustomerProfitCategory_CL5.[Num Prod Group] AND
       t.RecencyGroup = CustomerProfitCategory_CL5.[Recency Group] AND 
       t.Region = CustomerProfitCategory_CL5.Region AND
       t.PurchaseCategory.ProductCategory = CustomerProfitCategory_CL5.[v Customer Purchases].[Product Category]
ORDER BY ClusterProbability('Cluster 5') DESC&lt;/QueryText&gt;
  &lt;DatabaseId /&gt;
  &lt;MiningStructureId /&gt;
  &lt;MiningModelId /&gt;
  &lt;ColumnMappings /&gt;
  &lt;GridRows /&gt;
&lt;/DataminingQueryBuilderState&gt;</Data></QuerySpecification><Query><Statement>--6. Cluster assignment and probability distribution for 250 customers
--Using FLATTENED keyword
SELECT   FLATTENED TOP 250 t.FirstName, t.LastName, t.Profit
         , ClusterProbability('Cluster 5'), PredictHistogram(Cluster())
FROM     CustomerProfitCategory_CL5
PREDICTION JOIN
	SHAPE {OpenQuery([Adventure Works DW],
           'SELECT     c.FirstName, c.LastName, tc.*
            FROM       TestingCustomers tc
            INNER JOIN dimCustomer c ON
                       tc.CustomerKey = c.CustomerKey
            ORDER BY   tc.CustomerKey')
          }
	APPEND({OPENQUERY([Adventure Works DW],
            'SELECT   CustomerKey, ProductCategory
             FROM     vCustomerPurchases
             ORDER BY CustomerKey')
            }
            RELATE CustomerKey To CustomerKey
           )
           AS PurchaseCategory 
    AS t
    ON t.Age = CustomerProfitCategory_CL5.Age AND
       t.CommuteDistance = CustomerProfitCategory_CL5.[Commute Distance] AND
       t.EnglishEducation = CustomerProfitCategory_CL5.[English Education] AND
       t.Gender = CustomerProfitCategory_CL5.Gender AND
       t.HasKidsAtHome = CustomerProfitCategory_CL5.[Has Kids At Home] AND
       t.IncomeGroup = CustomerProfitCategory_CL5.[Income Group] AND
       t.IsCarOwner = CustomerProfitCategory_CL5.[Is Car Owner] AND
       t.IsHomeOwner = CustomerProfitCategory_CL5.[Is Home Owner] AND
       t.IsNewCustomer = CustomerProfitCategory_CL5.[Is New Customer] AND
       t.MaritalStatus = CustomerProfitCategory_CL5.[Marital Status] AND
       t.NumProdGroup = CustomerProfitCategory_CL5.[Num Prod Group] AND
       t.RecencyGroup = CustomerProfitCategory_CL5.[Recency Group] AND 
       t.Region = CustomerProfitCategory_CL5.Region AND
       t.PurchaseCategory.ProductCategory = CustomerProfitCategory_CL5.[v Customer Purchases].[Product Category]
ORDER BY ClusterProbability('Cluster 5') DESC</Statement><ParameterDefinitions /></Query></QueryDefinition></rd:MdxQuery>
      </Query>
      <Fields>
        <Field Name="FirstName">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>FirstName</DataField>
        </Field>
        <Field Name="LastName">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>LastName</DataField>
        </Field>
        <Field Name="Profit">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Profit</DataField>
        </Field>
        <Field Name="Expression">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Expression</DataField>
        </Field>
        <Field Name="Expression__CLUSTER">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Expression.$CLUSTER</DataField>
        </Field>
        <Field Name="Expression__DISTANCE">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Expression.$DISTANCE</DataField>
        </Field>
        <Field Name="Expression__PROBABILITY">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Expression.$PROBABILITY</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>11.75in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>