You can script data integration steps as outlined in this documentation, by using the Planning Command Utility, which is available when you install Planning Business Modeler. The utility is in the same directory as Planning Business Modeler.
To see Help for staging database operations, type PPSCmd help StagingDB at a command prompt.
PPSCmd help StagingDB
To perform data integration operations, you must be a member of the Data Administrator role in Planning Business Modeler. To perform database operations, you must also have explicit permissions to that database. For more information, see Security roles.
The PPSCmd.exe StagingDB command enables you to perform data integration functions by using the switches that are listed in the following table.
PPSCmd.exe StagingDB
Commands and switches are case sensitive.
/Operation <Operation>
CreateStaging |
RefreshStaging |
SynchronizeData |
LoadDataFromStaging
X
Indicates which of the following operations will run:
CreateStaging. Use to create a staging database when an application already exists.
RefreshStaging. Use to make sure that staging database stored procedures and functions are compatible with the current version on the computer that is running Planning Server.
SynchronizeData. Use to synchronize the data structures and data between the application database and the staging database.
LoadDataFromStaging. Use to load data from the staging database to the application database.
/Server <ServerUri>
Indicates the uniform resource identifier (URI) of the server to which you want to connect.
/Path <Path>
Indicates the path of the object that defines the scope of the staging operation.
/Collection <Collection>
Dimensions |
Models |
Associations
Indicates a groups of objects to synchronize in model sites:
Dimensions. Indicates dimensions in a model site to synchronize.
Models. Indicates models in a model site to synchronize.
Associations. Indicates associations in the application to synchronize. The /Collection Associations operation is available for migration purposes.
/Collection Associations
/NoValidation
Instructs Planning Business Modeler not to perform validation when data is loaded. By default, validation occurs when you load data.
Consider the following when you use /NoValidation:
Loading data without validation might deliver unwanted results. We recommend that you run the validation of stored procedures before you load the data. Use the Planning Command Utility with the /NoValidation switch.
/CurrentSite
Indicates the site from which the dimension is being loaded. The default is the site at which the dimension was created, which is called the owner site.
This section shows various examples of data integration commands.
This example shows the StagingDB command and CreateStaging command. The /Server <ServerURI> switch calls the Planning Web Service to create the staging database and have the database associate with the existing Alpine_Ski_House application.
/Server <ServerURI>
PPSCmd.exe StagingDB /Operation CreateStaging /Server http://localhost:46787 /Path Alpine_Ski_House
This example shows the StagingDB command and RefreshStaging command. The /Server <ServerURI> switch calls the Planning Web Service to refresh the staging database by using stored procedures and functions from the current version on the computer that is running Planning Server.
PPSCmd.exe StagingDB /Operation RefreshStaging /Server http://localhost:46787 /Path Alpine_Ski_House
This example shows a command that uses the SynchronizeData command to synchronize a dimension and its related hierarchies from the Alpine_Ski_House application database.
PPSCmd.exe StagingDB /Operation SynchronizeData /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_C orporate.dimension:Currency
These examples show commands that use the /Collection switch to synchronize a collection of dimensions and their related hierarchies.
Synchronize All Dimensions in All Models
PPSCmd.exe StagingDB /Operation SynchronizeData /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_Corporate.Corporate /Collection models
Synchronize All Dimensions
PPSCmd.exe StagingDB /Operation SynchronizeData /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_Corporate.Corporate /Collection dimensions
Synchronize Dimensions in Associations
PPSCmd.exe PPSCmd.exe StagingDB /Operation SynchronizeData /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_C orporate /Collection associations
This example shows a Product dimension that is being loaded from the Manufacturing model site. The dimension is owned by the ASH_Corporate model site. If /CurrentSite is not specified site ASH_Corporate is the default.
ASH_Corporate
PPSCmd.exe StagingDB /Operation LoadDataFromStaging /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_Corporate.dimension:Product /CurrentSite Manufacturing
This example shows the SynchronizeData operation to synchronize Corporate Mgmt model data from the staging database to the Alpine_Ski_House application database.
Corporate Mgmt
PPSCmd.exe StagingDB /Operation SynchronizeData /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_Corporate.model:Corporate Mgmt
This example shows the LoadDataFromStaging operation, which loads consolidation model data to the Alpine_Ski_House application from the staging database.
PPSCmd.exe StagingDB /Operation LoadDataFromStaging /Server http://localhost:46787 /Path Alpine_Ski_House.ASH_Corporate.model:ConsolidationModel
This topic is included in the following downloadable book for easier reading and printing:
Planning Server Planning and Architecture Guide for PerformancePoint Server 2007
See the full list of available books at Downloadable content for PerformancePoint Planning Server.