Skip to content

Model Overview

This section provides detailed documentation of all data models in the EWE Numera platform.

Model Categories

Category Description Documentation
Dimensional Models Core fact and dimension tables from numera-core Dimensional Models
Credit Exposure EWE credit risk management models Credit Exposure
Clearing Statements ABN AMRO and BNP Paribas clearing data Clearing Statements
Power Volumes 15-minute power trading analysis Power Volumes

Quick Reference

Fact Tables

Model Domain Grain
fct_pnl P&L metric_date + dimensions + delivery_month
fct_pnl_deal P&L metric_date + deal + delivery_period
fct_volume Volumes period + deal side
fct_schedule Volumes period + deal + version
fct_credit_exposure Credit metric_date + exp_line + party
fct_credit_exposure_month Credit metric_date + exp_line + party + month
fct_clearing_statement_open_position Clearing metric_date + account + symbol
fct_ewe_volume_pwr_by_business_case Power date + 15min period + business_case
fct_ewe_volume_pwr_floating_by_business_case Power (Floating) date + 15min period + business_case + index
fct_delta Risk metric_date + index + deal + delivery_month
fct_deal Deals deal

Dimension Tables

Model Domain Primary Key
dim_deal_attribute Deals dim_deal_attribute_id
dim_party_internal Parties dim_party_internal_bu_le_attribute_id
dim_party_external Parties dim_party_external_bu_le_attribute_id
dim_party_agreement Parties dim_party_agreement_attribute_id
dim_delivery_location Locations dim_delivery_location_id
dim_index_attribute Pricing dim_index_attribute_id
dim_tran_status Reference dim_tran_status_id

Accessing Model Details

This Documentation

Each model category page provides: - Model descriptions and business purposes - Key columns with data types - Common query patterns - Relationships to other models

dbt Documentation

The dbt Documentation provides:

  • Interactive lineage graph: Visualize data flow between models
  • Column-level documentation: All columns from schema YAML files
  • Test coverage: Defined tests for each model
  • Source-to-target mapping: Trace data origins

Common Patterns

Surrogate Keys

All dimension tables use integer surrogate keys:

dim_deal_attribute_id  -- Integer surrogate key

Join facts to dimensions on these keys for optimal performance.

Placeholder Values

ID = 0 represents "Unknown" or "Not Applicable":

WHERE dim_deal_attribute_id != 0  -- Exclude unknowns

Active Status Filter

For business reporting, filter to active transaction statuses:

WHERE tran_status IN ('Validated', 'Matured', 'Amended')

Best Available Flag

For schedule data, use the best available flag:

WHERE is_best_available = TRUE

Model Dependencies

numera-core Models

EWE-specific models depend on core numera-core models:

Model Dependencies

Schema Location

All customer-facing models are in the NUMERA_DIM_MODEL schema:

SELECT * FROM NUMERA_DIM_MODEL.fct_pnl
SELECT * FROM NUMERA_DIM_MODEL.dim_deal_attribute