Show TOC

Function documentationImport Master Data Descriptions from a File Locate this document in the navigation structure

 

You can define a package to upload master data descriptions from a flat file using the process chain /CPMB/IMPORT_DESCRIPT.

The data can be imported from a file stored on the Application server and FTP source by entering the fully qualified path and file name (see INFILE Prompt() Command).

Activities

  1. Create a Data Manager package by using the corresponding process chains (see Package Usage).

  2. Run the Data Manager package as follows:

    1. Log on to the Planning and Consolidation Office module.

    2. On the action pane, choose   Manage data   Run a package  .

    3. Choose the package created in step 1 and choose Run.

    4. Choose the import file.

    5. Choose a transformation file.

    6. Choose the name of the destination dimension.

    7. Choose one of the following options:

      • Run now

      • Schedule

      • Run now & schedule

    8. Choose Finish.

You can change the default package instructions (see Modifying the Dynamic Script of a Package).

Dynamic script task parameters

Task

Parameter

Default Value

Description

/CPMB/MASTER_DESC_CONVERT

DIMNAME

Dimension name

/CPMB/MASTER_DESC_CONVERT

FILE

File name

/CPMB/MASTER_DESC_CONVERT

SPACKAGE_SIZE

0

Package size

/CPMB/MASTER_DESC_CONVERT

TRANSFORMATIONFILEPATH

Transformation file

/CPMB/MASTER_LOAD

DIMNAME

Dimension name