Show TOC

Procedure documentationClear Data from SQL Locate this document in the navigation structure

 

You can clear data from the Microsoft SQL Server database. If the work status for a set of data is locked, the data is not cleared from the database.

Prerequisites

The DumpLoad task (OSoftTaskDumpLoad2008.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   Data Management   Clear data from SQL  .

  4. Fill in the application set, application, and the user ID.

    Note Note

    The user ID must have Planning and Consolidation administrator privileges to validate logic files. For more information about validating logic, see Logic Task Usage.

    End of the note.

  5. To limit the clear action to a subset of members, enter a member selection.

  6. Select Process Cube, then select one of the following options:

    • The Full Process option rebuilds the entire application (cube). Select this option if the application structure is changed.

    • The FAC2 option processes just short-term data storage (the FAC2 table). The Data Manager imports data to the short-term data storage by default, so there may be no need to process the entire application.

    • The Refresh Data option clears data from the application and repopulates it with existing data.

  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.