Show TOC

Procedure documentationImporting into a Cube Locate this document in the navigation structure

 

There are three ways to import an ASCII text file directly into a cube:

  • The Import into Cube (Fac2) option allows you to import data into the Fac2 table.

  • The Import into Cube (WB) imports data into the write-back table.

  • The Import into Cube Append option appends the data in the import file to the data already in the database.

You must add this task using SQL Server Business Intelligence Development Studio.

Prerequisites

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

Procedure

  1. Open the package that you want to modify, or create a new package in Microsoft SSIS.

  2. Select the DumpLoad task and add it to the package.

  3. Open the task and choose   Data Management   Import into cube (Fac2), Import into cube (WB), or Import into Cube Append  .

  4. Enter data as required.

    Note Note

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

    End of the note.

  5. Select the Process Cube option, 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.

  6. Select Run default logic if you want the logic contained in default.lgc to be run after importing the 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.