product.dim

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

<Dimension xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="d86a3c2d-3853-4b8e-86fe-5ac1b937de4c" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Product</ID>
  <Name>Product</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>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
      <Value>false</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
      <Value>100</Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="3c566f1c-ac9d-40fb-bfca-56e4c16324b4">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
  <UnknownMember>Visible</UnknownMember>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="0e4b7359-96fa-423a-9f5c-79c8e674bff4">
      <ID>Product</ID>
      <Name>Product</Name>
      <Usage>Key</Usage>
      <EstimatedCount>1560</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="b7bc8701-56bd-441d-85cc-0774edf265b2">
          <DataType>Integer</DataType>
          <NullProcessing>UnknownMember</NullProcessing>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="06525cd1-fc17-4329-9f72-ec991df46ab4">
            <TableID>dbo_product</TableID>
            <ColumnID>product_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="54f281c8-7fd5-4b32-8b72-172558139228">
        <DataType>WChar</DataType>
        <DataSize>255</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="fcda3b55-97d5-463c-8007-bf385b7fb634">
          <TableID>dbo_product</TableID>
          <ColumnID>product_name</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="b98979be-f22f-4311-8030-a73bbffea9b0">
          <AttributeID>Brand Name</AttributeID>
          <Name>Brand Name</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="1e0bf232-39b3-4d8a-9fc3-13ded98ba085">
          <AttributeID>SKU</AttributeID>
          <Name>SKU</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bf68c9e9-ad2d-4b63-a2f8-ae2d55b1b6bb">
          <AttributeID>SRP</AttributeID>
          <Name>SRP</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="8b0da2b6-80a6-41d7-b1ba-16628ac267af">
          <AttributeID>Gross Weight</AttributeID>
          <Name>Gross Weight</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="a55a965c-ee51-49d4-93f8-e9f20be0cf36">
          <AttributeID>Net Weight</AttributeID>
          <Name>Net Weight</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="1b82ed0b-c78c-46e9-a2e7-d535402b6fc5">
          <AttributeID>Recyclable Package</AttributeID>
          <Name>Recyclable Package</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="866c5eab-8de1-4c9c-8c4f-914cde1c7ab4">
          <AttributeID>Low Fat</AttributeID>
          <Name>Low Fat</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="fdec1f25-708e-45e5-abc6-54fbfd05db18">
          <AttributeID>Units Per Case</AttributeID>
          <Name>Units Per Case</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="b0712900-4c39-43fd-83f9-71c246309e87">
          <AttributeID>Cases Per Pallet</AttributeID>
          <Name>Cases Per Pallet</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="6fde1fc2-c0a1-4f75-946c-fad2f59598bf">
          <AttributeID>Shelf Width</AttributeID>
          <Name>Shelf Width</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="4d70667c-f3b8-4226-b37f-b064d312477b">
          <AttributeID>Shelf Height</AttributeID>
          <Name>Shelf Height</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c0432d08-a91a-4370-b8e8-51b1ffedcccb">
          <AttributeID>Shelf Depth</AttributeID>
          <Name>Shelf Depth</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="fc4aeee7-54b3-43f0-8422-bb5fd1f8c6aa">
          <AttributeID>Product Class</AttributeID>
          <Name>Product Class</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="9d3606ae-670e-43f7-ac98-338b624afb36">
      <ID>Brand Name</ID>
      <Name>Brand Name</Name>
      <EstimatedCount>111</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d3834e5f-12ca-44f6-a320-96da2d2edafd">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="de39f55c-2d5b-4922-9ae3-8e3ece0c2ceb">
            <TableID>dbo_product</TableID>
            <ColumnID>brand_name</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="d202656b-21de-4e61-a911-b599af3d2417">
      <ID>SKU</ID>
      <Name>SKU</Name>
      <EstimatedCount>1560</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a20d459d-153e-4f2b-8af1-c788b75848cc">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="af311531-fb30-417f-89c7-94aefb54d715">
            <TableID>dbo_product</TableID>
            <ColumnID>SKU</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="6fefcc46-04ee-4c2a-9ba1-117758fe058b">
      <ID>SRP</ID>
      <Name>SRP</Name>
      <EstimatedCount>315</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="158b04b1-18d2-4fef-95a9-3673df79a276">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="add42223-9e2d-4fb5-97f7-2dd8e0539920">
            <TableID>dbo_product</TableID>
            <ColumnID>SRP</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="d0287abc-7235-46fd-83c0-7079421ff130">
      <ID>Gross Weight</ID>
      <Name>Gross Weight</Name>
      <EstimatedCount>376</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a79a7bff-1f81-42ad-aa61-0e6f8bd950c5">
          <DataType>Single</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="68c83fe8-d602-4cb7-a8f8-644fd398645f">
            <TableID>dbo_product</TableID>
            <ColumnID>gross_weight</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="0c2f1af2-7c81-4d92-ae21-273cb3f98014">
      <ID>Net Weight</ID>
      <Name>Net Weight</Name>
      <EstimatedCount>332</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="f5753490-350a-4258-826f-45803a06bf2e">
          <DataType>Single</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b49faafb-3d26-4362-903d-3bc03a1f6c5c">
            <TableID>dbo_product</TableID>
            <ColumnID>net_weight</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="429ceaca-cb62-4852-94ee-74396bbe8f94">
      <ID>Recyclable Package</ID>
      <Name>Recyclable Package</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="744d756f-f4a7-4c87-b44d-2bc78e6ddb85">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="159af614-daf4-4f9d-8305-1b946d10de64">
            <TableID>dbo_product</TableID>
            <ColumnID>recyclable_package</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="8d0d91ef-9425-4f17-9d09-12ac6a6696b1">
      <ID>Low Fat</ID>
      <Name>Low Fat</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2fa5139f-ac2a-4afe-bd10-d311971ebf8a">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="e266e595-9506-4040-be5d-463aeeabdcc6">
            <TableID>dbo_product</TableID>
            <ColumnID>low_fat</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="575bc351-ced2-48e8-9cea-9fb47da41d95">
      <ID>Units Per Case</ID>
      <Name>Units Per Case</Name>
      <EstimatedCount>36</EstimatedCount>