At the same time, CMC Markets also wanted to provide their traders with an analytic tool that would provide a much deeper understanding of client activity.

Now, with Quartet's event driven OLAP component they have exactly such a solution - one that was built quickly and at the same time, provides a much more flexible reporting platform for the organization. Rather than building a custom application, imbedding ActivePivot into their trading platform provided CMC markets with a flexible and powerful operational business intelligence (BI) solution.

They had a set of key operational requirements, which were to:
• compute clients net positions and equity more often to better control risk
• provide clients with better and faster margin calculations to increase trading potential
• give traders a more up-to-date view of their open risk positions
• provide real-time client positions to other risk engines
• provide a tool for analysis of client trading positions with multiple views, slice and dice

With ActivePivot, CMC Markets were able to accomplish all of the above as well as put themselves in a position to re-use ActivePivot's real-time capabilities to develop other critical application within the organization - all in a cost effective manner.

With ActivePivot, CMC Markets now enjoys real-time/intra-day client activity, margining and collateral monitoring as well as a user-friendly operational BI platform. CMC Markets can now increase trading capabilities for their clients now that they have a more up-to-date net equity position, manage large amounts of Key Position Indicators (KPI's) with limits and real-time alerts. These enhance their risk controls. CMC Markets have more up-to-date position data and now use one single tool to build their real-time position and margin calculation as well as provide the analytical multi-dimension analysis needed to help traders find better trading sading strategies.

Asif Adatia, CIO at CMC Markets says "with ActivePivot, we now benefit from a real-time analytic solution which provides well-defined positions and complex calculations along with a flexible analysis tool to help the traders find better trading strategies and identify where the profits are coming from. The fact that we now have immediate access to real-time risk, position, and P&L data, it became immediately obvious that the traders could, and already have, increased their productivity and profitability using this new tool."

We, and our clients, continue to find more and more business critical uses for our unique in-memory, object-based, real-time aggregation OLAP engine ActivePivot. It is with great pleasure that we welcome CMC Markets to our client list as they are one of the world's leaders in online derivatives trading. We now look forward to working on many more projects there with them" says Xavier Bellouard, a founder and the managing director of Quartet FS London.