Global Datastore Definition

This section describes stores that are common to all cubes. This includes FX rates and trade booking.

FX Rates

The FX rates are stored in the FXRates store.

Trade Booking

The TradeMapping store maps trades to books and legal entities by TradeId and AsOfDate.

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.

The multi-level book organizational hierarchy is indexed by Book and AsOfDate. It is built from the BookParentChild store and stored in the BookHierarchy store.

The multi-level legal entity organizational hierarchy is indexed by LegalEntity and AsOfDate. It is built from the LegalEntityParentChild store and stored in the LegalEntityHierarchy store.

The LegalEntityAttributes store provides a description of the legal entities.