aworks.asdatabase

SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页 数： 383 出 版 社： 电子工业

            <AttributeRelationship>
              <AttributeID>Safety Stock Level</AttributeID>
              <Name>Safety Stock Level</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Reorder Point</AttributeID>
              <Name>Reorder Point</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>List Price</AttributeID>
              <Name>List Price</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Size</AttributeID>
              <Name>Size</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Weight</AttributeID>
              <Name>Weight</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Days To Manufacture</AttributeID>
              <Name>Days To Manufacture</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Product Line</AttributeID>
              <Name>Product Line</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Dealer Price</AttributeID>
              <Name>Dealer Price</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Class</AttributeID>
              <Name>Class</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Style</AttributeID>
              <Name>Style</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Model Name</AttributeID>
              <Name>Model Name</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Start Date</AttributeID>
              <Name>Start Date</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>End Date</AttributeID>
              <Name>End Date</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Status</AttributeID>
              <Name>Status</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Standard Cost</AttributeID>
              <Name>Standard Cost</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>产品线全名</AttributeID>
              <Name>产品线全名</Name>
            </AttributeRelationship>
          </AttributeRelationships>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>FilteredList</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Product Subcategory Key</ID>
          <Name>Product Subcategory Key</Name>
          <EstimatedCount>38</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>ProductSubcategoryKey</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <Translations>
            <Translation>
              <Language>2052</Language>
              <Caption>产品子类</Caption>
            </Translation>
          </Translations>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Color</ID>
          <Name>Color</Name>
          <EstimatedCount>10</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>15</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Color</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Safety Stock Level</ID>
          <Name>Safety Stock Level</Name>
          <EstimatedCount>6</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>SmallInt</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>SafetyStockLevel</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Reorder Point</ID>
          <Name>Reorder Point</Name>
          <EstimatedCount>6</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>SmallInt</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>ReorderPoint</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>List Price</ID>
          <Name>List Price</Name>
          <EstimatedCount>121</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>ListPrice</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>财务</AttributeHierarchyDisplayFolder>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Size</ID>
          <Name>Size</Name>
          <EstimatedCount>19</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Size</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Weight</ID>
          <Name>Weight</Name>
          <EstimatedCount>128</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Weight</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Days To Manufacture</ID>
          <Name>Days To Manufacture</Name>
          <EstimatedCount>4</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>DaysToManufacture</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Product Line</ID>
          <Name>Product Line</Name>
          <EstimatedCount>5</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>2</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>ProductLine</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>10</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_DimProduct</TableID>
              <ColumnID>产品线全名</ColumnID>
            </Source>
          </NameColumn>
          <Translations>
            <Translation>
              <Language>2052</Language>
              <Caption>产品线</Caption>
            </Translation>
          </Translations>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Dealer Price</ID>
          <Name>Dealer Price</Name>
          <EstimatedCount>121</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Double</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>DealerPrice</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <Translations>
            <Translation>
              <Language>2052</Language>
              <Caption>处理价</Caption>
            </Translation>
          </Translations>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>财务</AttributeHierarchyDisplayFolder>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Class</ID>
          <Name>Class</Name>
          <EstimatedCount>4</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>2</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Class</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <Translations>
            <Translation>
              <Language>2052</Language>
              <Caption>类型</Caption>
            </Translation>
          </Translations>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>外形</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Style</ID>
          <Name>Style</Name>
          <EstimatedCount>4</EstimatedCount>
          <KeyColumns>
            <KeyColumn>