title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
---|---|---|---|---|---|---|---|---|
Source Element (XMLA) | Microsoft Docs |
Learn how the Source element represents a source partition to be merged during a MergePartitions command. |
01/05/2020 |
analysis-services |
xmla |
reference |
kfollis |
kfollis |
kfollis |
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 sample 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>