Trade Finance Data Model — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Trade Finance Data Model

Received Response
2
Views
1
Comments
Sunny86
Sunny86 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Dear All,

We have a difficult situation with the datamodel for trade finance.

We have several modules like

Import LC

Export LC

Guarantee

Import Business Collection

Export  BusinessCollection

etc

in that Import LC we have measures and dates in the table and it has a Negotiation table under that

-> Import LC

       -> Import Negotiation Master(Multiple Negotiations for each LC)

               -> Import Negotiation Detail(Multiple records for each negotiation like one for request received, request processed,document checking,payment processing etc)

Similar situation for export LC

Business needs reports which consist of data from all the bundles.

How can we model this. Any help will be highly appreciated.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Physically join on your keys ...

    Logically you must reduce this to a star - you need to map out what your dimensions (attributes) and facts (measures) are.  Be prepared (especially with that Negotiation Detail table) to create additional physical structures to make this work (perform) -- if indeed it is highly snowflaked with a volume of rows, and the detail table contains multiple logical 'types' of information.