TradeMapping - Atoti Hub

The TradeMapping store maps trades to books and legal entities by TradeKey and AsOfDate. It is referenced from the base tables in all the trade-level cubes.

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	Type	Cube Field	Description
TradeKey	Y	String	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	Books	The book to map the trade to (must match the node in the Book Hierarchy).
LegalEntity		String	Legal Entities	Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).
TradeDate		LOCALDATE[yyyy-mm-dd]	TradeDates	The date on which the trade took place
AsOfDate	Y	LOCALDATE[yyyy-mm-dd]		Timestamp (at close of business) for the data.
Inclusion		String	Inclusion	Indicates if the trade should be included (“Y”) or not by default in the calculations.

References:

BookDescription by Book and AsOfDate
BookHierarchy by Book and AsOfDate
LegalEntityHierarchy by LegalEntity and AsOfDate
LegalEntityAttributes by LegalEntity and AsOfDate
Categories by Book and AsOfDate

LegalEntityParentChild

Internal models approach datastore definition

⌘I