time.dim

< SQL Server2005程序设计>

          <ColumnID>Month</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="054791e2-5ac7-41d3-9e8f-d2d5f9162f23">
          <Language>3082</Language>
          <Caption>Mes</Caption>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="d355a75e-533f-45eb-ba8c-18264722b8e6">
      <ID>Date</ID>
      <Name>OrderDate</Name>
      <Type>Days</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="4f52d936-d9fc-4113-8719-f0b3b2280445">
          <DataType>Date</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="6f3171ef-942d-4529-b56c-9f8fb2a829e2">
            <TableID>dbo_tblTime</TableID>
            <ColumnID>OrderDate</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="3b856683-d341-4354-a23f-dada69e4616c">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="69d3f88a-6521-4917-8df3-868093e24b4d">
          <TableID>dbo_tblTime</TableID>
          <ColumnID>OrderDate</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="437ad922-ebca-436b-a41a-feeabee01a9a">
          <Language>3082</Language>
          <Caption>Fecha de la Orden</Caption>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="e7b73be6-6734-48d8-ad2e-a73d15096fb6">
      <ID>TimeKey</ID>
      <Name>TimeKey</Name>
      <Usage>Key</Usage>
      <EstimatedCount>480</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9a25da22-e93a-4b06-bbda-abfc593e49d8">
          <DataType>Integer</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="41810f1c-3ce5-456d-a242-8bbaa83acf3c">
            <TableID>dbo_tblTime</TableID>
            <ColumnID>TimeKey</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="3f7befbb-db1d-4767-bab6-52ff21939789">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="50b1ee35-3614-4d1c-a6ac-68ca77ca0b9c">
          <TableID>dbo_tblTime</TableID>
          <ColumnID>TimeKey</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="b0b23dc0-22e7-4284-abf2-2b51a8d70381">
          <Language>3082</Language>
          <Caption>Llave de Tiempo</Caption>
        </Translation>
      </Translations>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="b697ac28-d27f-4e0d-925a-22901278918d">
          <AttributeID>Year</AttributeID>
          <Name>Year</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="a298ca88-7d90-4bdc-9e36-31ddb7e1413d">
          <AttributeID>Quarter</AttributeID>
          <Name>Quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="37a5c75d-4b10-4807-99e2-63d611575781">
          <AttributeID>Month</AttributeID>
          <Name>Month</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bc0020e1-5664-42a7-83e2-979e0b537602">
          <AttributeID>Date</AttributeID>
          <Name>OrderDate</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="1a5b8c53-3e7d-41cf-9810-dbc189a1d224">
          <AttributeID>English Month Name</AttributeID>
          <Name>Month Name</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="513fce03-a471-4005-819f-d3caf9ed01cb">
      <ID>English Month Name</ID>
      <Name>Month Name</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="19f64b62-6aec-4baa-9efc-a30117d0b6ab">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8ee15ae6-2c6e-481d-bc98-7f4513865350">
            <TableID>dbo_tblMonthNames</TableID>
            <ColumnID>MonthNumber</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="8e907775-8a1d-4d3f-85d6-1727d85eb94c">
        <DataType>WChar</DataType>
        <DataSize>50</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="b1ef0417-0384-4877-bb6a-ce6116959872">
          <TableID>dbo_tblMonthNames</TableID>
          <ColumnID>EnglishMonthName</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="fb122739-bf50-4542-8083-16ff63ea738e">
          <Language>3082</Language>
          <Caption>Nombre del Mes</Caption>
          <CaptionColumn dwd:design-time-name="ffbea0a9-f4d6-476f-a62e-c6625f152366">
            <DataType>WChar</DataType>
            <DataSize>50</DataSize>
            <Collation>Latin1_General_CI_AS</Collation>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="091202e7-7c3c-47b9-b0f5-5362f8c7a51e">
              <TableID>dbo_tblMonthNames</TableID>
              <ColumnID>SpanishMonthName</ColumnID>
            </Source>
          </CaptionColumn>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="a5a8d8d5-0486-4342-bdb2-04278eb2f195">
      <ID>Year -  Quarter -  Month -  OrderDate</ID>
      <Name>Year -  Quarter -  Month -  OrderDate</Name>
      <Translations>
        <Translation dwd:design-time-name="dd3ef312-8ea6-464e-bb17-b28e288a43a8">
          <Language>3082</Language>
          <Caption>Año - Trimestre - Mes - Fecha de la Orden</Caption>
        </Translation>
      </Translations>
      <Levels>
        <Level dwd:design-time-name="fc249309-1a5f-44f2-8af1-e9ca0c30955e">
          <ID>Year</ID>
          <Name>Year</Name>
          <SourceAttributeID>Year</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="80a4c32d-3835-406f-9509-78c5c6b99d0e">
              <Language>3082</Language>
              <Caption>Año</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="73d294e4-0193-4435-bff2-5b4a372090f2">
          <ID>Quarter</ID>
          <Name>Quarter</Name>
          <SourceAttributeID>Quarter</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="5fbf1268-be64-44dc-b652-6d952289369c">
              <Language>3082</Language>
              <Caption>Trimestre</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="6f0b4747-cfd3-4aca-866b-1f5c77ac45b5">
          <ID>Month</ID>
          <Name>Month</Name>
          <SourceAttributeID>Month</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="f9f53067-237c-4ab1-9c26-9ce25209c140">
              <Language>3082</Language>
              <Caption>Mes</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="e84ea92f-572b-4f75-a438-6f3e9b0256c0">
          <ID>OrderDate</ID>
          <Name>OrderDate</Name>
          <SourceAttributeID>Date</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="7a49d795-4a0e-4c88-ae60-cac097379c45">
              <Language>3082</Language>
              <Caption>Fecha de la Orden</Caption>
            </Translation>
          </Translations>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>