OlapPartitionManager Command-Line Options

The OlapPartitionManager now supports the following command-line options:

DatabaseName /d

Optional argument which provides the name of the OLAP database you wish to deploy. This should match one of the OLAP database names returned by the OlapPartitions view. If the DatabaseName does not match OlapPartitions 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 database that has just been deployed. The DatabaseName argument identifies the OLAP 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 databases that are listed in the OlapPartitions view. This can be used independently from all other command-line arguments.
Example:
OlapPartitionManager.exe /p ProcessAll

Example Command-Lines

Deploy a new OLAP database and add partitions:

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

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

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

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

OlapPartitionManager.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 databases found in the OlapPartitions view:

OlapPartitionManager.exe /p ProcessAll

Last edited May 18, 2015 at 3:46 PM by JohnTunnicliffe, version 4