SSAS Partition Manager Command-Line Options

The SSAS Partition Manager now supports the following command-line options:

DatabaseName /d

Optional argument which provides the name of the OLAP or Tabular database you wish to deploy. This should match one of the OLAP or Tabular database names returned by the SsasPartitions view. If the DatabaseName does not match SsasPartitions view, the cube will be deployed but no partitions will be created.

AsDatabaseFilePath /a

Optional argument which provides the full path to the .asdabase file. Use double quotes if the file path contains space characters. This can only be used when /d command-line argument has been specified.

ConnectionStringToDataMart /c

Optional argument which allows you to override the connection string to the data mart embedded in the .asdabase file. This can only be used when /d and /a command-line arguments have been specified.

ProcessOptions /p

Optional argument which defines what to process once the partitions have been created.
  • ProcessDeployed will process the OLAP or Tabular database that has just been deployed. The DatabaseName argument identifies the OLAP or Tabular database that will be processed. This can only be used when /d and /a command-line arguments have been specified.
  • ProcessAll will process all the OLAP or Tabular databases that are listed in the SsasPartitions view. This can be used independently from all other command-line arguments.
Example:
SSASPartitionManager.exe /p ProcessAll

Example Command-Lines

Deploy a new OLAP or Tabular database and add partitions:

SSASPartitionManager.exe /d AdventureWorks /a "C:\Dev\Samples\AdventureWorks.asdatabase"

Deploy a new OLAP or Tabular database, add partitions and process the newly deployed database:

SSASPartitionManager.exe /d AdventureWorks /a "C:\Dev\Samples\AdventureWorks.asdatabase" /p ProcessDeployed

Deploy a new OLAP or Tabular database, override the standard connection string to the Data Mart, add partitions and process the newly deployed database:

SSASPartitionManager.exe /d AdventureWorks /a "C:\Dev\Samples\AdventureWorks.asdatabase" /c "Provider=SQLNCLI11.1;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW2014" /p ProcessDeployed

Perform a full process on all OLAP or Tabular databases found in the SsasPartitions view:

SSASPartitionManager.exe /p ProcessAll

Last edited May 26, 2015 at 7:44 PM by JohnTunnicliffe, version 1