Sources Element (XMLA)
Contains a collection of Source elements for the parent MergePartitions element.
Syntaxe
<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 |
|
Child elements |
Notes
Exemple
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>