Defining Locations

A location is the level at which a data load is executed in Data Management. Each location is assigned an import format. Data load mapping and data load rules are defined per location. You define locations to specify where to load the data. Additionally, locations enable you to use the same import format for more than one target application where the dimensionality of the target applications is the same. However; if you are using multiple import formats, you must define multiple locations.

Note:

You can create duplicate locations with the same source system and application combination.

To create, edit, and delete import locations:

  1. On the Setup tab, under Integration Setup, select Location.

  2. In Location, click Add.

  3. From Location Details, in Name, enter the location name.

  4. From Import Format, enter the import format.

    The import format describes the source system structure, and it is executed during the source system import step. A corresponding import format must exist before it can be used with a location.

    Additionally:

    • Source name is populated automatically based on the import format.
    • Target name is populated automatically based on the import format.

    You can also click Image shows Search button and select an import format.

    For more information about import formats, see Defining Import Formats for File-Based Mappings.

  5. In Functional Currency, specify the currency of the location.

    Note:

    You must specify the budget currency of the control budget to which the budget is written back.
  6. In Parent Location, enter the parent assigned to the location.

    Parent mappings are used to share mappings with other locations. Enter mappings at the parent location, and the related locations can use the same mappings. Multiple locations can share a parent. This feature is useful when multiple locations use one chart of accounts. Changes to a child or parent mapping table apply to all child and parent locations.

    Note:

    If a location has a parent, the mappings are carried over to the child. However; changes to mapping can only be performed on the parent location.
  7. Optional: In Logic Account Group, specify the logic account group to assign to the location.

    A logic group contains one or more logic accounts that are generated after a source file is loaded. Logic accounts are calculated accounts that are derived from the source data.

    The list of values for a logic group is automatically filtered based on the Target Application under which it was created.

  8. Optional: In Check Entity Group, specify the check entity group to assign to the location.

    When a check entities group is assigned to the location, the check report runs for all entities that are defined in the group. If no check entities group is assigned to the location, the check report runs for each entity that was loaded to the target system. Data Management check reports retrieve values directly from the target system, Data Management source data, or Data Management converted data.

    The list of values for a check entity group is automatically filtered based on the target application under which it was created.

  9. Optional: In Check Rule Group, specify the check rule group to assign to the location.

    System administrators use check rules to enforce data integrity. A set of check rules is created within a check rule group, and the check rule group is assigned to a location. Then, after data is loaded to the target system, a check report is generated.

    The list of values for a check rule group is automatically filtered based on the target application under which it was created.

  10. Click Save.

  11. Optional: Perform these tasks:

    • To edit an existing location, select the location to modify, and then make changes as necessary. Then, click Save.

    • To delete a location, click Delete.

      When a location is deleted, the location is removed from all other Data Management screens, such as Data Load.

    Tip:

    To filter by the location name, ensure that the filter row is displayed above the column headers. (Click Query by Example button. to toggle the filter row.) Then, enter the text to filter.

    You can filter locations by target application using the drop down at the top of the screen.