Skip to content

source-element-xmla.md

Latest commit

 

History

History
88 lines (75 loc) · 3.85 KB

source-element-xmla.md

File metadata and controls

88 lines (75 loc) · 3.85 KB
title Source Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Source Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
urn:schemas-microsoft-com:xml-analysis#Source
microsoft.xml.analysis.source
helpviewer_keywords
Source element
ms.assetid 4d4665ae-e20f-4baf-ab0f-848660caf500
caps.latest.revision 17
author jeannt
ms.author jeannt
manager erikre

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 Sources
Child elements CubeID, DatabaseID, MeasureGroupID, PartitionID

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 Adventure Works cube of the [!INCLUDEssAWDWsp] sample [!INCLUDEssASnoversion] 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>

See Also

Target Element (XMLA)
Properties (XMLA)