Navigation :
test ../../ test user-ref.html
User & Reference Guide
test ../../ test getting-started.html
Getting started
test ../../ test getting-started/using-this-guide.html
- Using this guide
test ../../ test getting-started/whats-new.html
- What's New
test ../../ test getting-started/frtb-data-model.html
- FRTB Data Model
test ../../ test tutorials.html
Tutorials
test ../../ test tutorials/data-health-check.html
- Data Health Check
test ../../ test tutorials/tips-for-validating-the-calculations.html
- Tips for Validating the Calculations
test ../../ test tutorials/viewing-qis-numbers.html
- Viewing QIS Numbers
test ../../ test tutorials/workaround-for-deadlock-issue-when-attempting-to-create-partitions-for-reference-stores.html
- Workaround for deadlock issue when attempting to create partitions for reference stores
test ../../ test configuration.html
Configuration files
test ../../ test sign-off.html
Sign-Off Approvals
test ../../ test cube.html
Data Cubes
test ../../ test what-if.html
What-If Analysis
test ../../ test datastore.html
Data Stores
test ../../ test datastore/readme_frtbonly.html
-
test ../../ test input-files.html
Input Files
test ../../ test dev.html
Developer Guide
test ../../ test dev/dev-release.html
-
Release and migration notes
test ../../ test dev/dev-getting-started.html
-
Getting Started
test ../../ test dev/dev-ref-impl.html
-
FRTB Reference Implementation
test ../../ test dev/dev-core.html
-
FRTB Core
test ../../ test dev/dev-extensions.html
-
Extending the Accelerator
test ../../ test dev/dev-tools.html
-
Configuring Accelerator tools and methodologies
test ../../ test dev/dev-sign-off.html
-
Sign-Off
test ../../ test interpret-impl.html
FRTB Accelerator Interpretation and Implementation of BCBS 457
test ../../ test pdf-guides.html
PDF Guides
test ../../ test glossary.html
Glossary
TradeMapping
The TradeMapping store maps trades to books and legal entities by TradeId and AsOfDate .
It is referenced from the base tables in all the trade-level cubes.
Note: This mapping is only used for the trade-level cubes.
In the IMA, there are some summary cubes that do not include a trade-level and, for these, each fact is at the book and legal entity level.
Store Field
Key
CanBeNull
Type
Cube Field
Description
TradeId
Y
String
[Booking].[Trades]
(e.g. “IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc.) – if coming from multiple systems may need to prepend source system to the id for uniqueness.
Book
String
[Booking].[Books]
The book to map the trade to (must match the node in the Book Hierarchy).
LegalEntity
String
[Organization].[Legal Entities]
Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).
TradeDate
LOCALDATE[yyyy-mm-dd]
[Dates].[TradeDates]
The date on which the trade took place
AsOfDate
Y
LOCALDATE[yyyy-mm-dd]
Timestamp (at close of business) for the data.
References: