EBA欧洲银行-JEGR_Relational_Database_instructions_6页_241kb

JEGR Relational Database Summary

Core Content

The JEGR relational database is a tool designed to provide detailed information on the similarities and differences between European statistical and supervisory reporting frameworks. It is based on the Data Point Model (DPM), a methodology and data dictionary developed by the European Banking Authority (EBA). The database models the ECB's Balance Sheet Items (BSI) and Monetary Interest Rates (MIR) frameworks in line with the DPM to ensure consistency and comparability across different reporting systems.

Main Features

• Unique Data Dictionary and Methodology: The DPM provides a standardized structure for reporting requirements, consisting of two layers: the dictionary layer (concepts, dimensions, domains, members, and hierarchies) and the framework layer (tables, axes, and data points).

• Predefined Queries and User-Friendly Interface: The database includes a set of predefined queries and forms to help users explore the relationships between dimensions, members, and data points. These tools make it easier to compare and analyze reporting frameworks.

• Visualisation of Frameworks: Users can navigate through the framework layer to understand how dimensions and members are used across different tables. The "Visualise frameworks" menu provides a way to explore the application of dimensions and their associated members.

• Export Capabilities: The database allows users to export data to Excel, supporting three main export options:

  • Export tables: Tables can be exported directly, optionally filtered by reporting framework.
  • Export matrix: An EBA-published analysis matrix can be exported using a provided Excel template.
  • Export dictionary: The full EBA dictionary or a specific part used in a reporting framework can be exported.

Key Queries

3.1 Use of Dimensions Query

• Purpose: To show how a selected dimension is used across different tables.
• Functionality:
  • Select a dimension from the combo box.
  • The "Tables list" shows all tables using the dimension.
  • Tables can be exported to Excel.
  • Axes and members can be explored by double-clicking on them.
  • The "Members used in the table" list provides a distinct list of members used in the selected table.

4.1 Use of Members - Cascade Search Query

• Purpose: To find data points that include a set of dimension-member pairs in a cascading manner.
• Functionality:
  • Select a dimension-member pair.
  • The "Selected pairs dimension-member" list box accumulates the selected pairs.
  • The "Select dimension" and "Select members" list boxes are filtered accordingly.
  • The "Data points found" list box shows all data points that include the selected dimension-member pairs.
  • Data points can be exported to Excel.

4.2 Compare Data Points Query

• Purpose: To compare two data points in terms of their shared and non-shared dimension-member pairs.
• Functionality:
  • Select two data points by choosing framework, table, and axes.
  • Click "Compare data points" to view the results.
  • "Shared pairs dimension-member" lists the common dimension-member pairs.
  • "Non-shared pairs dimension-member" lists the unique pairs, with references to the data point they belong to.

4.3 Dimensions and Members by Table Query

• Purpose: To list all dimensions and members explicitly applied to a specific template.
• Functionality:
  • Select a framework and table.
  • The "List of dimensions and members" shows all members and their associated dimensions.
  • The "List of dimensions" shows all dimensions applicable to the selected table.
  • Selecting a dimension updates the "Associated members" list with relevant members.

4.4 Visualise Dictionary Form

• Purpose: To explore the dictionary layer of the DPM.
• Functionality:
  • Contains list boxes for "Domains", "Dimensions", "Members", and "Hierarchies".
  • Selecting an item filters the rest of the list boxes.
  • When a dimension is selected, the "Members" list box shows only those members used with that dimension in reporting frameworks.
  • "Typed" domains (those without a closed set of values) do not display any members.
  • A "Filter by frameworks" option allows users to focus on specific reporting frameworks.

Conclusion

The JEGR database is a powerful tool for comparing and analyzing European reporting frameworks using the EBA's DPM methodology. It provides users with a structured, intuitive way to explore dimensions, members, and data points, along with export capabilities to facilitate further analysis and reporting.