BookHierarchy

The BookHierarchy store contains the multi-level book and desk organizational structure. It is built from the BookParentChild store.

It is indexed by Book and AsOfDate and referenced from the TradeMapping store by these two fields.

Store Field Key CanBeNull Type (+Default Value - if applicable) Cube Field Description
HierarchyLevel1 String("_DATAMEMBER_")See knowledgebase Level 1 Node at level 1 of the book hierarchy.
HierarchyLevel2 String("_DATAMEMBER_")See knowledgebase Level 2 Node at level 2 of the book hierarchy.
HierarchyLevel3 String("_DATAMEMBER_")See knowledgebase Level 3 Node at level 3 of the book hierarchy.
HierarchyLevel4 String("_DATAMEMBER_")See knowledgebase Level 4 Node at level 4 of the book hierarchy.
HierarchyLevel5 String("_DATAMEMBER_")See knowledgebase Level 5 Node at level 5 of the book hierarchy.
HierarchyLevel7 String("_DATAMEMBER_")See knowledgebase Level 7 Node at level 6 of the book hierarchy.
HierarchyLevel6 String("_DATAMEMBER_")See knowledgebase Level 6 Node at level 7 of the book hierarchy.
HierarchyLevel8 String("_DATAMEMBER_")See knowledgebase Level 8 Node at level 8 of the book hierarchy.
HierarchyLevel9 String("_DATAMEMBER_")See knowledgebase Level 9 Node at level 9 of the book hierarchy.
HierarchyLevel10 String("_DATAMEMBER_")See knowledgebase Level 10 Node at level 10 of the book hierarchy.
HierarchyLevel11 String("_DATAMEMBER_")See knowledgebase Level 11 Node at level 11 of the book hierarchy.
HierarchyLevel12 String("_DATAMEMBER_")See knowledgebase Level 12 Node at level 12 of the book hierarchy.
HierarchyLevel13 String("_DATAMEMBER_")See knowledgebase Level 13 Node at level 13 of the book hierarchy.
HierarchyLevel14 String("_DATAMEMBER_")See knowledgebase Level 14 Node at level 14 of the book hierarchy.
HierarchyLevel15 String("_DATAMEMBER_")See knowledgebase Level 15 Node at level 15 of the book hierarchy.
Book Y String Books Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.
AsOfDate Y LOCALDATE[yyyy-mm-dd] Timestamp (at close of business) for the data.