Export (0) Print
Expand All
Expand Minimize

Source Element (XMLA)

Represents a source partition to be merged during a MergePartitions command.

<Sources>
   <Source>
      <DatabaseID>...</DatabaseID>
      <CubeID>...</CubeID>
      <MeasureGroupID>...</MeasureGroupID>
      <PartitionID>...</PartitionID>
   </Source>
</Sources>

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

1-n: Required element that can occur more than once.

Relationship

Element

Parent elements

Sources

Child elements

CubeID, DatabaseID, MeasureGroupID, PartitionID

The Source element is an object reference to a single partition to be merged into a target partition specified by the Target element of the parent MergePartitions element.

The following example combines all four partitions of the Internet Sales measure group into the Internet_Sales_2004 target partition. The example refers to the Adventure Works cube of the Adventure Works DW Multidimensional 2012 sample Analysis Services database.

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

Community Additions

ADD
Show:
© 2014 Microsoft