AX2675

Dimensions and hierarchies

Reference tables are often used to define the dimensions of your system. Dimensions are the levels at which planning and reporting activities are performed in your system—such as department and account.

Reference tables can have one or more column hierarchies, which define hierarchical and rollup relationships for dimensions and their groupings. For example, you can have a Geography hierarchy where departments roll up into regions, and regions roll up into countries. These hierarchies are used throughout the system to define data filters and to define drilling paths.

Using the Dimension Manager, you can create, edit, and delete column hierarchies, as well as edit the hierarchy assignments for members of the dimension.