⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 foodmartsale dw.cube

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者:朱德利,出版日期:2007-10-01 页 数: 383 出 版 社: 电子工业
💻 CUBE
📖 第 1 页 / 共 3 页
字号:
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>-2493</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
      <Value>1517</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
      <Value>75</Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Dimensions>
    <Dimension dwd:design-time-name="c5cf71d3-9745-4075-9555-e2cceec5711b">
      <ID>Time By Day</ID>
      <Name>Time By Day</Name>
      <DimensionID>Time By Day</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="ffa52744-edda-400d-8771-76a8793a7205">
          <AttributeID>年</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ee9306aa-a40d-40cd-87be-cadadd39ece6">
          <AttributeID>季度</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="69357955-c5e7-4275-a228-847e951fd986">
          <AttributeID>月份</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="aa984929-9be3-4672-abde-f5baf4c58994">
          <AttributeID>日期</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ab48c60d-6ba4-4d77-8a6d-872bda22dba0">
          <AttributeID>time_id</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="69c6f43f-e7ed-463d-89d1-bda8c166843d">
          <HierarchyID>the_year -  quarter -  the_month -  the_day</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="fb7908ba-c2d9-48d0-84d2-e28009e8ef7a">
      <ID>Promotion</ID>
      <Name>Promotion</Name>
      <DimensionID>Promotion</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="b3987c26-b742-4e54-a981-bbea623dabb2">
          <AttributeID>Promotion</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="de776ef2-0927-4aed-96bb-16f620752835">
          <AttributeID>Promotion District Id</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="bc87b9c9-df94-46c7-885b-ce6dbb8e6854">
          <AttributeID>Promotion Name</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="3ad5d563-55d2-4a28-8587-1eadebbd695a">
          <AttributeID>Media Type</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="12208bbe-5a16-4987-a04d-4ebb38a6f8e4">
          <AttributeID>Cost</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="4993a00a-10bd-4d17-9744-51b567244883">
          <AttributeID>Start Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="f6719faf-5663-49e1-bf02-2008aea71a06">
          <AttributeID>End Date</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="3fe56acc-c717-4b0b-85ef-944a5833ec72">
      <ID>Store</ID>
      <Name>Store</Name>
      <DimensionID>Store</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="57fe7e21-5ee1-46bb-9d66-ec0114c94b3c">
          <AttributeID>Store</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="01aa82b1-90ba-4523-b2a6-0854b65ac16e">
          <AttributeID>Store Type</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="889cd673-bd75-4daf-878c-243ca65a5068">
          <AttributeID>Region Id</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="629fd605-7c5d-4dde-98db-6b8a334e46c6">
          <AttributeID>Store Name</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="9f7427f2-12da-43a7-9a33-fe23e5b92dc2">
          <AttributeID>Store Number</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="dc0a91ff-f5be-47a3-b768-56af2ecd997a">
          <AttributeID>Store Street Address</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e4553160-2229-4867-bb74-8ec551de2c23">
          <AttributeID>Store City</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e1960cee-48bc-40b1-a83c-6c384b46fe8f">
          <AttributeID>Store State</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="f3bf9078-e74f-44dc-b35c-a25b5a8c5a04">
          <AttributeID>Store Postal Code</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="3e5b7dd7-4e90-4b1e-8836-f4e2e9854aaa">
          <AttributeID>Store Country</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="5ef9efb5-8cc8-47b9-add8-f4677e2d4f15">
          <AttributeID>Store Manager</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="2a6208d6-e026-4203-80ff-8a2d44db1446">
          <AttributeID>Store Phone</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="043a1802-4de5-4b40-ad4b-08201be227f7">
          <AttributeID>Store Fax</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="66120bea-bf45-4187-8a61-b6301124d74c">
          <AttributeID>First Opened Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ff05e3db-5602-4826-b75f-bb85c835ccf5">
          <AttributeID>Last Remodel Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="d0846d9d-5002-4e28-aed7-c39dc69127c2">
          <AttributeID>Lease Sqft</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="53a78134-ebc3-402b-a5ae-53ed02538dfb">
          <AttributeID>Store Sqft</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="db16b5ad-9a0e-4cf5-bf6c-5760abd95270">
          <AttributeID>Grocery Sqft</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="4474b7bc-56db-4924-9833-1d7146853b82">
          <AttributeID>Frozen Sqft</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="cf76a0c1-b3e3-4bbf-a4f0-dcb1b382372b">
          <AttributeID>Meat Sqft</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="1f136278-980f-4ec9-ae0c-adfa71c554eb">
          <AttributeID>Coffee Bar</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="1fadb202-4522-4f82-bc5f-c10793c2bc12">
          <AttributeID>Video Store</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="73ec25d6-61ea-4cd4-bbe2-101f28ecf1f2">
          <AttributeID>Salad Bar</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ccff3b7d-6e3e-43d1-8464-eaf878fe6e32">
          <AttributeID>Prepared Food</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="84d37d8b-f191-404c-b945-1e4a116f449a">
          <AttributeID>Florist</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="e5aa5497-68a2-4677-a1a1-2384da0b0167">
          <HierarchyID>Store Country - Store State</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="5981d3fb-ec7e-4665-9e31-ffaa8d096107">
      <ID>Customer</ID>
      <Name>Customer</Name>
      <DimensionID>Customer</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="00004f9c-a2ac-4c65-aa11-e62bd528343c">
          <AttributeID>Customer</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="a73af9dc-c597-450c-b67b-6ac8d8ec6a72">
          <AttributeID>Account Num</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e3362143-7025-4aa3-a8ea-9718432c48f2">
          <AttributeID>Lname</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="78221903-df7d-4ce1-818d-2a2d39a3b89f">
          <AttributeID>Fname</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7e21330d-ad34-4e67-abda-dc3e00753ec9">
          <AttributeID>Mi</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="878d61e3-8e9d-4e31-84fe-2fc73aadf300">
          <AttributeID>Address1</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="d23c6e1d-d218-491e-b4d2-f49d72807281">
          <AttributeID>Address2</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="54cd5c1e-14dd-4e6c-b0cb-06e36479b7e0">
          <AttributeID>Address3</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="6ce408a9-f4a1-43f8-bb0d-fea7046b5a5f">
          <AttributeID>Address4</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="3d78b7b9-6d02-44fb-94d8-68102f9fd0fb">
          <AttributeID>City</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7895bafc-12c1-4c27-bc36-f706bb942666">
          <AttributeID>State Province</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e110255d-0635-4b61-9786-ab9090f7966f">
          <AttributeID>Postal Code</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="970c1207-e1e3-45de-9a8b-3cf6e2e360e0">
          <AttributeID>Country</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="57f7f1b6-45ef-4122-9a41-835e8abb6995">
          <AttributeID>Customer Region Id</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ba987355-5973-450f-b661-2ea342260120">
          <AttributeID>Phone1</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="4b8ca779-0253-4829-9e35-62cb1272c17b">
          <AttributeID>Phone2</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="fe927999-9077-4a56-8673-7925019e258e">
          <AttributeID>Birthdate</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="1f49825e-d3f3-4408-bfcd-d3ce4072d194">
          <AttributeID>Marital Status</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="8bca3a48-ee73-4dcf-8de5-42a0b7350e5c">
          <AttributeID>Yearly Income</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="b0c70fb6-42e0-4061-91dc-b9f20af064ac">
          <AttributeID>Gender</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="b4debea4-5749-41fe-a8db-93d7b0889627">
          <AttributeID>Total Children</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="8fd5f2b9-6699-4692-86f4-eb33c948134d">
          <AttributeID>Num Children At Home</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="27113289-25f5-4be5-8a0d-ce34d11a4519">
          <AttributeID>Education</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="bb0f7cb5-c937-4949-a8d3-6b7737747bfb">
          <AttributeID>Date Accnt Opened</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="f381851e-4ead-4309-9524-3749b65371b3">
          <AttributeID>Member Card</AttributeID>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -