sales.partitions

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

              <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>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Vw Employees</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Time</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Year</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation 8</ID>
              <Name>Aggregation 8</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Geography</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Country</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Suppliers</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Shippers</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Employees</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Time</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Tbl Fact</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation 9</ID>
              <Name>Aggregation 9</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Category Name</AttributeID>
                    </Attribute>
                  </Attributes>
                </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>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Tbl Fact</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation a</ID>
              <Name>Aggregation a</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Category Name</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Geography</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Suppliers</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Shippers</CubeDimensionID>
                </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>
                    <Attribute>
                      <AttributeID>Tbl Fact</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation b</ID>
              <Name>Aggregation b</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>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Employees</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Time</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>TimeKey</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation c</ID>
              <Name>Aggregation c</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Category Name</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Geography</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Country</AttributeID>
                    </Attribute>
                  </Attributes>
                </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>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>OrgChart</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Ship Geography</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 1</CubeDimensionID>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>ServerTime 2</CubeDimensionID>
                </Dimension>
              </Dimensions>
            </Aggregation>
            <Aggregation>
              <ID>Aggregation d</ID>
              <Name>Aggregation d</Name>
              <Dimensions>
                <Dimension>
                  <CubeDimensionID>Vw Products</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Category Name</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Geography</CubeDimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Country</AttributeID>
                    </Attribute>
                  </Attributes>
                </Dimension>
                <Dimension>
                  <CubeDimensionID>Vw Suppliers</CubeDimensionID>