Merge-Partition

This cmdlet merges the data of one or more source partitions into a target partition and deletes the sourcepartitions.

This cmdlet merges the data of one or more source partitions into a target partition and deletes the source partitions. Partitions can be merged only if they meet all the following criteria: Partitions are in the same measure group. Partitions are stored in the same mode (MOLAP, HOLAP, and ROLAP).

Parameters
-Name <System.String>

  • This value is required

Name of the target partition to where the source partitions data will be merged.

-SourcePartitions <System.String[]>

  • This value is required

Source partition names from which data is merged to target partition.

-Database <string>

  • This value is required

Name of the Analysis Server database where the partitions exist.

-Cube <System.String>

  • This value is required

Name of the cube under which the partitions exist.

-MeasureGroup <System.String>

  • This value is required

Name of the Measure Group under which the partitions exist.

-Server <System.String>

  • Default value is localhost

Specifies the Analysis Services instance to which the cmdlet will connect and execute. If not server name is specified, the cmdlet will try to connect to localhost. For default instances, only specify the computer name: “MyComputer”. For named instances, use the format “ComputerNameInstanceName” For IIS Server, use the format http[s]://server[:port]/virtualdirectory/msmdpump.dll.

-Credentials <PSCredential>

If this parameter is specified, the user name and password passed will be used to connect to specified Analysis Server instance. If no credentials are specified default windows account of the user who is running the tool will be used.

-TargetPartition <Microsoft.AnalysisServices.Partition>

  • This value is required
  • Accepts pipeline input

Target partition object to where the source partitions data will be merged.

<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,ErrorAction, ErrorVariable, WarningAction, WarningVariable,OutBuffer, PipelineVariable, and OutVariable.

Inputs

System.String

Examples
  1. Merges the Partitions “customers_2006”, “customers_2007” and “customers_2008” into the partition “customers_2005”:
    C:PS> $sources = "customers_2006","customers_2007","customers_2008"
    
                           Merge-Partition -Name:Customers_2005, -SourcePartitions:$sources -Database:"AdventureWorksDW" 
       -Cube:"Adventure Works" -MeasureGroup:"Internet Customers"
Additional Notes