Navigation :
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. |