store.dim

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

            <ColumnID>store_postal_code</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="8672a27c-1685-48b8-a123-6e36647d2a6c">
      <ID>Store Country</ID>
      <Name>Store Country</Name>
      <EstimatedCount>3</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9809f7b7-1cd1-42d9-a67f-2124c2b13b45">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="18fed614-e122-44ba-a6a5-18e937ddc7a3">
            <TableID>dbo_store</TableID>
            <ColumnID>store_country</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="e9dacacd-d47e-4fad-91b0-9d7769ba256e">
      <ID>Store Manager</ID>
      <Name>Store Manager</Name>
      <EstimatedCount>23</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="46e321a7-6101-436d-b1d5-1b246fd9e526">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="5fc84de6-8a52-4823-933f-1c41f87df53c">
            <TableID>dbo_store</TableID>
            <ColumnID>store_manager</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="46682d8c-8bc4-4803-a2a5-22b5ebaabcf5">
      <ID>Store Phone</ID>
      <Name>Store Phone</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a1c1b852-e9c4-413f-8014-354dff39e266">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2f5ef294-7f55-4a01-8bdd-d1cd25d34083">
            <TableID>dbo_store</TableID>
            <ColumnID>store_phone</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="5f68b3a6-dfdd-4a46-aa25-a3a7c52125dc">
      <ID>Store Fax</ID>
      <Name>Store Fax</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8e51a7b4-733f-4db4-87db-446832fe90a4">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="a23211d2-1b7e-42d2-b0a2-1159fbb044d1">
            <TableID>dbo_store</TableID>
            <ColumnID>store_fax</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="54d9bab9-3057-4470-a46e-95fc01777972">
      <ID>First Opened Date</ID>
      <Name>First Opened Date</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="53ebedc4-802b-425b-8b49-9085297d64c8">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="16ab4384-8ed9-45a7-b571-6c781d9f2aeb">
            <TableID>dbo_store</TableID>
            <ColumnID>first_opened_date</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="5ae98c4f-6355-4c39-8451-2a7a0e84b970">
      <ID>Last Remodel Date</ID>
      <Name>Last Remodel Date</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="016ecbee-c894-4a55-baff-4f5eea3fd0ed">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="47898bdb-70bd-4588-ab37-20a47c2cff20">
            <TableID>dbo_store</TableID>
            <ColumnID>last_remodel_date</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="21a8a364-842a-4f02-96a7-6c298163bcf8">
      <ID>Lease Sqft</ID>
      <Name>Lease Sqft</Name>
      <EstimatedCount>1</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="94d8a5c8-6877-4816-88ca-fe37faf8ed37">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="dfa34874-f363-407c-8bba-a7bd83ef6141">
            <TableID>dbo_store</TableID>
            <ColumnID>lease_sqft</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="41e41f49-fd40-4bcd-93a4-12eff68a157b">
      <ID>Store Sqft</ID>
      <Name>Store Sqft</Name>
      <EstimatedCount>21</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="ab69cd69-07bd-49ea-b310-308b93ff2641">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="e9067e5e-3d5b-4ac7-8bda-ea889e855a05">
            <TableID>dbo_store</TableID>
            <ColumnID>store_sqft</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="16277eb8-61ea-4318-acb8-96fe99c0b20e">
      <ID>Grocery Sqft</ID>
      <Name>Grocery Sqft</Name>
      <EstimatedCount>21</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="504a0517-3055-4342-ae31-8eab5040eb37">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ba71a542-4764-4271-b16f-12711be117f3">
            <TableID>dbo_store</TableID>
            <ColumnID>grocery_sqft</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="fce4f8a8-2477-4854-b26e-580cb9622f40">
      <ID>Frozen Sqft</ID>
      <Name>Frozen Sqft</Name>
      <EstimatedCount>21</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c57c689f-c6d4-47c8-98ce-7c691afeaa95">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="aef92db9-1487-44b0-ac6b-574c4d06b074">
            <TableID>dbo_store</TableID>
            <ColumnID>frozen_sqft</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="28a1741e-06bd-48a5-b8ad-c3b1be174c4b">
      <ID>Meat Sqft</ID>
      <Name>Meat Sqft</Name>
      <EstimatedCount>21</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="11b19397-51d1-4cee-8298-8cd3134359fa">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="711636a4-4f39-4be3-b201-3797d11d1792">
            <TableID>dbo_store</TableID>
            <ColumnID>meat_sqft</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="34824fde-9277-4f23-b0a0-b19a9d199050">
      <ID>Coffee Bar</ID>
      <Name>Coffee Bar</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="ec55cbbf-9af5-426c-9ded-51a642b3e7d7">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="bec797df-2748-4b19-a5e1-a731e4044ee3">
            <TableID>dbo_store</TableID>
            <ColumnID>coffee_bar</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f5dc1077-0a4d-464d-a3e1-148beb74118c">
      <ID>Video Store</ID>
      <Name>Video Store</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="0bfb28de-a785-4b68-9a66-82304296cee7">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="638fab9a-775f-4302-834b-c583c8b5ff12">
            <TableID>dbo_store</TableID>
            <ColumnID>video_store</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="fc26abae-82cd-44cc-8210-b58de36619d0">
      <ID>Salad Bar</ID>
      <Name>Salad Bar</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="7f3b9936-560b-46b5-91bc-77260d07eef6">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="1e303ca5-40a0-475a-a278-cde23f666d26">
            <TableID>dbo_store</TableID>
            <ColumnID>salad_bar</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="c2715e64-7f7f-45e4-a426-94e8a98333cd">
      <ID>Prepared Food</ID>
      <Name>Prepared Food</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="48c09396-fd64-4a24-83fc-a3d34b9ec1cd">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2e251d65-7322-4318-adde-9c40de2f5e2c">
            <TableID>dbo_store</TableID>
            <ColumnID>prepared_food</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="53a3b545-71a3-4eec-a0e6-343f5a06edd8">
      <ID>Florist</ID>
      <Name>Florist</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="14abc1a4-c4ac-493e-bfc8-aa37f997fbab">
          <DataType>Boolean</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7efb21e1-d095-458f-87c6-2f38e63d34e0">
            <TableID>dbo_store</TableID>
            <ColumnID>florist</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="c6c62b58-cd49-4270-91da-d3d5a9456fa7">
      <ID>Store Country - Store State</ID>
      <Name>Store Country - Store State</Name>
      <Levels>
        <Level dwd:design-time-name="696188d6-6b98-4aa0-b496-468ea1561d61">
          <ID>Store Country</ID>
          <Name>Store Country</Name>
          <SourceAttributeID>Store Country</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="be55957f-1a38-4222-bf6e-9019ba43c2cd">
          <ID>Store State</ID>
          <Name>Store State</Name>
          <SourceAttributeID>Store State</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="2e69803d-fcfa-4e8d-91ec-53d894a94a71">
          <ID>Store</ID>
          <Name>Store</Name>
          <SourceAttributeID>Store</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>