Using Origin’s layout page, they were able to easily drag and drop graphs, tables, and text to create custom reports. Customization of tables using borders and colors allowed them to reproduce the company letterhead on all reports. After successfully experimenting with the SQL-connectivity, they understood that by designing basic communication interfaces between Origin and MATLAB, data could be queried from the database, fed into MATLAB for analysis, and retrieved from MATLAB for report generation in Origin. Ariel Fischer and his team have been able to implement Origin as the front end solution to create a fully automated reporting tool fulfilling the requirements above.
This solution has been used to create a credit rating report of 150 Nordic banks. The report is designed to include a summary of financial reports of each bank as well as present and explain the derived credit rating from the underlying credit model. In addition, analysis of aggregated statistics is presented as a function of time. Once new financial data is registered in their data warehouse, an updated credit rating report will be created by the click of a button.
Ariel Fischer says: “The most central Origin feature in this project is the COM-server functionality combined with Origin C and LabTalk, which allows for a seamless integration of Origin with our existing data storage and analysis tools. Additional powerful features of Origin that were utilized include: worksheet queries, animation creation, built-in statistical functions and the import interface. Origin proved to be all-in-all the smoothest way to manage the different elements in the report. The quality of the output is beyond what I have seen in other graphing/analysis-software.”
There are currently three other projects under development for Ariel Fischer and his team, and Origin will play a pivotal role in the completion of these projects.
Click to open the PDF file generated by Origin