About Data Export jobs

When you run a Data Export job, PerformancePiont Planning Business Modeler exports data from PerformancePoint Planning Server to a specified external database. This makes the semantically rich data that is stored in Planning Server available to an extended business user community. Modelers and analysts can then use the data in other applications. For example, at the end of a budget cycle, a customer might want to use new data values from an application such as SAP.

To perform the tasks in a Data Export job, a Modeler or Data Administrator must first create an Outbound rule or rule set that specifies actions for the data export. Then, a Data Administrator must include the rule or rule set in a Data Export job template. Then, the administrator can run the job, or assign the job to a specified user. For information about how to create a job template, see Create a job template. For a roadmap of the data export process, see How do I export data with an Outbound rule?

This job can be started, but cannot be created, from PerformancePoint Add-in for Excel.

 Note   When you run a Data Export job, Planning Server logs the time the export was created, and the time the file was last changed. This log time value is expressed in Coordinated Universal Time (UTC).

Properties for a Data Export job

When you create a Data Export job template, you must set values for the following job-specific properties.

Job property Description
Target Model Specifies the name of the model that contains the Outbound rule set that you want the Data Export job to run. This value determines the list of rule sets that are available in the Rule Set property.
Rule Set Specifies the name of the Outbound rule set that you want the Data Export job to run.
Outbound Destination Specifies the external SQL Server database to which the data will be exported.
Flatten Dimension Data Indicates the dimension structure of the exported data. That is, it indicates whether the data has a star schema or a snow flake schema.
Model Site Specifies the name of the model site in which the Target Model exists.

For information about how to run this job, see Define or schedule a job task.