Columns
The Columns tab enables you to define how the data in the source file is laid out and how the data maps to the database.
These are the options:
| Option | Description |
|---|---|
| Private Property Set | Open the Property Set Options dialog box. See "Property Set Options Dialog Box" for further information. |
|
Clear the current mappings. |
|
Automatically map the dimensions to the source columns. Matching is based on an internal set of aliases that are matched to the header names in the source file. |
| Data Type |
For currency loads, the default is Currency Exchange Rates. Financial data only. Type of data in the source data file. You can choose Periodic, Intercompany, or Periodic and Intercompany. Local untranslated financial (periodic) data is loaded to the FINLOC_BASE table. Intercompany data is loaded to the ICREPPER_BASE.If you choose the Periodic and Intercompany option, the formula type specified for each line determines where the data is loaded. If you select the Use Unit's Currency option, all data is loaded to the FINLOC_BASE table. Then, based on the formulas in the source data file, loads intercompany data to the ICREPPER_BASE table. |
| Data Layout | Specifies whether the source data file has a single data column or multiple columns (multiple periods). |
| Dimensions | Dimensions you must map to the source file. All the items
shown in this list must be specified. If not, you will receive an invalid
mapping message when you try to save the load definition. Unmapped dimensions
are highlighted in orange. This table contains four columns. The Name column shows the name of the dimension. The Source column shows the member name. Select Current to use the current selection from the Workflow Navigation section. Select Member to open the Member Selection dialog box where you can select the specific member to use. Select Column to drag and drop from this table to the Source File section. For financial data loads, the Currency dimension Source column also provides you with the Use Unit's Currency option. The Use Unit's Currency option enables you to load intercompany data to the default currency for each unit. This option applies to the Intercompany and Periodic and Intercompany data type selections. The Mapping column shows how the column is mapped. The Type column is enabled when you select Column as the source. This enables you to specify if you are mapping a Member ID, Member Name, or Member Description. The default is Name. Segmented general ledger data that has been split into multiple columns uses the name of the original column header with the addition of a number to indicate the split. For example, ColHeader(1), ColHeader(2). |
| Data | If you selected multiple columns for the Data Layout option,
then each period is listed and is mapped to a column. The Data option specifies which column in the source file is the actual data. The Description option enables you to specify a column in the source data file that will display as a description on the Summary vs. Detail report. You can map any column as the description. Unmapped dimensions are highlighted in red. |
| Source File | Source file and column mappings grid. You can drag and drop from the dimensions list to this grid. See Establish mappings. |
Shortcut menu
On the Columns tab, right-click the Mappings header to show the menu for the Source File grid. The Clear Mapping command enables you to clear the mapping for a column. Use this command to clear a column one at a time.