Financial Management maintains the calculation status for each scenario, year, period, entity, parent, and value combination. The calculation status indicates whether data needs to be calculated, translated, or consolidated. You can view the calculation status in a data grid.
The calculation status can change as a result of several actions:
Changing the organization structure
Adding or deleting accounts
Modifying entity attributes
Entering data in data grids, or loading data from external sources
Posting or unposting journals
Posting or unposting intercompany transactions
Reloading rules
Changing percent consolidation
Changing currency rates
The following table lists calculation statuses and their descriptions.
Table 5. Calculation Statuses
Status | Description |
|---|---|
OK | None of the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. |
OK ND | OK - No data. The calculation has been effectively run, but calculations were not run for NODATA. |
OK SC | OK - System changed. A change has taken place that may affect the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. For example, a new rules file or metadata file has been loaded, or the currency rate has changed. |
CH | Needs Calculation. At least one data cell for the specified Scenario, Year, Period, Entity, and Value dimensions has been changed, or metadata parameters or rules have changed. As a result, other data cells in this Scenario, Year, Period, Entity, or Value dimension may not be current because calculation has not been run. For base-level entities, the data cell may have been entered by manual data entry or by a bulk data file load. For any entity, the data cell may have been entered by a journal posting. |
| CH ND | Needs Calculation — No Data. This indicates the first time that calculation will be performed on the cell. |
TR | Needs Translation. The selected Value dimension member is not the entity’s default currency, and its translated values may not be current. |
| TR ND | Needs Translation — No Data. This indicates the first time that translation will be performed on the cell. |
CN | Needs Consolidation. The data for the specified Scenario, Year, Period, Entity, and Value dimensions may not be current because data for a child entity has changed, data for the same entity's default currency has changed, or metadata parameters or rules have changed. |
CN ND | Needs Consolidation. The parent has no data, but data for a child entity has changed. This indicates the first time that consolidation will be performed on the cell. |
Locked | The data for the specified Scenario, Year, Period, Entity, and Value dimensions has been locked by an administrator and can no longer be modified by manual data entry or calculations. |
NODATA | No data exists for the specified Scenario, Year, Period, Entity, and Value dimensions. |
NoAccess | The user does not have rights for the specified dimension member. |
To view calculation status: