Group Consolidation Sheet Actions
Group consolidation sheet actions enable users to efficiently transform data between Group (Currency) members and execute consolidation processes directly from the sheet. These actions are configured in the Actions tab of the sheet detail page and can be executed through multiple methods.
Available Consolidation Actions
Currency Conversion - This action enables the conversion of currencies from the Local Currency to other currencies. To use this feature, exchange rates must be already maintained. Rates can be configured under Rates > Exchange Rate within the same functional area as the sheet. Currency conversion rules can be defined by updating triggers, properties, and rules in the Actions tab of the sheet detail page. For more advanced needs, you can also set up detailed conversion rules in the same section.
Group Consolidation - This action is used to consolidate data from entity-level to group-level based on ownership structure details. Ownership structures can be managed by configuring the Ownership Structure under Rates. Group consolidation rules can be set up by updating triggers and specifying the consolidation method in the Actions tab of the sheet detail page.
Configuring Actions
Actions are configured in the Actions tab of sheet detail page:
Triggers - Update triggers to define when the action should execute.
Properties - Configure properties specific to the action type (such as conversion method in account for currency conversion or consolidation methods for group consolidation).
Rules - Define or select rules that control the action's behavior. For advanced needs, detailed conversion rules can be set up in the same section.
Combined Action Execution
You have the flexibility to enable currency conversion to run along with group consolidation, streamlining the process further. This coordinated execution ensures entities are first converted to group currency, then consolidation rules are applied in a single operation.
Execution Methods
Both currency conversion and group consolidation actions can be executed through multiple methods:
Run Button on Actions Tab - Execute by clicking the Run button on the Actions tab.
Data Options in Sheet - Execute through the Data Options in the sheet interface.
Features Tab - Execute the rules from the Features tab in the sheet.
Task-Based Execution - Tag the rules to tasks under Calculations and Data Flow and execute them via the Activity section. This integrates consolidation actions into workflow processes.
Validation and Data Integrity
Validation improvements in consolidation sheets prevent unintended changes. Restrictions on deleting essential rules, adding duplicate fields, and configuring currency conversions ensure that data integrity remains intact. Users will see warning messages when actions conflict with validation rules, helping them correct the entries.
Performance and Monitoring
Aggregated execution improves performance by reducing data volume, while logs ensure traceability and audit readiness. The execution status can be monitored in the Event Log, providing complete visibility into consolidation action execution.