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. 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