Show TOC

Procedure documentationCreating Dimensions Locate this document in the navigation structure

 

You can automate the creation of dimensions using a package in the Data Manager.

During normal operation, Planning and Consolidation creates a dimension table during the validation of the member sheet in Microsoft Excel. This table is the source for processing a dimension into the application. Using this task, you can set up your source system to produce a replicated member table rather than using Microsoft Excel. That member table can then be processed into Planning and Consolidation application by this task.

Prerequisites

You have advanced knowledge of Microsoft SSIS.

You have advanced knowledge of the Planning and Consolidation member tables.

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. See Adding and Modifying Packages.

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

  3. Open the task and choose Create dimension.

  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. Enter the dimension name and the Microsoft SQL Server source table.

  6. Select from the following options:

    • Whether or not to perform a full process after the dimension creation

    • Whether or not to make the system available after the dimension creation

  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.