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

📄 aworkcube.cube

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 CUBE
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="6ac1857e-010d-4935-ac63-3d9b84eabf6a">
          <HierarchyID>State Province Name - 地区</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
  </Dimensions>
  <MeasureGroups>
    <MeasureGroup dwd:design-time-name="48f6d422-a873-42bf-b448-3fb8f26c81aa">
      <ID>Fact Internet Sales</ID>
      <Name>Fact Internet 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>
      <Translations>
        <Translation dwd:design-time-name="4a998598-de24-41ee-a834-131f521bd24c">
          <Language>2052</Language>
          <Caption>网络销售</Caption>
        </Translation>
      </Translations>
      <Measures>
        <Measure dwd:design-time-name="56ccc39b-805d-43e5-a6c8-d5315d89edfe">
          <ID>Revision Number</ID>
          <Name>Revision Number</Name>
          <Source dwd:design-time-name="a3292fbb-374e-4f5e-90c8-d67b0d76fe79">
            <DataType>UnsignedInt</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="f285ce86-e88f-40e9-908b-98cfd0af569b">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>RevisionNumber</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="63228af2-ad95-4b66-9193-0c01b5e01e58">
              <Language>2052</Language>
              <Caption>修正号</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="766cc17f-9c1c-4a5b-a5d5-00696d0a6763">
          <ID>Order Quantity</ID>
          <Name>订单数量</Name>
          <AggregateFunction>Count</AggregateFunction>
          <Source dwd:design-time-name="7474b0f8-5368-4d6a-93a0-6b028e4994a0">
            <DataType>Integer</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="a9e3b635-7853-4a0f-82d8-afcd05cf82c3">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>OrderQuantity</ColumnID>
            </Source>
          </Source>
          <FormatString>#</FormatString>
          <Translations>
            <Translation dwd:design-time-name="1192f43a-e77a-4a22-8ff8-5a949e29e8d3">
              <Language>2052</Language>
              <Caption>订货量</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="a661c232-8678-477c-9e94-4cb6f8ee9072">
          <ID>Unit Price</ID>
          <Name>单价</Name>
          <Source dwd:design-time-name="5535985f-ab61-4082-9c95-cd2d8e560d51">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="dfc6edc2-dc61-4687-9b64-824f3b2cd31e">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>UnitPrice</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="0b26d85a-c1aa-4df5-b59e-2772accb27b8">
              <Language>2052</Language>
              <Caption>单价</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="bda25c4c-1b3d-408c-9542-223b51e5f94f">
          <ID>Extended Amount</ID>
          <Name>Extended Amount</Name>
          <Source dwd:design-time-name="a1dd6237-cb61-475a-a066-89b09170b1e7">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="5a180bc3-56d2-4e2e-bf46-8939dd7c99f4">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>ExtendedAmount</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="267dcd47-951b-4753-af8e-d4a11d9f31e8">
              <Language>2052</Language>
              <Caption>扩充额</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="1f593816-1d23-4080-afae-99b31d6eaa7e">
          <ID>Unit Price Discount Pct</ID>
          <Name>单位折扣百分比</Name>
          <Source dwd:design-time-name="619770c3-8264-49dc-88a6-649be0bf662b">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="6f9d7ec0-0762-4688-8b23-88be09408afa">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>UnitPriceDiscountPct</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="180a6c71-700d-4f1b-990f-3af7efe75381">
              <Language>2052</Language>
              <Caption>折扣百分比</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="1af982f2-a165-429f-90ab-5aaaefa4a80a">
          <ID>Discount Amount</ID>
          <Name>Discount Amount</Name>
          <Source dwd:design-time-name="24bf0270-b22b-4278-99bd-ec63089213e6">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="8080647e-9458-4622-a865-9038e6b386f8">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>DiscountAmount</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="a54a37e9-91fd-4cd9-95e8-1435c9b4b733">
              <Language>2052</Language>
              <Caption>折扣额</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="b434c1e5-b585-4072-91f2-e993a1b0a650">
          <ID>Product Standard Cost</ID>
          <Name>Product Standard Cost</Name>
          <Source dwd:design-time-name="f5ddd987-043b-4e18-b85c-504a0d928d08">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="ea353f68-14fd-4268-8177-b92ca94fcb33">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>ProductStandardCost</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="cdc1cb41-92c7-4365-b6a2-3d7802ceb631">
              <Language>2052</Language>
              <Caption>产品标准成本</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="fd2ead1b-f2a4-409e-9ba6-fc4d62364738">
          <ID>Total Product Cost</ID>
          <Name>Total Product Cost</Name>
          <Source dwd:design-time-name="f5541d89-17c7-4678-b3bd-869b9fe5a243">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="57073957-5be9-42ac-adf7-110746d0820e">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>TotalProductCost</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="181ec444-6d89-4e65-80b0-a3ceeff00ee2">
              <Language>2052</Language>
              <Caption>产品总成本</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="4f7a8a1d-8122-4409-a27c-344be2a8dbae">
          <ID>Sales Amount</ID>
          <Name>销售额</Name>
          <Source dwd:design-time-name="38fc87ff-630b-4a3b-a23f-90e777d1c5ed">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="0f5bf366-9b0b-4004-b17d-d9b7fa2f0a47">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>SalesAmount</ColumnID>
            </Source>
          </Source>
          <FormatString>Currency</FormatString>
          <Translations>
            <Translation dwd:design-time-name="bce80414-a877-47d1-ba77-391146af6406">
              <Language>2052</Language>
              <Caption>销售额</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="25d3445b-d9ed-46ef-88b0-8cc00e70d8dd">
          <ID>Tax Amt</ID>
          <Name>Tax Amt</Name>
          <Source dwd:design-time-name="30a88ec8-047b-4bcb-8c14-e6c60a7545bc">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="096c7e57-543a-4407-8d80-aec8c806ce28">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>TaxAmt</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="27dbb0be-fad7-485b-8508-c46cf8afc9a9">
              <Language>2052</Language>
              <Caption>税额</Caption>
            </Translation>
          </Translations>
        </Measure>
        <Measure dwd:design-time-name="a7313a04-cca8-4157-ab86-edf8d3c859d8">
          <ID>Freight</ID>
          <Name>Freight</Name>
          <Source dwd:design-time-name="7f4827aa-f930-49a4-8797-f4ff150c5fb5">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="ded72f50-1a01-4d6d-8d55-342f2a943b6e">
              <TableID>dbo_FactInternetSales</TableID>
              <ColumnID>Freight</ColumnID>
            </Source>
          </Source>
          <Translations>
            <Translation dwd:design-time-name="260e6f86-bdba-4c1e-914f-ffc3bdcfa66a">
              <Language>2052</Language>
              <Caption>运费</Caption>
            </Translation>
          </Translations>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="311c919f-01c4-4f7b-9312-6aca6053c4a7">
          <CubeDimensionID>Ship Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="01e0aa74-b6df-41f7-8632-4a4e899fd21b">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="946b4fcd-aac1-4150-b491-66e4fd52e96c">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="0420eb4f-75dd-43d5-b0d1-1c419c8edcc0">
                    <TableID>dbo_FactInternetSales</TableID>
                    <ColumnID>ShipDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="671df66c-0761-4f7f-b9ce-23098372586e">
          <CubeDimensionID>Order Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ffec9654-36f2-4602-8174-8040368d998d">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="6e4941dc-8280-47f2-b00d-41d7f95c50fd">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="c43e0d02-1c2d-4822-b109-79b7533b7b65">
                    <TableID>dbo_FactInternetSales</TableID>
                    <ColumnID>OrderDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="8209e0c4-973a-467b-a1d8-10b59b4c609e">
          <CubeDimensionID>Due Date</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="dc1e703d-0542-401b-a9ae-f898d6b2d3fc">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="4a7c0a6d-1354-4828-9056-4cf0ccffe756">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="b0ddf027-039c-4520-8955-6502bcac4615">
                    <TableID>dbo_FactInternetSales</TableID>
                    <ColumnID>DueDateKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="98a901ca-259e-41dc-bf79-2b4d4cf5e72e">
          <CubeDimensionID>产品</CubeDimensionID>
1234

⌨️ 快捷键说明

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