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 | [Booking].[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. |