Global Datastore Definition

This page provides the following:

A table of fields for each store within the Global datastore definition (that is, across all cubes).
Indicator showing whether the fields are KEY, VECTOR, or NULLABLE
A column called Cube Schema Field Name with "Y" or "N" value to indicate whether or not the datastore field is selected for the cube.
- If Y: A link is also provided to the relevant level in the associated cube (i.e. the location within the cube that is populated by the value from the datastore field)
- If N: This means the fields are either internal or measures, and there is a note to explain the details

"TradeMapping" (TRADE_MAPPING_STORE_NAME)

Field Name/Column Name

IsKey

IsVector

CanBeNull

Type

Cube Schema Field Name

(Use links to jump to the correct table in the appropriate

Cube Schema page)

TRADE_MAPPING_STORE_TRADE_ID

Y

STRING

TradeId

TRADE_MAPPING_STORE_BOOK

STRING

Book

TRADE_MAPPING_STORE_LEGAL_ENTITY

STRING

Legal Entity

"BookParentChild" (BOOK_PARENT_CHILD_STORE_NAME)

Field Name/Column Name	IsKey	Type _{(+Default Value - if applicable)}	Cube Schema Field Name
BOOK_PARENT_CHILD_STORE_CHILD	Y	STRING	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.
BOOK_PARENT_CHILD_STORE_PARENT		STRING	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.
BOOK_PARENT_CHILD_STORE_FRTB_DESK		STRING_(N)	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.
BOOK_PARENT_CHILD_STORE_CATEGORY		STRING	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.
BOOK_PARENT_CHILD_STORE_DESK_MODEL		STRING	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.
BOOK_PARENT_CHILD_STORE_IMA_ELIGIBLE		STRING	N - Populated using CSV file data - used as part of intermediary step to create the "BookHierarchy" Store.

"BookHierarchy" (BOOK_HIERARCHY_STORE_NAME)

Field Name/Column Name	IsKey	Type _{(+Default Value - if applicable)}	Cube Schema Field Name
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_1		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 1 (SA) Level 1 (IMA) Level 1 (IMA DRC) Level 1 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_2		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 2 (SA) Level 2 (IMA) Level 2 (IMA DRC) Level 2 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_3		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 3 (SA) Level 3 (IMA) Level 3 (IMA DRC) Level 3 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_4		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 4 (SA) Level 4 (IMA) Level 4 (IMA DRC) Level 4 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_5		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 5 (SA) Level 5 (IMA) Level 5 (IMA DRC) Level 5 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_6		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 6 (SA) Level 6 (IMA) Level 6 (IMA DRC) Level 6 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_7		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 7 (SA) Level 7 (IMA) Level 7 (IMA DRC) Level 7 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_8		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 8 (SA) Level 8 (IMA) Level 8 (IMA DRC) Level 8 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_9		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 9 (SA) Level 9 (IMA) Level 9 (IMA DRC) Level 9 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_10		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 10 (SA) Level 10 (IMA) Level 10 (IMA DRC) Level 10 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_11		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 11 (SA) Level 11 (IMA) Level 11 (IMA DRC) Level 11 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_12		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 12 (SA) Level 12 (IMA) Level 12 (IMA DRC) Level 12 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_13		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 13 (SA) Level 13 (IMA) Level 13 (IMA DRC) Level 13 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_14		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 14 (SA) Level 14 (IMA) Level 14 (IMA DRC) Level 14 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_LEVEL_15		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 15 (SA) Level 15 (IMA) Level 15 (IMA DRC) Level 15 (P&L)
BOOK_HIERARCHY_STORE_HIERARCHY_BOOK	Y	STRING	Book (IMA) Book (DRC)
BOOK_HIERARCHY_STORE_HIERARCHY_DESK		STRING	Desk Desk (DRC)
BOOK_HIERARCHY_STORE_HIERARCHY_CATEGORY		STRING	Category Category (DRC)
BOOK_HIERARCHY_STORE_DESK_MODEL		STRING	Model Model (DRC)
BOOK_HIERARCHY_STORE_IMA_ELIGIBLE		STRING	N - This field does not appear in any Cube - internal field only.

"LegalEntityParentChild" (LEGAL_ENTITY_PARENT_CHILD_STORE_NAME)

Field Name/Column Name	IsKey	IsVector	CanBeNull	Type	Cube Schema Field Name
LEGAL_ENTITY_PARENT_CHILD_STORE_CHILD	Y			STRING	N - Populated using CSV file data - used as part of intermediary step to create the "LegalEntityHierarchy" Store.
LEGAL_ENTITY_PARENT_CHILD_STORE_PARENT				STRING	N - Populated using CSV file data - used as part of intermediary step to create the "LegalEntityHierarchy" Store.

"LegalEntityHierarchy" (LEGAL_ENTITY_HIERARCHY_STORE_NAME)

Field Name/Column Name	IsKey	Type _{(+Default Value - if applicable)}	Cube Schema Field Name
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEVEL_1		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 1 (SA) Level 1 (IMA) Level 1 (IMA DRC) Level 1 (P&L)
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEVEL_2		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 2 (SA) Level 2 (IMA) Level 2 (IMA DRC) Level 2 (P&L)
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEVEL_3		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 3 (SA) Level 3 (IMA) Level 3 (IMA DRC) Level 3 (P&L)
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEVEL_4		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 4 (SA) Level 4 (IMA) Level 4 (IMA DRC) Level 4 (P&L)
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEVEL_5		STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	Level 5 (SA) Level 5 (IMA) Level 5 (IMA DRC) Level 5 (P&L)
LEGAL_ENTITY_HIERARCHY_STORE_HIERARCHY_LEGAL_ENTITY	Y	STRING_{(IAxisMember.DATA_MEMBER_DISCRIMINATOR)}	N - Internal field only

"FXRates" (FX_STORE_NAME)

Field Name/Column Name

IsKey

IsVector

CanBeNull

Type

Cube Schema Field Name

(FXRates is a standalone Store - none of its fields are disseminated to the Cubes)

FX_STORE_BASE_CCY Y STRING N - Only used for lookups - the fields are retrieved from the relevant cubes.

FX_STORE_COUNTER_CCY Y STRING N - Only used for lookups - the fields are retrieved from the relevant cubes.

FX_STORE_FX_RATE DOUBLE N - This field is not a part of any cube - it is calculated using the two fields above (FX_STORE_BASE_CCY and FX_STORE_COUNTER_CCY).