General information
- Data for ancestors of the selected Period dimension members are also erased.
- Data for ancestors of the selected Unit dimension are not erased. Descendants are not erased unless specifically selected.
- Only investor relationships and ownership properties (including ownership percents) are erased. Consolidation method ranges and Ownership journal definitions and posting status are not erased. To erase adjustment detail for the Ownership process, see "Erase Data".
- After erasing ownership data, it is important to re-run the Prepare Intercompany Eliminations process to update journal data and then reconsolidate to roll up the changed data, compute new totals, post new Ownership journals journals, and refresh journal posting status.
Erase Ownership Data replaces existing values with null values for ownership data in these fact tables:
| Ownership fact table | Description |
|---|---|
| OWN_CONSOLIDATION_BASE | Consolidation percent (calculated or loaded) |
| OWN_EFFECTIVECONTROLPCT_BASE | Effective control percent (calculated or loaded) |
| OWN_EFFECTIVEOWNERSHIPPCT_BASE | Effective ownership percent (calculated or loaded) |
| OWN_HOLDINGS_BASE | Direct ownership percent values specified via the Direct Investor Relationships page or loaded via Data Loader |
| OWN_OVERRIDE_BASE | The consolidation method used to override the default method (specified via the Ownership Properties page or loaded via Data Loader) |
| OWN_UNITTYPE_BASE | The unit type specified via the Ownership Properties page or loaded via Data Loader |