System Calculation Option for Custom Dimension Top Member

For user-defined Custom dimensions, Service Administrators can select to process System Calculations using the Top Member of the Custom dimension, instead of all level 0 members, for faster performance. You can select specific Custom dimensions for which the option would apply.

Note that the System Calculation option applies only to user-defined Custom dimensions, and does not apply to the Multi-GAAP dimension.

When selected, the System Calculation option applies to all scenarios and years.

If your application includes additional alterative hierarchies outside of the "Total Custom XX" member, the Top Member option would not apply to the alternative hierarchies. To benefit from the Top Member processing option, you should redesign the Custom dimension to include all hierarchies as part of the "Total Custom XX" member if applicable.

Note:

If your application is an Extended Dimension application, you may want to turn this feature off for better consolidation performance.

The option applies to the following System Calculations for all applicable currency members such as Entity Currency, Parent Currency and Reporting Currency:

• Opening Balance

  • Includes both Opening Balance for movement and Retained Earnings Prior calculation

  • Opening Balance Ownership Change

• Foreign Exchange (FX) Calculations (for multi-currency applications)

  • FX Opening

  • FX Movement

  • FX to Cumulative Translation Adjustment (CTA)

• Balance Calculation

During the Translation process, the translation from Entity Currency to Parent Currency, and from Parent Currency to Reporting Currency, will continue to calculate at the Custom detail level. For any Translation Override rules and Configurable Consolidation rules, the system will process them according to the rule definition.

You can change the option at any time for an existing application. By default, the option is disabled for all Custom dimensions. When the option is changed, the system will change the Calculation Status to SC (System Changed), and you can reconsolidate if needed. Any new system calculations will be performed based on the currently selected option.

The Task Audit log contains the history of changes to the System Calculation option. It includes the user who performed the setting change, the date and time it was performed, and the information that was changed - the original setting and the newly updated setting.

To set the System Calculation option:

1. On the Home page, click Application, and then click Consolidation.

2. Select the Consolidation Process tab.

3. Select the tab for which to configure calculations: Local Currency, Translated (if multi-currency application), or Consolidated.

4. Click the Options menu at the top of the page.

5. From System Calculation Options, select the dimensions for which Top Member processing will be applied, then click Save.