CONTEXT The company has multiple subsidiaries using different (or the same) software systems.
TASK
The company wants to consolidate data on counterparty turnover.
EXAMPLE USE OF GRAVITY
In GRAVITY, we design INPUT SQL operators for all databases being consolidated. Using the STANDARDIZATION operator, we identify the same counterparties across different databases and aggregate their turnover. The result of the calculations is transferred to an output database connected to analytical software or sent by email to selected recipients.
Example diagram:
TASK
The company wants to collect all sales invoices from all subsidiaries into a single consolidation database (this task is an extended version of the previous one).
EXAMPLE USE OF GRAVITY
In GRAVITY, we design INPUT SQL operators for all databases being consolidated. Using the STANDARDIZATION operator, we identify the same counterparties across different databases and aggregate their turnover. The result of the calculations is transferred to an output database connected to analytical software.
TASK
The company wants consolidated financial statements for all companies within the group.
EXAMPLE USE OF GRAVITY
In GRAVITY, we design INPUT SQL operators for all databases being consolidated. Using the STANDARDIZATION operator, we identify and align the chart of accounts across different databases. The result of the calculations is transferred to an output database connected to data presentation software (alternatively, the resulting XLS file can be sent by email).