Requirements for Territory Drill Down

Drill down is available if the following conditions are met:

  1. Territory dimension is hierarchical.

  2. Territory dimension contains an integer attribute with the TOPO_ID identifier.

  3. The TOPO_ID attribute contains key of the map that is used for territory info corresponding to the element of territory dimension.

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

Items

TOPO_ID

World

100

Europe

200

Asia

300

Consequently, to drill down the Europe territory the map with the 200 key is used, to drill down the Asia territory the map with the 300 key is used. To drill up the Europe and Asia territories the map with the 100 key is used.

See also:

Basic Requirements for Working with Map | Data Drill Down of Drill Up