52
From the UpLoad File Tab, click Browse to locate the multiload file, select the file from the
popup window and click Open. The multiload file can either be a text file (.txt) or an Excel file
(.xls).
If the file was loaded from the Upload file tab then it must be checked in. Click Check-in in the
upper-right side of the screen. If the Multiload file was loaded from the Select File from Inbox
screen the check-in step is not required.
Importing a Multiload
F
ile
After a multiload template has been checked in, it is imported by clicking the Import button.
Importing a template writes the data to the FDM location table. The
icon appears in the tree
on the left if errors occur.
V
alidating a Multiload
F
ile
After a multiload template has been imported, it can be validated by clicking the Validate button.
Validating a template verifies that all members within a dimension exist in their respective map
tables.
Mapping validation errors are viewed by clicking the
icon. The unmapped members are
shown in the Processing Details grid on the right.
All unmapped members from the multiload must be added manually. To add the unmapped
members to their proper mapping tables, click on the Maps link under Activities. Proceed to
map the invalid member to a target member.
N
ote:
The mapping table displayed is for the current POV location, this may not be the same location
as the location being loaded in multiload. Always verify the current location prior to making
mapping changes.
L
oading a Multiload
F
ile
After a multiload template has been validated, it is exported and loaded to the target system by
clicking the Export button. When processing a multiload text file, a single load file is created
and loaded into the target system. When processing a multiload Excel file, a separate load file is
created and loaded for each period. The
icon appears in the tree on the left if load errors
occur.
152
I
mport
i
ng
O
ther
D
ata
Fil
es