Defining Application Options for Financial Management

Load Summarized

Load Detail

Scan— Validates data and lists invalid records into the Log. When this option is selected, data is not loaded to the target application.

Load—Validates and loads data to the target application.

Replace—Replaces the data in the application with the data in the load file. For each unique combination of Scenario, Year, Period, Entity, and Value in the data file, the Replace option clears all account values from the application, then loads the value from the data file.

Merge—Overwrites the data in the application with the data in the load file. For each unique point of view that exists in the data file and in the application, the value in the data file overwrites the data in the application.

Data in the application that is not changed by the data load file remains in the application.

If you select the Accumulate In File option in conjunction with the Merge option, the system adds all values for the same point of view in the data file, and overwrites the data in the application with the total.

For each unique point of view that is in the data file but does not have a value in the application, the value from the data file is loaded into the application.

Accumulate—Select the Accumulate option to accumulate the data in the application with the data in the load file. For each unique point of view in the data file, the value from the load file is added to the value in the application.

Replace by Security—Performs a data load in Replace mode in which only the members to which you have access are loaded. This option enables you to perform a data load in Replace mode even if you do not have access to all accounts. When you perform the Clear operation for a period in a sub-cube, only the cells to which you have access are cleared. Data, cell text, and line item detail are cleared, but cell attachments are not cleared.

Scenario, Year, Period, Entity, Account

Display Name (for cell context menu) and URL (to drill to)

Impacted—The Consolidate (Impacted Consolidation) option is available for any parent entity with a calculation status of CN or CN ND. When you select this option for a parent entity, the system performs calculations (Calculate, Translate, Consolidate) for any dependent entity within the consolidation path of the selected parent that has a calculation status of CN, CN ND, CH, TR, or TR ND, on the current period or on any prior period in the current year. Consolidate is the most efficient option because only entities that require consolidation are updated.

Process units with a status of NODATA on the current period and all prior periods are skipped. Process units with a status of OK or OK SC on the current period are not recalculated, retranslated, or reconsolidated. If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.

All with Data—The Consolidate All with Data option is available for any parent entity, regardless of its status. When you select this option for a parent entity, the system consolidates every dependent entity within the consolidation path of the selected parent that contains data, regardless of its status, in the current period or in any of the prior periods. The system also runs calculation rules for the dependent entities. It does not perform a consolidation on entities that contain zeroes or no data. This option is useful for updating system status from OK SC to OK after metadata changes.

Process units with a status of NODATA on the current period and all prior periods are skipped. Consolidation Options units with a status of OK or OK SC on the current period are recalculated, retranslated, and reconsolidated. If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.

All—The Consolidate All option is available for any parent entity, regardless of its status. When you select this option for a parent entity, the system performs calculations for every process unit within the consolidation path of the selected parent, regardless of its status. It consolidates all entities whether they contain data or not. This option is useful when an update from prior periods is required, or when an entity with no data needs to be populated using allocations. This option should be used sparingly because the system does not omit entities with no data, which can have a significant impact on consolidation performance.

Process units with a status of NODATA on the current period are calculated, translated, and consolidated. Process units with a status of OK or OK SC on the current period are recalculated, translated, and reconsolidated. If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.

Entity—Calculates the contribution of each entity to its parent, and then totals all contributions to arrive at the consolidated numbers.

Force Entity Only—Forces calculation to run for all selected contribution values to arrive at the consolidation numbers.

<Entity Curr Adjs>

<Entity Curr Total>

<Entity Currency>

<Parent Curr Adjs>

<Parent Curr Total>

<Parent Currency> (Default)

1—Working: Journal is created. It has been saved, but it can be incomplete. For example, a label or single entity may need to be assigned.

2—Submitted: Journal is submitted for approval.

3—Approved: Journal is approved for posting.

4—Posted: Journal adjustments are posted to the database (default).

5—Journal is rejected or unposted.

[Contribution Adjs]

[Parent Adjs]

<Entity Curr Adjs>

<Parent Curr Adjs>

B—Balanced

U—Unbalanced

E—Balanced By Entity