aworks2.asdatabase

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

              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Color</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>Stocking</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>Stocking</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>Stocking</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>Financial</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>Stocking</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Size Range</ID>
          <Name>Size Range</Name>
          <EstimatedCount>11</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>SizeRange</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>Stocking</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>Stocking</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>Stocking</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>ProductLineName</ColumnID>
            </Source>
          </NameColumn>
          <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>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>Financial</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>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Style</ID>
          <Name>Style</Name>
          <EstimatedCount>4</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>2</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Style</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Model Name</ID>
          <Name>Model Name</Name>
          <EstimatedCount>120</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>50</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>ModelName</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>List</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Start Date</ID>
          <Name>Start Date</Name>
          <EstimatedCount>4</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Date</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>StartDate</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>End Date</ID>
          <Name>End Date</Name>
          <EstimatedCount>3</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Date</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>EndDate</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Status</ID>
          <Name>Status</Name>
          <EstimatedCount>2</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>7</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_DimProduct</TableID>
                <ColumnID>Status</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
      </Attributes>
      <AttributeAllMemberName>All Products</AttributeAllMemberName>
      <Hierarchies>
        <Hierarchy>
          <ID>Hierarchy</ID>
          <Name>Poduct Model Lines</Name>
          <AllMemberName>All Products</AllMemberName>
          <Levels>
            <Level>
              <ID>Product Line</ID>
              <Name>Product Line</Name>
              <SourceAttributeID>Product Line</SourceAttributeID>
            </Level>
            <Level>
              <ID>Model Name</ID>
              <Name>Model Name</Name>
              <SourceAttributeID>Model Name</SourceAttributeID>
            </Level>
            <Level>
              <ID>Product Name</ID>
              <Name>Product Name</Name>
              <SourceAttributeID>Product</SourceAttributeID>
            </Level>
          </Levels>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension>
      <ID>Customer</ID>
      <Name>客户</Name>
      <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
      <Annotations>
        <Annotation>
          <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>