sales.cube

来自「< SQL Server2005程序设计>」· CUBE 代码 · 共 1,134 行 · 第 1/4 页

    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
      <Value>-1433</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>-3069</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>-741</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
      <Value>-2461</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
      <Value>100</Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T05:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Dimensions>
    <Dimension dwd:design-time-name="f849562e-5a35-4839-b970-15f567d21389">
      <ID>Vw Products</ID>
      <Name>Products</Name>
      <DimensionID>Vw Products</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="880a7eee-a765-4d4e-a535-38ebe636aa04">
          <AttributeID>Vw Products</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="f057f33b-8530-4b41-97b5-45f31075ee29">
          <AttributeID>Category Name</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="9fdf2d8c-ab52-4e2d-9f3b-6180f53247d8">
          <AttributeID>Product Name 1</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="138f9f75-68fd-4c99-9896-4f23a44658e0">
          <HierarchyID>Hierarchy</HierarchyID>
        </Hierarchy>
        <Hierarchy dwd:design-time-name="ba5e12cc-778d-4197-8f10-ced8b050667e">
          <HierarchyID>Hierarchy 1</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="267a4b26-9d76-413c-9ece-fdb75e64f0e8">
      <ID>Vw Geography</ID>
      <Name>Geography</Name>
      <DimensionID>Vw Geography</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="b3d21253-388b-4036-80ca-d790881e333c">
          <AttributeID>Vw Geography</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="54ca1e14-a1eb-44bc-bfbc-26a1df85ff49">
          <AttributeID>City</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="c5e9d011-9ef0-4c8b-b7b8-0ae74633de00">
          <AttributeID>State</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="bc9b3b79-2484-4649-906f-b709cfbdd1f1">
          <AttributeID>Country</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="24eb476c-40f6-47f9-b968-c187098fd4ce">
          <HierarchyID>Hierarchy</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="56137d60-6073-49e7-992b-f46fbc447d75">
      <ID>Vw Suppliers</ID>
      <Name>Suppliers</Name>
      <DimensionID>Vw Suppliers</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="2a5688c7-9fb9-4c6e-a673-1be8ea00aa60">
          <AttributeID>Vw Suppliers</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="bd2f30b9-005f-4766-b152-edea8a4ef817">
          <AttributeID>Supplier Name</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="910b61d0-e558-4da3-8da3-f742ced19908">
      <ID>Vw Shippers</ID>
      <Name>Shippers</Name>
      <DimensionID>Vw Shippers</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="4e092e53-9f4e-4443-bf9d-6f31316d2fdf">
          <AttributeID>Vw Shippers</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="e7243f01-7120-471a-9a79-198f0554f501">
      <ID>Vw Employees</ID>
      <Name>Employees</Name>
      <DimensionID>Vw Employees</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="7be750b7-78d5-43b5-96aa-f1789b445e8a">
          <AttributeID>Vw Employees</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="8e8bb894-a668-4edf-8f26-c8f740be20b4">
          <AttributeID>Employee Name</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="7864dae5-bc09-4e8d-a377-b2eadd57610e">
      <ID>Time</ID>
      <Name>Time</Name>
      <Translations>
        <Translation dwd:design-time-name="ca650274-b78a-4d5a-9870-6d4385a98ccf">
          <Language>3082</Language>
          <Caption>Tiempo</Caption>
        </Translation>
      </Translations>
      <DimensionID>Tbl Time</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="aed0303e-3ded-42f5-9a88-d5679a014b63">
          <AttributeID>Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="4e85bc38-6cca-4f7b-90e2-f597dc4a01b6">
          <AttributeID>Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="92efa684-59f5-448c-9e84-128bbe264768">
          <AttributeID>Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="b1d3d861-ed13-4c8b-9683-539448641eab">
          <AttributeID>Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7c7bfd54-b42a-43a4-a4f1-4732c762f018">
          <AttributeID>TimeKey</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="cc223df5-8342-4996-885d-8fea14754b8b">
          <AttributeID>English Month Name</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="cc0775e0-7790-4927-86b6-8d895b654242">
          <HierarchyID>Year -  Quarter -  Month -  OrderDate</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="7a8dc7aa-4450-40a4-9280-f6c3701d1d88">
      <ID>OrgChart</ID>
      <Name>OrgChart</Name>
      <DimensionID>Employees 1</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="e8b21f17-de8e-4327-9db6-497b4340a2d0">
          <AttributeID>Employees</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="de18640a-03a4-4471-95e8-3154176adc5c">
          <AttributeID>Reports To</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="348868c9-e276-483c-965f-a46cc9c09e6e">
      <ID>Ship Geography</ID>
      <Name>Ship Geography</Name>
      <DimensionID>Tbl Fact</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="6a0f299c-de45-445b-82d9-6d378a8141e7">
          <AttributeID>Tbl Fact</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="bb477b47-4795-4188-b8f6-3b6a6fa4692c">
          <AttributeID>Ship Country</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="6c258614-dda8-4388-acdf-2d746c56efdb">
          <HierarchyID>Hierarchy</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="d70b1084-e8c5-40d7-9642-3cae03906caa">
      <ID>ServerTime</ID>
      <Name>Order Date</Name>
      <DimensionID>Time 1</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="b0b14808-1f02-449b-a399-9088f358aac2">
          <AttributeID>Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7ba11625-e243-4e96-9b39-bec10636345f">
          <AttributeID>Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="dda0ef4d-ee57-42b0-9dad-a882d115d539">
          <AttributeID>Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="eb66c677-e522-43b2-92b1-1f91ee35cbc3">
          <AttributeID>Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="727e3d6e-90f8-49f6-91d6-4e98f8f54429">
          <AttributeID>Day of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="96cdc09d-dbc9-4490-8eb7-712671f3999e">
          <AttributeID>Day of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7012199c-09b3-4e5a-b806-11fdf3999617">
          <AttributeID>Day of Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="72e7a156-d9c1-4ddd-88a6-30d75e76fa25">
          <AttributeID>Month of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="32066dca-5e25-4438-9f90-e2a8b7eb8e4d">
          <AttributeID>Month of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="da9e8827-a234-4072-a3a1-efe1264ff785">
          <AttributeID>Quarter of Year</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="c8d7151d-a0aa-4be0-91ea-8e4d5b85dabf">
          <HierarchyID>Year -  Quarter -  Month -  Date</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="41846d25-81dc-4ce5-8393-02499a9771d9">
      <ID>ServerTime 1</ID>
      <Name>Shipped Date</Name>
      <DimensionID>Time 1</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="bbd18185-d825-415a-924d-c5681cd3393e">
          <AttributeID>Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="aa67ada2-3d42-43cc-b2ef-9e263d518fe9">
          <AttributeID>Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="b2c57866-0e68-459f-bc12-c249dc57aa0d">
          <AttributeID>Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="039d6fb4-5d7b-49d6-92ee-9ae0a28cf455">
          <AttributeID>Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ac047bed-ddf7-460b-bf8a-90d95ee3b8da">
          <AttributeID>Day of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="a2ee77d9-6d29-4976-8d82-7e7b20a7a0f9">
          <AttributeID>Day of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="9e4a5b0d-8697-4040-89a5-c12b74136cdb">
          <AttributeID>Day of Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="2d2dd39f-94f5-4c36-b828-d43f6f887074">
          <AttributeID>Month of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="275031c7-37c0-40c9-838c-5932c5fd02f1">
          <AttributeID>Month of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="c28b5cf7-059e-4a52-9476-b2cfce2b6ee9">
          <AttributeID>Quarter of Year</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="4644e20f-7006-48cf-ab4c-a8705b54bd09">
          <HierarchyID>Year -  Quarter -  Month -  Date</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="054dac27-b798-4b13-b69b-b31bd0bc4b84">
      <ID>ServerTime 2</ID>
      <Name>Required Date</Name>
      <DimensionID>Time 1</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="4bda7723-c668-4094-8d95-1abf09b5c65a">
          <AttributeID>Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="2c433e4d-1b7f-4234-9b1b-cf60bb45e156">
          <AttributeID>Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="39ef9d31-e324-4ea5-8527-0ffc419e58e4">
          <AttributeID>Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="ff592fab-e4de-42cc-8ba1-0fcead4b5bda">
          <AttributeID>Date</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e86bdf23-a2d2-4bc4-bb90-b0d99001c117">
          <AttributeID>Day of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="dd19f260-9867-4feb-bc66-5041f270d18e">
          <AttributeID>Day of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="015f0937-fdb3-4c5a-832b-19e5174b9c35">