The goal was to design and build excel spreadsheet to show trading deals stored in Oracle DB within business portfolio splitted by instruments and indexes.
To achieve this goal we used Oracle Data Access Component to connect to Oracle DB data abd then show them in excel spreadsheet in a proper pivot table view. Having in mind that the the volume of data in the database were big, the tricky part here was to get them in excel relatively quickly. For this we have used materialized view concept with fast refresh option.
PL/SQL, SQL, Materalialized Views, Excel VBA