Within the Investment Management industry, reporting of trading activities is critical. Trading files need to be sent out to Custodians to ensure that they are aware of any transactions that occurred for settlement purposes. With this hedge fund, they were going to be trading a wide array of asset types and needed three separate reports setup.

OmniVista Solutions worked with the report recipients to get the business requirements for the reports. These requirements outlined the format and expectations for required/optional fields. After looking through the requirements, we helped created a mapping document that laid out which datapoints would be used for specific fields. We then worked with the hedge fund’s full-time personnel to outline what data we appeared to be missing within their trading system. When all report fields were determined and located, we utilized export functionality within Charles River to create the exports. We then put together a hybrid team of consultants, report recipient full-time personnel, and the hedge fund’s full-time personnel to complete implementation and testing

Our client required that multiple reports be created with each report consisting of trades for different asset types. The reports would run one time a day and we had to ensure that trades were showing up on the correct report based on asset type.

The typical Charles River export process utilizes Definition tables in which help you build out the SQL statement. We wanted to utilize this structure as it has built in export features that we wanted to utilize. However, we did not want to build the conditional field logic within these definition tables. We utilized a single view to consolidate all the data that would be required for the reports.We then accessed this view from the definition tables and used the columns from the view for the display.

The use of a view allowed us to better manage the code as all conditional logic was housed in the view rather than through the definition tables.

The result was three functioning reports that would be easily maintainable. If any of the columns were displaying inaccurate information, the users could just access the view and make the required changes.