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 types 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.
Group Consolidation Action Configuration
To configure Group Consolidation action:
Step 1: Access Actions - Navigate to Sheet Details > Actions > Group Consolidation.
Step 2: Add Matrix - Add matrix and configure it by selecting the Update Method as either Rule or Formula:
- Formula - Add input metrics and define custom formulas, similar to default formula metrics
- Rule - Select from the predefined rules (Interco Elimination or Auto Journal) where the same reference sheet is used
[Image: may-2025-group-consolidation-config.png]
Note: The currency for Output Metric, used in the configured formula or rule, must be of type Group.
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.
Update Methods
Group Consolidation actions support two update methods:
Rule Method - Select from predefined rules created in the Functional Area. These rules can include Interco Elimination rules or Auto Journal rules. The system processes rules by filtering input data, checking applicability, calculating values, and posting results directly to the Consolidation Sheet.
Formula Method - Add input metrics and define custom formulas within the Group Consolidation action to enable dynamic calculations. This provides flexibility for unique consolidation scenarios not covered by predefined rules.
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.