Drill down is available if the following conditions are satisfied:
A territory dimension is hierarchical.
A territory dimension contains an integer attribute with the TOPO_ID identifier.
The TOPO_ID attribute contains a key of the map that is used for territory drill down corresponding to the element of territory dimension.
The repository should contain a map for each hierarchy level of territory dimension.
For example, there is a territory dimension containing the World root element. The World component contains the Europe and Asia child elements. Values of TOPO_ID attributes are given in the table:
Elements | Value of the TOPO_ID attribute |
World | 100 |
Europe | 200 |
Asia | 300 |
Therefore, the map with the 200 key is used to drill down the Europe territory, the map with the 300 key is used to drill down the Asia territory. The map with the 100 key is used to drill up the Europe and Asia territories.
See also:
Basic Requirements for Working with Map | Data Drill Down of Drill Up