Processing the Application using DumpLoad

You can use DumpLoad to process the application as a standalone procedure, or with data import, export, or clear.

The DumpLoad task (OsoftTaskDumpLoad2008.dll) is registered with Microsoft SSIS. See Registering Custom Tasks.

Open a package or create a new package in Microsoft SSIS on the Planning and Consolidation server.
Select the task and add it to the package.
Open the task, and choose Data Management None .
Enter the application set, application, and user ID.

Note
The user ID must have Planning and Consolidation administrator privileges to validate logic files.

End of the note.
Enter the path and name of an export file.
Select Export time in timeID format if you want the time members to use the TIMEID rather than time member names.
You can enter a selection file that contains a list of dimensions and members to export, or a Microsoft SQL Server statement that returns the member list needed for export.
Click OK.

Note Note

You can use TASK commands in the MODIFYSCRIPT Package Variable task to automatically complete the information for you.

End of the note.