PPSCMD is the PerformancePoint Command Utility which is installed with the PerformancePoint Business Modeler. The tool is run from the command line and is called ppscmd.exe. The tool allows you to automate processes like loading data, updating dimensions and creating and deleting objects in PerformancePoint. More than likely you will integrate ppscmd into an SSIS (SQL Server Integration Services) package or create batch files and run it from the command line. Prior to CTP4 there was not a lot of documentation on the utility except in the Data Integration help file (search for: "Scriptable data integration"). In CTP4 the ppscmd utility is well documented in the Operation Guide (search for: "Using the PerformancePoint Planning Command Utility").
If you are running it from the command line you will want to add ppscmd.exe to the computers path. Below is an example of how to export the Account Dimension using ppscmd :
ppscmd ExportDimension /server http://myserver:46787 /app My_Application /site Corporate /dim Account "My Documents"
Here is how it works.
- ExportDimesion is the command you are executing
- /server option is the PerformancePoint Server address
- /app option is the PerformancePoint application
- /site option is the model site within the application
- /dim option is the dimension you are exporting
Finally the "My Documents" is the destination folder on the local machine for the export. This script will create a comma separated file with all the Account Dimension data. This is useful if you want to make some manual changes to the Account Dimension. You can export the Account dimension file and make the changes in Excel. You could then use the ppscmd to import it back into PerformancePoint. Of course you could just use the Business Modeler to do this but it depends on what type of changes you need to make. Excel has a lot of useful formulas and sorting functionality which can save you a lot of time especially if you have a large number of members in a Dimension.