BOOK_HIERARCHY

The content of this table is populated from the content of the BOOK_PARENT_CHILD table.

Column Name	Type	Not Null	Cube Field	Default Value¹	Description
AS_OF_DATE	DATE	Y			Timestamp (at close of business) for the data.
BOOK	STRING	Y		N/A	Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.
BOOK_HIERARCHY_LEVEL1	STRING	Y	Level 1	N/A	Node at level 1 of the book hierarchy.
BOOK_HIERARCHY_LEVEL2	STRING	Y	Level 2	N/A	Node at level 2 of the book hierarchy.
BOOK_HIERARCHY_LEVEL3	STRING	Y	Level 3	N/A	Node at level 3 of the book hierarchy.
BOOK_HIERARCHY_LEVEL4	STRING	Y	Level 4	N/A	Node at level 4 of the book hierarchy.
BOOK_HIERARCHY_LEVEL5	STRING	Y	Level 5	N/A	Node at level 5 of the book hierarchy.
BOOK_HIERARCHY_LEVEL6	STRING	Y	Level 6	N/A	Node at level 6 of the book hierarchy.
BOOK_HIERARCHY_LEVEL7	STRING	Y	Level 7	N/A	Node at level 7 of the book hierarchy.
BOOK_HIERARCHY_LEVEL8	STRING	Y	Level 8	N/A	Node at level 8 of the book hierarchy.
BOOK_HIERARCHY_LEVEL9	STRING	Y	Level 9	N/A	Node at level 9 of the book hierarchy.
BOOK_HIERARCHY_LEVEL10	STRING	Y	Level 10	N/A	Node at level 10 of the book hierarchy.
BOOK_HIERARCHY_LEVEL11	STRING	Y	Level 11	N/A	Node at level 11 of the book hierarchy.
BOOK_HIERARCHY_LEVEL12	STRING	Y	Level 12	N/A	Node at level 12 of the book hierarchy.
BOOK_HIERARCHY_LEVEL13	STRING	Y	Level 13	N/A	Node at level 13 of the book hierarchy.
BOOK_HIERARCHY_LEVEL14	STRING	Y	Level 14	N/A	Node at level 14 of the book hierarchy.
BOOK_HIERARCHY_LEVEL15	STRING	Y	Level 15	N/A	Node at level 15 of the book hierarchy.
DESK	STRING	Y	Desks	N/A	The desk to which the book belongs. This will match one of the non-_DATAMEMBER_ nodes in levels 1 - 15.
CATEGORY	STRING	Y		N/A	Optional category for the node (and all descendant nodes).

Column Name

Type

Not Null

Cube Field

Default Value¹

Description

AS_OF_DATE

DATE

Timestamp (at close of business) for the data.

BOOK

STRING

N/A

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

BOOK_HIERARCHY_LEVEL1

STRING

Level 1

N/A

Node at level 1 of the book hierarchy.

BOOK_HIERARCHY_LEVEL2

STRING

Level 2

N/A

Node at level 2 of the book hierarchy.

BOOK_HIERARCHY_LEVEL3

STRING

Level 3

N/A

Node at level 3 of the book hierarchy.

BOOK_HIERARCHY_LEVEL4

STRING

Level 4

N/A

Node at level 4 of the book hierarchy.

BOOK_HIERARCHY_LEVEL5

STRING

Level 5

N/A

Node at level 5 of the book hierarchy.

BOOK_HIERARCHY_LEVEL6

STRING

Level 6

N/A

Node at level 6 of the book hierarchy.

BOOK_HIERARCHY_LEVEL7

STRING

Level 7

N/A

Node at level 7 of the book hierarchy.

BOOK_HIERARCHY_LEVEL8

STRING

Level 8

N/A

Node at level 8 of the book hierarchy.

BOOK_HIERARCHY_LEVEL9

STRING

Level 9

N/A

Node at level 9 of the book hierarchy.

BOOK_HIERARCHY_LEVEL10

STRING

Level 10

N/A

Node at level 10 of the book hierarchy.

BOOK_HIERARCHY_LEVEL11

STRING

Level 11

N/A

Node at level 11 of the book hierarchy.

BOOK_HIERARCHY_LEVEL12

STRING

Level 12

N/A

Node at level 12 of the book hierarchy.

BOOK_HIERARCHY_LEVEL13

STRING

Level 13

N/A

Node at level 13 of the book hierarchy.

BOOK_HIERARCHY_LEVEL14

STRING

Level 14

N/A

Node at level 14 of the book hierarchy.

BOOK_HIERARCHY_LEVEL15

STRING

Level 15

N/A

Node at level 15 of the book hierarchy.

DESK

STRING

Desks

N/A

The desk to which the book belongs. This will match one of the non-_DATAMEMBER_ nodes in levels 1 - 15.

Unique Key

Incoming Joins

​Unique Key

​Incoming Joins

Footnotes

Unique Key

Incoming Joins