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

📄 foodmartsale dw.cube

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 CUBE
📖 第 1 页 / 共 3 页
字号:
🔍
123 
        </Attribute>
        <Attribute dwd:design-time-name="1f66905c-3c19-4369-a2c3-f19be435defe">
          <AttributeID>Occupation</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="5b36aaae-3543-4260-abe6-00b78ea5058b">
          <AttributeID>Houseowner</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="4ade7a7b-7751-4b0e-a2d0-68d6960ce771">
          <AttributeID>Num Cars Owned</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="2f007769-387f-40cd-8634-eed3f75d9347">
          <HierarchyID>Country - State Province - Customer Region Id</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="05bf3f82-6fe3-48fd-8da5-77d50677cf07">
      <ID>Product</ID>
      <Name>Product</Name>
      <DimensionID>Product</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="57a7fe10-bd62-458f-9dbe-acf24370bc63">
          <AttributeID>Product</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="35dc4c78-7daf-4f51-91da-094557e60078">
          <AttributeID>Brand Name</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="0f405182-325e-4ddc-b1a2-4a3d83e48c7f">
          <AttributeID>SKU</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="c543b47e-4ab6-4669-80e7-afcec4d626e2">
          <AttributeID>SRP</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="35016393-260c-4f5d-bb4a-87fcb9948c85">
          <AttributeID>Gross Weight</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="3e058963-2cab-4e70-91d3-079c3adca364">
          <AttributeID>Net Weight</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="fabde9a5-4165-4ebd-8d94-8bfe0dfa1da4">
          <AttributeID>Recyclable Package</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="275dadda-27bb-42f3-8b9a-ac14008e2eec">
          <AttributeID>Low Fat</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="6b9a069c-0d30-4ce4-b414-45985c5322bc">
          <AttributeID>Units Per Case</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="5f604039-4f69-4700-8474-51d556ab2729">
          <AttributeID>Cases Per Pallet</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="3ee021e8-e87f-4718-8786-40ae5c50a915">
          <AttributeID>Shelf Width</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7cc01f50-0801-4e2d-bfb2-81088765f6d6">
          <AttributeID>Shelf Height</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="9b3a175b-d646-4a47-8378-57588adeecfb">
          <AttributeID>Shelf Depth</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="f37eb7ff-537b-4bf1-a04c-ee08ad6a523c">
          <AttributeID>Product Class</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7d4adb12-6c2b-4ac0-972b-153f2ac72707">
          <AttributeID>Product Subcategory</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="c7de63f7-d86f-433d-82d5-ec0cedc38598">
          <AttributeID>Product Category</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="881afdb8-6edf-4728-a7d1-7c44a41a679d">
          <AttributeID>Product Department</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="49e2351c-4b02-4b98-b2ea-7dc7e20a56e2">
          <AttributeID>Product Family</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="8089aa5f-04d6-44ad-8249-317d7d14b6ec">
          <HierarchyID>Product Category - Product Class</HierarchyID>
        </Hierarchy>
        <Hierarchy dwd:design-time-name="88a2f66d-8ab7-4d87-9fa1-6498c357d686">
          <HierarchyID>Product Department - Product Class</HierarchyID>
        </Hierarchy>
        <Hierarchy dwd:design-time-name="f883f45e-145f-452c-9c4e-aa8825a66872">
          <HierarchyID>Product Family - Product Class</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
  </Dimensions>
  <MeasureGroups>
    <MeasureGroup dwd:design-time-name="1566cd71-8c37-4ad5-9850-3aef801a5b2c">
      <ID>Sales Fact 1998</ID>
      <Name>Sales Fact 1998</Name>
      <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Measures>
        <Measure dwd:design-time-name="14cccc65-af4e-48ae-b811-f831df24e4f9">
          <ID>Store Sales</ID>
          <Name>Store Sales</Name>
          <Source dwd:design-time-name="1f575e2e-6876-4c8e-a7a0-c026e748f7cf">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="d8ac584b-0d0d-4c8c-a934-303007837e5f">
              <TableID>dbo_sales_fact_1998</TableID>
              <ColumnID>store_sales</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="305bb459-d312-4355-a4a5-746fe2c62768">
          <ID>Store Cost</ID>
          <Name>Store Cost</Name>
          <Source dwd:design-time-name="f3d22573-e71f-4770-b6ef-9750a38b4f7f">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="5167bffb-9a96-4cf3-822d-d6b5130bf911">
              <TableID>dbo_sales_fact_1998</TableID>
              <ColumnID>store_cost</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="f1dd29c3-94ea-46da-800e-790c80e95ed6">
          <ID>Unit Sales</ID>
          <Name>Unit Sales</Name>
          <Source dwd:design-time-name="f2e98ec1-d3de-4c40-949c-ae4960cdb6ba">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="75af5538-d373-4e39-bc70-6b02e69af363">
              <TableID>dbo_sales_fact_1998</TableID>
              <ColumnID>unit_sales</ColumnID>
            </Source>
          </Source>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="ca228804-2cd9-47ef-aaa1-392811ea734c">
          <CubeDimensionID>Time By Day</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="070b483c-333f-4aae-8208-78048c106507">
              <AttributeID>time_id</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="fe7e19dd-27f5-4ac1-8e28-884799b1e7f0">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="64d43c8c-41ce-4f11-b7bb-ac34068807b7">
                    <TableID>dbo_sales_fact_1998</TableID>
                    <ColumnID>time_id</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="7aff8563-4fd1-4c26-8519-7dd9de52de7d">
          <CubeDimensionID>Promotion</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ef4823a2-8f60-46c9-a710-d40ba6201223">
              <AttributeID>Promotion</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="5ab5e8ed-67f7-40dd-950a-4e5d0a157499">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="3811a30b-e86e-4556-b30c-ca7cfefc1362">
                    <TableID>dbo_sales_fact_1998</TableID>
                    <ColumnID>promotion_id</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="3b88a59a-f3e0-485a-af5f-611f7a988851">
          <CubeDimensionID>Store</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="54af6fd4-0ac9-4dbd-85f4-f5505cb1aaca">
              <AttributeID>Store</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="a6930545-9697-4305-93c1-f7f19473856f">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="cbc6fdd2-faa8-481a-98e8-64b3fabaaeec">
                    <TableID>dbo_sales_fact_1998</TableID>
                    <ColumnID>store_id</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="e2f07b5c-b57d-4e0f-9493-783a0f2e9604">
          <CubeDimensionID>Customer</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ed528e2a-959e-4070-85bd-fe05d1894814">
              <AttributeID>Customer</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="d444847c-7094-40ba-9000-37568aaad8fd">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="590cf62a-3b78-4d4c-95d2-c4a0a07d7490">
                    <TableID>dbo_sales_fact_1998</TableID>
                    <ColumnID>customer_id</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="c3184566-5940-4217-b4a0-b3b45127167e">
          <CubeDimensionID>Product</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="81a44dce-8152-4ba9-b5b9-f496d3ebc48c">
              <AttributeID>Product</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="6f4b3773-6a51-4ca1-b030-ff5041cc0bf0">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="e2f9b3a3-dab8-44fb-a412-0e65e1c551ba">
                    <TableID>dbo_sales_fact_1998</TableID>
                    <ColumnID>product_id</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
    </MeasureGroup>
  </MeasureGroups>
  <Source dwd:design-time-name="cc4a44d7-892d-409b-85ba-6feac60606fc">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
</Cube>
123

⌨️ 快捷键说明

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