Source Element (XMLA)
Represents a source partition to be merged during a MergePartitions command.
Syntax
<Sources>
<Source>
<DatabaseID>...</DatabaseID>
<CubeID>...</CubeID>
<MeasureGroupID>...</MeasureGroupID>
<PartitionID>...</PartitionID>
</Source>
</Sources>
Element Characteristics
Characteristic |
Description |
|---|---|
Data type and length |
None |
Default value |
None |
Cardinality |
1-n: Required element that can occur more than once. |
Element Relationships
Relationship |
Element |
|---|---|
Parent elements |
|
Child elements |
Remarks
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.
Example
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 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>