sales.partitions

来自「< SQL Server2005程序设计>」· PARTITIONS 代码 · 共 1,639 行 · 第 1/5 页

PARTITIONS
1,639 行
字号
12345
<Cube xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="b3f937ec-7858-408c-a28a-f0676c2b5757" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Sales</ID>
  <MeasureGroups>
    <MeasureGroup>
      <ID>Tbl Fact</ID>
      <Partitions>
        <Partition dwd:design-time-name="298ec4bd-4338-4266-9e6b-d981c0b2cbe0">
          <ID>Main</ID>
          <Name>Main</Name>
          <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
          <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
          <Annotations>
            <Annotation>
              <Name>AggregationPercent</Name>
              <Value>99</Value>
            </Annotation>
          </Annotations>
          <LastProcessed>0001-01-01T05:00:00Z</LastProcessed>
          <State>Unprocessed</State>
          <Source xsi:type="DsvTableBinding" dwd:design-time-name="18898ef7-5a08-4e89-9dd2-6c9ad0a563a1">
            <DataSourceViewID>Northwind</DataSourceViewID>
            <TableID>dbo_tblFact</TableID>
          </Source>
          <StorageMode>Molap</StorageMode>
          <CurrentStorageMode>Molap</CurrentStorageMode>
          <ProcessingMode>Regular</ProcessingMode>
          <ProactiveCaching dwd:design-time-name="40b91830-4650-4759-a4c8-373d48de7a0c">
            <SilenceInterval>-PT1S</SilenceInterval>
            <Latency>-PT1S</Latency>
            <SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
            <ForceRebuildInterval>-PT1S</ForceRebuildInterval>
            <AggregationStorage>MolapOnly</AggregationStorage>
            <Source xsi:type="ProactiveCachingInheritedBinding" dwd:design-time-name="bc64c28a-2357-4623-8e4a-953c835fdb66">
              <NotificationTechnique>Server</NotificationTechnique>
            </Source>
          </ProactiveCaching>
          <EstimatedRows>2155</EstimatedRows>
          <AggregationDesignID>AggregationDesign 1</AggregationDesignID>
        </Partition>
      </Partitions>
      <AggregationDesigns>
        <AggregationDesign>
          <ID>AggregationDesign 1</ID>
          <Name>AggregationDesign 1</Name>
          <CreatedTimestamp>2006-05-12T23:29:56Z</CreatedTimestamp>
          <LastSchemaUpdate>2006-05-12T23:29:56Z</LastSchemaUpdate>
          <EstimatedRows>2155</EstimatedRows>
          <Dimensions>
            <Dimension>
              <CubeDimensionID>Vw Products</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Vw Products</AttributeID>
                  <EstimatedCount>77</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Category Name</AttributeID>
                  <EstimatedCount>8</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Product Name 1</AttributeID>
                  <EstimatedCount>77</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Vw Geography</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Vw Geography</AttributeID>
                  <EstimatedCount>87</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>City</AttributeID>
                  <EstimatedCount>69</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>State</AttributeID>
                  <EstimatedCount>19</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Country</AttributeID>
                  <EstimatedCount>21</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Vw Suppliers</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Vw Suppliers</AttributeID>
                  <EstimatedCount>77</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Supplier Name</AttributeID>
                  <EstimatedCount>29</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Vw Shippers</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Vw Shippers</AttributeID>
                  <EstimatedCount>3</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Vw Employees</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Vw Employees</AttributeID>
                  <EstimatedCount>9</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Employee Name</AttributeID>
                  <EstimatedCount>9</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Time</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Year</AttributeID>
                  <EstimatedCount>3</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Date</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>TimeKey</AttributeID>
                  <EstimatedCount>480</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>English Month Name</AttributeID>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>OrgChart</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Employees</AttributeID>
                  <EstimatedCount>9</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Reports To</AttributeID>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>Ship Geography</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Tbl Fact</AttributeID>
                  <EstimatedCount>20</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Ship Country</AttributeID>
                  <EstimatedCount>21</EstimatedCount>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>ServerTime</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Year</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Month</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Date</AttributeID>
                  <EstimatedCount>911</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Month</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter of Year</AttributeID>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>ServerTime 1</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Year</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Month</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Date</AttributeID>
                  <EstimatedCount>911</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Month</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter of Year</AttributeID>
                </Attribute>
              </Attributes>
            </Dimension>
            <Dimension>
              <CubeDimensionID>ServerTime 2</CubeDimensionID>
              <Attributes>
                <Attribute>
                  <AttributeID>Year</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Month</AttributeID>
                  <EstimatedCount>912</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Date</AttributeID>
                  <EstimatedCount>911</EstimatedCount>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Day of Month</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Year</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Month of Quarter</AttributeID>
                </Attribute>
                <Attribute>
                  <AttributeID>Quarter of Year</AttributeID>
                </Attribute>
              </Attributes>
            </Dimension>
          </Dimensions>
          <Aggregations>
            <Aggregation>
              <ID>Aggregation 0</ID>
              <Name>Aggregation 0</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Geography</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Suppliers</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Shippers</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Vw Shippers</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Employees</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Time</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Year</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                  <Attributes>
12345

sales.partitions - 源码说明

本页面展示了「&lt; SQL Server2005程序设计&gt;」中的 sales.partitions 源码文件，采用 PARTITIONS 编程语言编写，共 1,639 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Server相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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