product.dim

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DIM 代码 · 共 492 行 · 第 1/2 页

      <KeyColumns>
        <KeyColumn dwd:design-time-name="98abb4a4-0688-443c-b2e6-2ed1d0b7f1ce">
          <DataType>SmallInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ef461ffe-be47-4a20-87cb-15c0794e65b0">
            <TableID>dbo_product</TableID>
            <ColumnID>units_per_case</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="def77452-3e65-4b0a-b409-09b8f7295aba">
      <ID>Cases Per Pallet</ID>
      <Name>Cases Per Pallet</Name>
      <EstimatedCount>10</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="80f17eba-ae1e-40bb-88bd-ea3ec37119b4">
          <DataType>SmallInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="dd301ee4-95b0-48c2-9dc0-fdbccfeb85f8">
            <TableID>dbo_product</TableID>
            <ColumnID>cases_per_pallet</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="98e3fa38-9130-4368-a9de-495dc2de0266">
      <ID>Shelf Width</ID>
      <Name>Shelf Width</Name>
      <EstimatedCount>534</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="83aa1e48-ccfe-49dc-ac1d-e9005fe48574">
          <DataType>Single</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="dc2d297b-dc5c-40df-8203-63a26c46794b">
            <TableID>dbo_product</TableID>
            <ColumnID>shelf_width</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="db81d70f-ca20-4c78-add1-89d075a276ac">
      <ID>Shelf Height</ID>
      <Name>Shelf Height</Name>
      <EstimatedCount>524</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="f5e7a4c2-d84c-4cf4-8ce7-ecce575aa358">
          <DataType>Single</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ac0f0d65-7985-407c-8880-11c84df63d03">
            <TableID>dbo_product</TableID>
            <ColumnID>shelf_height</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="5301430a-9cc4-417c-acce-fee2c6df3e33">
      <ID>Shelf Depth</ID>
      <Name>Shelf Depth</Name>
      <EstimatedCount>488</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2ccf16fd-8581-44a5-bad7-7236fb138a8e">
          <DataType>Single</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="696714c3-01e2-4a63-a1d5-a7509141dbcb">
            <TableID>dbo_product</TableID>
            <ColumnID>shelf_depth</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="047bf378-c473-4f14-92d7-a87c38982fe5">
      <ID>Product Class</ID>
      <Name>Product Class</Name>
      <EstimatedCount>110</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="b92f1962-97a2-4bf8-9845-0e3372328531">
          <DataType>Integer</DataType>
          <NullProcessing>UnknownMember</NullProcessing>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="235fc37d-88de-4d2d-a4b8-eeaa337ba805">
            <TableID>dbo_product_class</TableID>
            <ColumnID>product_class_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="a5464c03-7c93-4c7c-98d6-8176d68d196c">
          <AttributeID>Product Subcategory</AttributeID>
          <Name>Product Subcategory</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="56094e07-285f-4b32-909b-b84f2a6ee5c5">
          <AttributeID>Product Category</AttributeID>
          <Name>Product Category</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="2b2e0d62-6995-4347-8029-ba636c4826a2">
          <AttributeID>Product Department</AttributeID>
          <Name>Product Department</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="ac8a583d-77f2-4567-875e-759b1bb77969">
          <AttributeID>Product Family</AttributeID>
          <Name>Product Family</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="0a6028fe-3ab6-4116-9b03-1b1bc4a67bac">
      <ID>Product Subcategory</ID>
      <Name>Product Subcategory</Name>
      <EstimatedCount>107</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="132126d7-b542-4229-867d-63d3a9afa971">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7223392c-f6bf-4034-ade3-c34352980e98">
            <TableID>dbo_product_class</TableID>
            <ColumnID>product_subcategory</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="80da9c11-3b3d-481c-a66d-003ff9c4f667">
      <ID>Product Category</ID>
      <Name>Product Category</Name>
      <EstimatedCount>47</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2dfa4199-2193-4ae9-ac9c-3a955079ec4f">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="806acfc2-5a95-405d-9a3b-eab8549e76be">
            <TableID>dbo_product_class</TableID>
            <ColumnID>product_category</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="310e0b80-7f5c-4523-8a57-b2e81607a2eb">
      <ID>Product Department</ID>
      <Name>Product Department</Name>
      <EstimatedCount>23</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c941ea49-533d-4923-9557-f30df10d2e3b">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7070cbf1-6931-4549-a3c6-621eb1a79af6">
            <TableID>dbo_product_class</TableID>
            <ColumnID>product_department</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="2614debe-4c18-4b9d-bf07-0ccff4315d22">
      <ID>Product Family</ID>
      <Name>Product Family</Name>
      <EstimatedCount>3</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5f0689a0-557a-47c2-aa09-a655cb439f4d">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2ca6f0e9-2be0-4037-a171-8a62e2a909ea">
            <TableID>dbo_product_class</TableID>
            <ColumnID>product_family</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="e75a7d75-10ac-427b-9350-9ecec22edf9b">
      <ID>Product Category - Product Class</ID>
      <Name>Product Category - Product Class</Name>
      <Levels>
        <Level dwd:design-time-name="5c66a7a2-5ff8-41e7-88e8-0ec2a9e64e36">
          <ID>Product Category</ID>
          <Name>Product Category</Name>
          <SourceAttributeID>Product Category</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="90a551d0-13a4-47ce-bb14-cde0694bf78f">
          <ID>Product Class</ID>
          <Name>Product Class</Name>
          <SourceAttributeID>Product Class</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="801aea46-b565-4387-b4cb-d8e6f476853f">
          <ID>Product</ID>
          <Name>Product</Name>
          <SourceAttributeID>Product</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
    <Hierarchy dwd:design-time-name="6eb506b2-8bfa-4212-8deb-ed6e24918f06">
      <ID>Product Department - Product Class</ID>
      <Name>Product Department - Product Class</Name>
      <Levels>
        <Level dwd:design-time-name="3f10ac68-986f-45f6-a4d3-657660fe64d0">
          <ID>Product Department</ID>
          <Name>Product Department</Name>
          <SourceAttributeID>Product Department</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="e26cab83-910a-4195-8a68-5464b69228c7">
          <ID>Product Class</ID>
          <Name>Product Class</Name>
          <SourceAttributeID>Product Class</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="4e84ba8f-0531-48ba-83a6-7a5a4bac42d4">
          <ID>Product</ID>
          <Name>Product</Name>
          <SourceAttributeID>Product</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
    <Hierarchy dwd:design-time-name="687f0388-2e75-48cc-a8b7-c5a9730d36b2">
      <ID>Product Family - Product Class</ID>
      <Name>Product Family - Product Class</Name>
      <Levels>
        <Level dwd:design-time-name="40b09209-189d-4f96-8c81-27911113bd63">
          <ID>Product Family</ID>
          <Name>Product Family</Name>
          <SourceAttributeID>Product Family</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="ca81524d-1c64-4421-9b04-4543542fc483">
          <ID>Product Class</ID>
          <Name>Product Class</Name>
          <SourceAttributeID>Product Class</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="c1627384-47bb-4312-bfad-7db485e08140">
          <ID>Product</ID>
          <Name>Product</Name>
          <SourceAttributeID>Product</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>