Sources Element (XMLA)

  • 아티클

Contains a collection of Source elements for the parent MergePartitions element.

구문

<MergePartitions>
...
   <Sources>
      <Source>...</Source>
   </Sources>
...
</MergePartitions>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element

Parent elements

MergePartitions

Child elements

Source

주의

예

The following example combines all four partitions of the Internet Sales measure group into the Internet_Sales_2004 target partition. The example uses the AdventureWorks cube of the AdventureWorks sample Analysis Services database.

<MergePartitions xmlns="https://schemas.microsoft.com/analysisservices/2003/engine">
  <Sources>
    <Source>
      <DatabaseID>database</DatabaseID>
      <CubeID>Adventure Works DW</CubeID>
      <MeasureGroupID>Fact Internet Sales 1</MeasureGroupID>
      <PartitionID>Internet_Sales_2001</PartitionID>
    </Source>
    <Source>
      <DatabaseID>database</DatabaseID>
      <CubeID>Adventure Works DW</CubeID>
      <MeasureGroupID>Fact Internet Sales 1</MeasureGroupID>
      <PartitionID>Internet_Sales_2002</PartitionID>
    </Source>
    <Source>
      <DatabaseID>database</DatabaseID>
      <CubeID>Adventure Works DW</CubeID>
      <MeasureGroupID>Fact Internet Sales 1</MeasureGroupID>
      <PartitionID>Internet_Sales_2003</PartitionID>
    </Source>
  </Sources>
  <Target>
    <DatabaseID>database</DatabaseID>
    <CubeID>Adventure Works DW</CubeID>
    <MeasureGroupID>Fact Internet Sales 1</MeasureGroupID>
    <PartitionID>Internet_Sales_2004</PartitionID>
  </Target>
</MergePartitions>

참고 항목

개념

Properties (XMLA)

도움말 및 정보

SQL Server 2005 지원 받기