sales.cube

< SQL Server2005程序设计>

        </Attribute>
        <Attribute dwd:design-time-name="f057f33b-8530-4b41-97b5-45f31075ee29">
          <AttributeID>Category Name</AttributeID>
        </Attribute>
      </Attributes>
    </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>
        <Attribute dwd:design-time-name="6b256336-5175-4a80-b19f-306489e82b10">
          <AttributeID>Shipper Name</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>
      <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>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="cc0775e0-7790-4927-86b6-8d895b654242">
          <HierarchyID>Year -  Quarter -  Month -  OrderDate</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
  </Dimensions>
  <MeasureGroups>
    <MeasureGroup dwd:design-time-name="7fc83991-7670-44a1-98d3-304aa6ca0971">
      <ID>Tbl Fact</ID>
      <Name>Main</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T05:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Measures>
        <Measure dwd:design-time-name="cda4a6d5-6391-42d2-a312-a53dc1ec740d">
          <ID>Total Sales</ID>
          <Name>Total Sales</Name>
          <Source dwd:design-time-name="4e521fb3-5087-4996-9564-0ae4f019e8f4">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="1c820d1c-f944-481c-8439-9af7ca832026">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Total_x0020_Sales</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="7a650fcc-9dbd-4fd5-9710-7d68107c89d9">
          <ID>Discount</ID>
          <Name>Discount</Name>
          <Source dwd:design-time-name="2e6dee19-cc16-450b-9bc5-4688d84eeaf3">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="3be98c44-a005-4551-aecc-c645009fa602">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Discount</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="36b90c2c-d582-4355-856b-b3a53aa31c09">
          <ID>Unit Sales</ID>
          <Name>Unit Sales</Name>
          <Source dwd:design-time-name="f7852c09-df93-408b-8f70-483885b2b2c5">
            <DataType>Integer</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="9b3a186e-0771-421b-bd78-70581d4c24ad">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Unit_x0020_Sales</ColumnID>
            </Source>
          </Source>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="3def588b-9de9-4ac2-95df-55af3f295e9d">
          <CubeDimensionID>Vw Products</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="878f292b-4773-47ba-8e7a-7f74bf1898e2">
              <AttributeID>Vw Products</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="66e5d140-28fc-4e75-992f-441286cf95e9">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9652d2fe-6b83-4018-99cb-5c1ed8e215a9">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ProductID</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="a7d824bd-2580-4fd1-b943-2c8e5f79c331">
          <CubeDimensionID>Vw Geography</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="c8131dd3-19b1-4a65-a32a-751cec354aeb">
              <AttributeID>Vw Geography</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="41e2c40d-c543-46fe-a48d-10b0fae9e20f">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>WChar</DataType>
                  <DataSize>10</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9e374d85-3f0a-475a-9558-49cbbc3fb8e0">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>PostalCode</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="20bbc1d4-a5c8-4e5c-aeba-e45462125bce">
          <CubeDimensionID>Vw Suppliers</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ae363a0b-7389-4d2e-9436-8eb75e50f96b">
              <AttributeID>Vw Suppliers</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="cbf60a77-9056-4149-9b9f-3a7c78da5764">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="d908b80d-383d-45b9-8f48-37f13a994b47">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ProductID</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="b2bee93e-a734-4e72-a174-6902a1594063">
          <CubeDimensionID>Vw Shippers</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="70ec44db-efea-40a1-8e5d-608589943197">
              <AttributeID>Vw Shippers</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="80ecf7bc-ce8c-4a7c-b501-ebcde58a9d5e">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="3c8a94fd-d723-48fc-bb01-15c2b6622fc6">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ShipperId</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="f1910ba8-9371-4972-9ccf-d9e997ada27a">
          <CubeDimensionID>Vw Employees</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="43594b43-e202-4208-ac85-6c48150234cb">
              <AttributeID>Vw Employees</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="a5d199d4-6446-4cc6-a7de-1b1ef3490ac0">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="bed243cc-3d70-43e0-84df-5b7202931251">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>EmployeeId</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="3899ee78-574b-4613-ba7b-80dde8966b9f">
          <CubeDimensionID>Time</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="d3caef9c-9eb2-4954-a922-e8385be85166">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="582c5ec1-d91f-4fdc-abd3-6f9d1d6867ce">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="63f7d4b3-3358-4fd6-b2b7-6a4679ae2c27">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>TimeKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
    </MeasureGroup>
  </MeasureGroups>
  <Source dwd:design-time-name="1b38a3dd-7b36-4a7a-b856-3a5b751fad95">
    <DataSourceViewID>Northwind</DataSourceViewID>
  </Source>
</Cube>