1. Administering Financial Consolidation and Close
  2. Managing Applications
  3. Importing Data
  4. Data Load Methods

Data Load Methods

These options are available for loading a data file into an application.

  • Merge—Use this option to overwrite the data in the application with the data in the load file. Each record in the data load file is imported into the cell, replacing the old value, if any.

  • Replace—Use this option to replace data in the application.

    In Replace mode, for Periodic loads, before the first record for a specific Scenario/Year/Period/Entity/Mapped Data Source is encountered, the entire combination of data for that Scenario, Year, Period, Entity, and Mapped Data Source is cleared, whether manually entered or previously loaded.

    When you load data to YTD_Input, the system loads the data from the load file and reverses the YTD values from the previous period for the Flow accounts that are not specified in the data load file. This behavior will occur for all members under FCCS_Mvmts_Subtotal and FCCS_OpeningBalanceAdjustment in the Movement Dimension.

    For the first period of a year, there is no YTD data to reverse, so the system applies this method for Periods 2-12 or 2-13.

    For Balance Accounts, the value loaded to YTD_Input is copied and stored to FCCS_Periodic.

    Note:

    The YTD_Input member is used only for YTD data entry. It can be used to add or modify values in YTD, but cannot be used to clear YTD values.

    You can also include Consolidation dimension members in the criteria for the data to be cleared during the data load process. For example, you can load Entity Input data in Replace mode without clearing Translation Override data or data in the other Input members, so that you do not need to re-enter or reload that data. To include Consolidation dimension members in the process, you must add a Substitution Variable named DataLoadConsolMember and set the value to True.

    You can load a data file that contains only the Closing Balance Input data to reverse the prior period non-zero Closing Balance amounts. When you load a data file in Replace mode that contains only the POV with Closing Balance Input, the system will write a reversal of the prior period Closing Balance to the default movement. See Example: Data Import File - Closing Balance Input and Replace Mode.

    Financial Consolidation and Close reverses the YTD closing balance from the prior period, and does not reverse FCCS_Net Income/FCCS_Owner’s Income in the first period. This allows you to be able to load to Closing Balance Input for both Balance Sheet and Income accounts. To disable this behavior, change the NewLoadYTDClosingBalanceInput substitution value to False.

  • Accumulation Type—Select one of these options to accumulate the data in the application with the data in the load file:

    • None—Each record in the data import file replaces the existing value in the database for the record.

    • With Database—The data is added to the existing value of the cell.

    • Within File—The system accumulates the cell values that are within the file.