8.2.1.3 List of Subject Areas for Source Data Visualisation Reports

The Source Data Visualisation Reports helps admin users to visualize data entities such as Party, Product, Transaction, and others directly from the source systems or staging layers.

1. From Oracl analytics, Navigate to Shared Folders -> Data Foundation Reports -> Source Data -> Banking
2. The page displays the subject areas tagged to the stage tables.
   • Transaction
   • Product
   • Product Processor
   • Party
   • Others

     Note:

     The search bar enables you to filter entities associated with a specific subject area for example, "Loans." It will display all subject areas related to loans.
3. Click any of the Subject Areas, Eg: Transaction, a list of stage tables is displayed.
4. You will see a list of entities such as:
   • Account Transactions
   • Forex Transactions
   • Casa Transactions
   • Cards Payments Transactions
5. Select specific entity for which you want to view data.

   Figure 8-16 Pre-built Source Data Visualization Transaction

   
   

   

   
   

   Table 8-3 Subject Area components

   Column	Description
   Name	Entity name (e.g., CASA Transaction)
   Description	Displays the brief description
   Owner	The owner is the POC who updated last.
   Modified	Timestamp of the most recent data ingestion

6. Click an entity to view the actual record-level data.
7. You can refine your view using:
   • As Of Date: Clicked on the As Of Date filter tab to adjust data based on reporting dates.

     Figure 8-17 As Of Date filter

     
     

     

     
     
     • Select List to allow selection from a predefined list of dates.
     • Select Exclude to remove the selected date range from the results.
     • Select Null to include rows where As Of Date is null (missing/ undefined).
     • Select Date Range to select records that fall within a specific time range.
     • Select Relative Time to dynamically filter records based on a relative timeframe from today (or another reference point).
     • Each column represents a field/attribute from the data entity. For the Account entity, key fields include:
       • Data Source Code – to view data from a specific source system (if multiple exist).
       • Click Create Expression Filter – Opens the expression filter interface to define advanced logic-based filters.
       • Click the three-dots to sort the list of accounts displayed.
       • Click Drill to Data Element to enables users to explore related or lower-level data.
       • Right-click to view the interactive data table within the report.