REMIT Reporting Services and Solutions - July 2015 updated March 2016
9.3.1.4
OpenLink CubeIntelligence – Regulatory Cube
Product
The CubeIntelligence Regulatory Cube is a stand-alone piece of software helps market participants better comply
with regulatory requirements by:
Permitting rapid development of adapters to OpenLink and other source systems.
Processing the data in order to prepare it for regulatory trade reporting through data enrichment and the
application of certain rules.
Executing operations like auditing, reporting and error tracking before the data is transmitted.
Providing an easy and robust trade reporting system to third party repositories.
Custom reporting, drill-down and custom aliasing capabilities.
Performing threshold calculations and portfolio reconciliations under EMIR.
The system has several components:
The Cube ETL Layer manages data acquisition. The layer can “extract, transform and load,” pull data from source
systems and transform it into required formats and perform lookups such as LEI and UPI transformations. It can also
apply complex rules to the data, for example, on a trade, leg or portfolio basis, deriving the trade status to be sent to
the TR and RRM based on changes in the appropriate fields. The system comes pre-configured for EMIR and REMIT.
The Regulatory Cube processing engine of the solution, it takes in trade and other data from source systems,
processes it and places it in the data mart, the storage part of the Cube which keeps data in an easy to query
denormalised format. The Cube process calculates results such as thresholds on-the-fly, and permits data to also be
queried as required. Installations can also use the Cube Reference Data Manager to store information such as
counterparty data, or elect to use their own master data management system. The engine also manages the
workflow around the reporting process, and provides a comprehensive set of configurable processes to manage the
reporting cycle as per individual installation preference. The engine can cope with different types of market
participants. For example, it is possible to switch on and off the reporting of valuation information and collateral.
The engine is capable of differentiating between different group entities and handling them as required.
The publisher tool pushes the data from the data mart to the receiving repository and processes response messages
from the repository to the Regulatory Cube. The tool publishes to XML using the REGIS-TR repository, which will
communicate to both EMIR TRs and REMIT RRMs.
The solution can be hosted or deployed at the client site. The deployment depends on each individual setup and
where the data is located.
Vendor and website
OpenLink Financial LLC
www.openlink.com
Copyright 2016 – ETR Advisory Ltd and Commodity Technology Advisory LLC
62