> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# BookHierarchy

The **BookHierarchy** store contains the multi-level book and desk organizational structure.
It is built from the [BookParentChild](./bookparentchild) store.

It is indexed by **Book** and **AsOfDate** and referenced from the [TradeMapping](./trademapping) store by these two fields.

| Store Field      | Key | CanBeNull | Type (+Default Value - if applicable)                                                                                     | Cube Field                | Description                                                                                      |
| ---------------- | --- | --------- | ------------------------------------------------------------------------------------------------------------------------- | ------------------------- | ------------------------------------------------------------------------------------------------ |
| HierarchyLevel1  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 1                   | Node at level 1 of the book hierarchy.                                                           |
| HierarchyLevel2  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 2                   | Node at level 2 of the book hierarchy.                                                           |
| HierarchyLevel3  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 3                   | Node at level 3 of the book hierarchy.                                                           |
| HierarchyLevel4  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 4                   | Node at level 4 of the book hierarchy.                                                           |
| HierarchyLevel5  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 5                   | Node at level 5 of the book hierarchy.                                                           |
| HierarchyLevel7  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 7                   | Node at level 6 of the book hierarchy.                                                           |
| HierarchyLevel6  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 6                   | Node at level 7 of the book hierarchy.                                                           |
| HierarchyLevel8  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 8                   | Node at level 8 of the book hierarchy.                                                           |
| HierarchyLevel9  |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 9                   | Node at level 9 of the book hierarchy.                                                           |
| HierarchyLevel10 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 10                  | Node at level 10 of the book hierarchy.                                                          |
| HierarchyLevel11 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 11                  | Node at level 11 of the book hierarchy.                                                          |
| HierarchyLevel12 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 12                  | Node at level 12 of the book hierarchy.                                                          |
| HierarchyLevel13 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 13                  | Node at level 13 of the book hierarchy.                                                          |
| HierarchyLevel14 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 14                  | Node at level 14 of the book hierarchy.                                                          |
| HierarchyLevel15 |     |           | String("\_DATAMEMBER\_")[See knowledgebase](https://activeviam.atlassian.net/wiki/spaces/AP5/pages/22898820/Data+Members) | Level 15                  | Node at level 15 of the book hierarchy.                                                          |
| Book             | Y   |           | String                                                                                                                    | [Books](../../cube/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.                                                   |