BOOK_HIERARCHY

The BOOK_HIERARCHY table contains the multi-level book organizational structure.

note

The content of this table is populated from the content of the BOOK_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.
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 7 N/A Node at level 6 of the book hierarchy.
BOOK_HIERARCHY_LEVEL7 STRING Y Level 6 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).

Unique Key

Columns
AS_OF_DATE
BOOK

Incoming Joins

Source Table Source Columns Target Columns
TRADE_ATTRIBUTES AS_OF_DATE
BOOK
AS_OF_DATE
BOOK

  1. If the default value is marked as empty, it means that the default value is 'null' for nullable fields, and that a value needs to be explicitly set for non-nullable fields.  ↩︎