store.dim

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DIM 代码 · 共 585 行 · 第 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="15e5093d-6d2d-4aa5-8b21-83a1596a0cc4" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Store</ID>
  <Name>Store</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="dd347f80-b2b8-4156-a3d0-63b68992d5f2">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
  <UnknownMember>Visible</UnknownMember>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="bc338a5c-8b33-44bd-af49-3397378adce9">
      <ID>Store</ID>
      <Name>Store</Name>
      <Usage>Key</Usage>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="99fb9d6e-7401-4e9d-87cd-353e3993c7b8">
          <DataType>Integer</DataType>
          <NullProcessing>UnknownMember</NullProcessing>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="508facd1-ad10-4bc8-adeb-aaa7c64c8728">
            <TableID>dbo_store</TableID>
            <ColumnID>store_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="f97be764-89e7-4a35-9269-748b6d26b6d8">
          <AttributeID>Store Type</AttributeID>
          <Name>Store Type</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="073cb895-0c57-4350-921d-712549c8ff64">
          <AttributeID>Region Id</AttributeID>
          <Name>Region Id</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="9551b7e4-dd07-4260-be95-71e2779121ee">
          <AttributeID>Store Name</AttributeID>
          <Name>Store Name</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="a51f04dd-df50-47b1-9819-caec18cc9006">
          <AttributeID>Store Number</AttributeID>
          <Name>Store Number</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="6f7d11bb-7cc4-49b4-a5c0-58e41fc0aef3">
          <AttributeID>Store Street Address</AttributeID>
          <Name>Store Street Address</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="13cfabdc-3a74-4042-80a2-259e61b4ab7e">
          <AttributeID>Store City</AttributeID>
          <Name>Store City</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="702defbc-7570-4059-b49c-f39e8985f1f3">
          <AttributeID>Store State</AttributeID>
          <Name>Store State</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="1ef263b1-f233-4aaf-b0e2-a7c0119a36f1">
          <AttributeID>Store Postal Code</AttributeID>
          <Name>Store Postal Code</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c2fea628-e9ab-4ac1-a7c6-56d2c04e94d1">
          <AttributeID>Store Country</AttributeID>
          <Name>Store Country</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="fd37f1ca-201d-41b8-8fd5-ca7667db59a1">
          <AttributeID>Store Manager</AttributeID>
          <Name>Store Manager</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="408d782d-9a62-43b0-bd43-b7460b2f622d">
          <AttributeID>Store Phone</AttributeID>
          <Name>Store Phone</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="5795facf-b640-488a-946b-f3f129b92711">
          <AttributeID>Store Fax</AttributeID>
          <Name>Store Fax</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bb6f97d3-093b-4d6d-ac6c-769c53af9cb6">
          <AttributeID>First Opened Date</AttributeID>
          <Name>First Opened Date</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c880b1f7-362d-422d-b07d-fb7a142bf3a7">
          <AttributeID>Last Remodel Date</AttributeID>
          <Name>Last Remodel Date</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="24ca7ecd-d25c-4d41-95a2-6b5f732264cb">
          <AttributeID>Lease Sqft</AttributeID>
          <Name>Lease Sqft</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="4fd00039-2741-40f3-b54d-d9e64b9743c8">
          <AttributeID>Store Sqft</AttributeID>
          <Name>Store Sqft</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bac399bf-3664-4493-bee5-eda8f3830c16">
          <AttributeID>Grocery Sqft</AttributeID>
          <Name>Grocery Sqft</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="d730d3fb-a8b8-49ab-8161-f0d5e5bae23f">
          <AttributeID>Frozen Sqft</AttributeID>
          <Name>Frozen Sqft</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="89b617fc-0ddf-4329-b2d6-9570bc3d3cfd">
          <AttributeID>Meat Sqft</AttributeID>
          <Name>Meat Sqft</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="b0cdaa45-ec20-4ffe-9025-ffbe6ff97cbf">
          <AttributeID>Coffee Bar</AttributeID>
          <Name>Coffee Bar</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="19151523-dc0c-4a0f-99b4-cf67b825982f">
          <AttributeID>Video Store</AttributeID>
          <Name>Video Store</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0465939c-ca16-4d32-822b-129158bd2bb4">
          <AttributeID>Salad Bar</AttributeID>
          <Name>Salad Bar</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="3207dee2-ff69-4f04-b46d-685ad37187bb">
          <AttributeID>Prepared Food</AttributeID>
          <Name>Prepared Food</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="cd190313-ad22-45a1-9da9-ae5418bb833e">
          <AttributeID>Florist</AttributeID>
          <Name>Florist</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f098da3f-fec5-481a-b6d7-df48399360ea">
      <ID>Store Type</ID>
      <Name>Store Type</Name>
      <EstimatedCount>6</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d4a03fc2-6bc5-4e97-9060-0b7840562b68">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="994bbf94-99e3-4a3b-bd0c-be384d59135a">
            <TableID>dbo_store</TableID>
            <ColumnID>store_type</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="366d1d34-3b61-4f97-bd0a-7bbbae914bab">
      <ID>Region Id</ID>
      <Name>Region Id</Name>
      <EstimatedCount>24</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="b299005b-591d-4cf2-9c58-ab68f366e5bd">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="92fd2594-f66b-48bd-99b3-314430d748ac">
            <TableID>dbo_store</TableID>
            <ColumnID>region_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="200797b7-3c7c-40d6-8ebb-f43dfdf984e6">
      <ID>Store Name</ID>
      <Name>Store Name</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="990e7e7c-b8d0-4521-a248-0883ae4e0b88">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2bf68d77-e286-497b-acd8-d9a4954cb0ea">
            <TableID>dbo_store</TableID>
            <ColumnID>store_name</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f1aafc16-cf70-48a3-87f0-56e052f7b771">
      <ID>Store Number</ID>
      <Name>Store Number</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="b3f0cdd9-4de5-4688-87a9-23617321f06a">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7c4a046a-a3d0-4c6c-aeb8-c3aff2daedfe">
            <TableID>dbo_store</TableID>
            <ColumnID>store_number</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="9ca9120d-6b68-4bf8-af70-ca8cd795816f">
      <ID>Store Street Address</ID>
      <Name>Store Street Address</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="85f11702-ec24-4d30-bb5c-881894b641e3">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b5eb987e-2dc6-4c6f-b696-be999a9f6fee">
            <TableID>dbo_store</TableID>
            <ColumnID>store_street_address</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="9de9173c-7180-4201-b3af-3d3505cf06e6">
      <ID>Store City</ID>
      <Name>Store City</Name>
      <EstimatedCount>24</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="09d4b5fb-fda1-4e0a-963b-5910cc5caf69">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="658afa52-1d1d-4df4-82b4-a9ec45a7fa85">
            <TableID>dbo_store</TableID>
            <ColumnID>store_city</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="85972dcf-8ee7-4013-9de7-575a48813e33">
      <ID>Store State</ID>
      <Name>Store State</Name>
      <EstimatedCount>10</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="cec4b3ff-ca82-4023-8397-92c51ffae58e">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="88736510-79be-45d1-8273-9011c6460680">
            <TableID>dbo_store</TableID>
            <ColumnID>store_state</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="8d044b82-bf9e-46b4-adf9-905d9c05ddb7">
      <ID>Store Postal Code</ID>
      <Name>Store Postal Code</Name>
      <EstimatedCount>1</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="97395420-5521-452b-9312-0e0c625c7529">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="fd7f43fd-a89e-4f21-89b6-7fe45fe8e63f">
            <TableID>dbo_store</TableID>