About Data Export jobs
Data Export jobs allow data that is generated in Planning Server to be exported to an external database. This job can be started, but cannot be created, from PerformancePoint Add-in for Excel.
To perform the tasks in a Data Export job, Planning Business Modeler runs a business rule that is called an Outbound rule. For information how to use this rule, see How do I export data with an outbound rule?
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).
Templates and properties
If you selected the DataExport template for this job, you must set the following properties to run the job:
Job property name | Description |
---|---|
Target Model |
The value that you select here will affect the list of rule sets available in the Rule Set property. |
Rule Set |
The Outbound rule set to be run for the selected target model. |
Outbound Destination |
External SQL Server database to which the data will be exported. |
Flatten Dimension Data |
This option enables you to select a star schema or a snow flake schema. |
Model Site |
The model site in which the model exists. |