Navigation :
TRADE_MAPPING
The TRADE_MAPPING store maps trades to books, desks and legal entities.
| Column Name |
Type |
Not Null |
Cube Field |
Description |
| AS_OF_DATE |
DATE |
Y |
|
Timestamp (at close of business) for the data. |
| TRADE_ID |
STRING |
Y |
|
Unique Trade (or Position) ID. |
| BOOK |
STRING |
Y |
[Booking].[Books] |
The book to map the trade to (must match the node in the Book Hierarchy). |
| LEGAL_ENTITY |
STRING |
Y |
[Organization].[Legal Entities] |
Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy). |
| TRADE_DATE |
DATE |
|
[Dates].[TradeDates] |
The date on which the trade took place. |
Unique Key
| Columns |
| AS_OF_DATE |
| TRADE_ID |
Incoming Joins
| Source Table |
Source Columns |
Target Columns |
Cube |
| TRADE_BASE |
AS_OF_DATE
TRADE_ID |
AS_OF_DATE
TRADE_ID |
StandardisedApproachCube |
Outgoing Joins