COUNTERPARTY_HIERARCHY

Note: The content of this table is populated from the content of the COUNTERPARTY_PARENT_CHILD table.

Column Name	Type	Not Null	Cube Field	Default Value1	Description
AS_OF_DATE	DATE	Y			Timestamp (at close of business) for the data.
COUNTERPARTY_ID	STRING	Y	CounterpartyIds	N/A	Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.
COUNTERPARTY_HIERARCHY_LEVEL1	STRING	Y	Level 1	N/A	Node at level 1 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL2	STRING	Y	Level 2	N/A	Node at level 2 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL3	STRING	Y	Level 3	N/A	Node at level 3 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL4	STRING	Y	Level 4	N/A	Node at level 4 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL5	STRING	Y	Level 5	N/A	Node at level 5 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL6	STRING	Y	Level 6	N/A	Node at level 6 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL7	STRING	Y	Level 7	N/A	Node at level 7 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL8	STRING	Y	Level 8	N/A	Node at level 8 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL9	STRING	Y	Level 9	N/A	Node at level 9 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL10	STRING	Y	Level 10	N/A	Node at level 10 of the counterparty hierarchy.

Column Name

Type

Not Null

Cube Field

Default Value1

Description

AS_OF_DATE

DATE

Timestamp (at close of business) for the data.

COUNTERPARTY_ID

STRING

CounterpartyIds

N/A

Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.

COUNTERPARTY_HIERARCHY_LEVEL1

STRING

Level 1

N/A

Node at level 1 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL2

STRING

Level 2

N/A

Node at level 2 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL3

STRING

Level 3

N/A

Node at level 3 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL4

STRING

Level 4

N/A

Node at level 4 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL5

STRING

Level 5

N/A

Node at level 5 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL6

STRING

Level 6

N/A

Node at level 6 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL7

STRING

Level 7

N/A

Node at level 7 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL8

STRING

Level 8

N/A

Node at level 8 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL9

STRING

Level 9

N/A

Node at level 9 of the counterparty hierarchy.

COUNTERPARTY_HIERARCHY_LEVEL10

STRING

Level 10

N/A

Node at level 10 of the counterparty hierarchy.

Columns
AS_OF_DATE
COUNTERPARTY_ID

Columns

AS_OF_DATE

COUNTERPARTY_ID

Source Table	Source Columns	Target Columns
TRADE_ATTRIBUTES	AS_OF_DATE COUNTERPARTY_ID	AS_OF_DATE COUNTERPARTY_ID

Source Table

Source Columns

Target Columns

TRADE_ATTRIBUTES

AS_OF_DATE
COUNTERPARTY_ID

COUNTERPARTY_HIERARCHY

Unique Key

Incoming Joins

​Unique Key

​Incoming Joins

Unique Key

Incoming Joins