Planning and Consolidation provides custom Microsoft SSIS tasks that allow you to manage your data and perform unattended administration tasks. You can also create your own custom tasks for use in Planning and Consolidation.
Before you can use a custom task in Data Manager, take the following steps:
Register the task. See Registering Custom Tasks.
Add the task to a package. See Adding and Modifying Packages.
The following table describes the custom tasks that are provided in Planning and Consolidation:
Task |
More Information |
DumpLoad |
This task has a number of data dump and data retrieval functions. See DumpLoad Task Usage. |
Admin |
This task enables you to run one of a number of eAdmin tasks through Microsoft SSIS. See Admin Task Usage. |
Send Mail |
This task sends an e-mail message before or after another task has processed. See Send Mail Task Usage. |
Trigger |
This task allows you to wait for a trigger condition before processing the next task. See Trigger Task Usage. |
System Available |
This task allows you to control whether the system is set to available (online) or not available (not online) status. |
FTP |
This task allows you to transfer data files from an FTP site to the Planning and Consolidation server. See FTP Task Usage. |
Logic |
This task is a Microsoft SSIS version of the Planning and Consolidation Logic module that can be used from within the Data Manager module. This allows you to use the full power of the logic module in a batch setting. See Logic Task Usage. |
Convert |
This task takes an input data and transformation file (which may or may not use conversion files) to create an output file. For example, an input file could be a file exported from a similar product. You can use transformation and conversion files to convert to the Planning and Consolidation format. |
Make Dimension |
This task creates dimension members using a Microsoft SQL Server table and schedules the processing of dimension members. For example, if a new member ID is added, this process updates the fac2 table with the updated list. |