Show TOC

Procedure documentationOptimizing the Application Locate this document in the navigation structure

 

To automate application optimization, select the Optimize application option. You can optimize the application in preparation for a task or as part of the maintenance subsequent to a task.

Prerequisites

You have advanced knowledge of Microsoft SSIS.

The Admin task (OSoftTaskAdmin2008.dll) is registered with Microsoft SSIS. See Registering Custom Tasks.

Procedure

  1. Open a package or create a new package in Microsoft SSIS on the Planning and Consolidation server.

  2. Select the task and add it to the package. See Adding and Modifying Packages.

  3. Open the task and choose Optimize application.

  4. Enter the application set, application, and the user ID.

    Note Note

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

    End of the note.

  5. Select an application.

  6. Select Lite, Incremental, or Full optimization and whether or not to compress the database.

  7. 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.