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

📄 aworkcube.cube

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 CUBE
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
          <Attributes>
            <Attribute dwd:design-time-name="b1ed2edb-bb86-46f0-a7d3-61994180791b">
              <AttributeID>产品</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="bcd153ed-5089-4882-a606-c92f20c00da0">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="edf41522-9f7e-4673-aa6d-e8f31ea43f84">
                    <TableID>dbo_FactInternetSales</TableID>
                    <ColumnID>ProductKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="608c030e-26e8-490d-8304-5417b801dca5">
          <CubeDimensionID>客户</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ca2a46c9-e04a-4f20-98d7-ba1e7da430f2">
              <AttributeID>客户</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="3e34eaca-a8b9-4ffb-8f1e-be1161b306d1">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="3f3bf7d8-7c17-4211-af9d-23c8ca059ab7">
                    <TableID>dbo_FactInternetSales</TableID>
                    <ColumnID>CustomerKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
      <Partitions />
    </MeasureGroup>
    <MeasureGroup dwd:design-time-name="37adfc51-9704-48d4-a130-4871b0a072a7">
      <ID>Fact Reseller Sales</ID>
      <Name>Fact Reseller Sales</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="5c134527-699d-4905-94e6-c950b4238086">
          <ID>Currency Key</ID>
          <Name>Currency Key</Name>
          <Source dwd:design-time-name="80b1f836-9d91-4153-aee1-99dbee942be7">
            <DataType>Integer</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="37227a8d-7788-422b-b894-0311582ee654">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>CurrencyKey</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="a2e760fe-40c9-4543-b2a0-0fdbae4ff948">
          <ID>Revision Number - Fact Reseller Sales</ID>
          <Name>Revision Number - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="36182e36-4edc-46c3-b39f-e89cc8f24c1a">
            <DataType>UnsignedInt</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="f25c054d-ae59-4c9c-a915-b799936b9d0f">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>RevisionNumber</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="32f80a9d-10af-496e-9918-3cd42df651fa">
          <ID>Order Quantity 1</ID>
          <Name>Order Quantity</Name>
          <Source dwd:design-time-name="3b31d8f7-c184-426c-86c1-33aae3cccbcb">
            <DataType>Integer</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="b2616a89-3e4b-446f-8925-026d792c351c">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>OrderQuantity</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="0bf4addc-276e-4727-b96a-f82a8bde588d">
          <ID>Unit Price 1</ID>
          <Name>Unit Price</Name>
          <Source dwd:design-time-name="ab211bd9-ea12-403d-b39f-0b8ec4180d72">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="8a7ab672-1de5-4586-957e-1aae1001924d">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>UnitPrice</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="e877047c-2b7a-47ea-abae-879735af6e82">
          <ID>Extended Amount - Fact Reseller Sales</ID>
          <Name>Extended Amount - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="aabc5dc5-5264-465b-9645-cc31ddd2cd41">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="45afd709-05ab-4a2a-8f09-a01c6b69174c">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>ExtendedAmount</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="4d91f552-ce28-4d13-9ea7-d9e496f6e86d">
          <ID>Unit Price Discount Pct 1</ID>
          <Name>Unit Price Discount Pct</Name>
          <Source dwd:design-time-name="da55cae9-f6f9-409f-a18c-7ad5f4d488f8">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="f4a8e893-c896-4446-9085-7083545fe3eb">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>UnitPriceDiscountPct</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="e0356797-242f-4876-9de6-49dde389f078">
          <ID>Discount Amount - Fact Reseller Sales</ID>
          <Name>Discount Amount - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="ad1950d1-7519-4ba1-8540-2b3e6f1b74b2">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="50136b0c-9cbd-4114-b774-1ce45dfd3963">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>DiscountAmount</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="08012075-6e24-4edb-95b7-6dce1b540961">
          <ID>Product Standard Cost - Fact Reseller Sales</ID>
          <Name>Product Standard Cost - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="b780bedf-a6e7-4b95-b022-5ad85d44f44c">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="bd809115-dd4a-43cd-9afe-d65da9d3990f">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>ProductStandardCost</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="baae7217-0847-470c-a019-ccc62356da3d">
          <ID>Total Product Cost - Fact Reseller Sales</ID>
          <Name>Total Product Cost - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="4fe81d87-153e-4ea9-a6fd-ececc9561e50">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="e998d2e7-abc5-436e-b716-c7f761fcfef9">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>TotalProductCost</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="d3f54319-47e6-418f-ad14-0cd077ebab0f">
          <ID>Sales Amount 1</ID>
          <Name>Sales Amount</Name>
          <Source dwd:design-time-name="aa624405-a38b-45a0-8d5d-ef9615e3d0b8">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="69350ea1-00f6-4dbe-86e6-6473a7a41c17">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>SalesAmount</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="353a6752-a9ba-4c51-a0e3-ec11cd7c4e9f">
          <ID>Tax Amt - Fact Reseller Sales</ID>
          <Name>Tax Amt - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="ebe6b4d6-8c06-4032-b70d-189859c1364b">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="dd529261-6d19-41ec-b519-9d2a833aa213">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>TaxAmt</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="2e653b49-07b6-49af-9ece-251fcbdfa9cb">
          <ID>Freight - Fact Reseller Sales</ID>
          <Name>Freight - Fact Reseller Sales</Name>
          <Source dwd:design-time-name="2a316920-7e3b-4cb2-b62c-721b55fcfd29">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="56e6411e-10da-4a7e-bdf5-d50a139f96fc">
              <TableID>dbo_FactResellerSales</TableID>
              <ColumnID>Freight</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="109de48c-3b1f-423d-823b-97fb0521d0f7">
          <ID>Fact Reseller Sales 计数</ID>
          <Name>Fact Reseller Sales 计数</Name>
          <AggregateFunction>Count</AggregateFunction>
          <Source dwd:design-time-name="6bc1125b-2464-48f8-ba49-6795c6b18a1d">
            <DataType>Integer</DataType>
            <DataSize>4</DataSize>
            <Source xsi:type="RowBinding" dwd:design-time-name="3bb3016b-381a-405f-b47c-02ab7818c945">
              <TableID>dbo_FactResellerSales</TableID>
            </Source>
          </Source>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="dcf75331-d7f4-4c2b-8502-7ab42966f05e">
          <CubeDimensionID>Order Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="bfeea87d-5ce7-4176-899d-269ba98b08d6">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="e17acd19-499e-4c20-af3e-ad3647095ad3">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="30565055-2b69-4f9c-b75e-0ca6b2ebf1cb">
                    <TableID>dbo_FactResellerSales</TableID>
                    <ColumnID>OrderDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="27befa2a-e4e4-4cbd-a768-0a02395472b9">
          <CubeDimensionID>Ship Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="cacdbcc1-9c63-4184-83d2-45f153157816">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="7e726547-a8a4-4dde-8650-7ee389cd56b6">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="d2dcadc6-510c-4e22-a610-e6589fb50f4b">
                    <TableID>dbo_FactResellerSales</TableID>
                    <ColumnID>ShipDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="d22eb4ac-f38c-4d2f-a79a-1ae258243cf6">
          <CubeDimensionID>产品</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="4721c09f-8aea-4172-a425-fe1783a38257">
              <AttributeID>产品</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="c835fdbf-050e-4c59-88ff-bfa0f37f6fb1">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="73dde461-2e7e-4995-9fa7-43eac907211c">
                    <TableID>dbo_FactResellerSales</TableID>
                    <ColumnID>ProductKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="62c31cc2-f079-4816-8739-4fc9d7641a5c">
          <CubeDimensionID>Due Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="18a01a9c-c1cc-4633-9532-07fb93bb1eb6">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="1bf80606-e701-4a63-a60f-cb28e5afe06c">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9440e0e1-29a5-4b3a-a7a2-c85fc2eb57b7">
                    <TableID>dbo_FactResellerSales</TableID>
                    <ColumnID>DueDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
      <Partitions />
    </MeasureGroup>
  </MeasureGroups>
  <Source dwd:design-time-name="88996f3a-bd18-4188-9790-595e32382a67">
    <DataSourceViewID>Adventure Works DW</DataSourceViewID>
  </Source>
</Cube>
1234

⌨️ 快捷键说明

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