BeyondERP.Newsletter
Menu

Setup step on the Dimension hierarchies page · Cost accounting

Set up Dimension hierarchies

Use this page to create a dimension hierarchy, choose its type (categorization for cost element reporting, or classification for rules and reporting on any dimension), and arrange nodes with from/to dimension member ranges. The hierarchies you create here are what the Cost control workspace, the policies and the access list security refer to.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Define costing policies
Menu item
CAMDimensionHierarchy
Main table
CAMDataDimensionHierarchy
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you build tree structures of nodes and dimension member ranges over a cost element, cost object or statistical dimension, for reporting, for policy rules and for access security.
What you do hereUse this page to create a dimension hierarchy, choose its type (categorization for cost element reporting, or classification for rules and reporting on any dimension), and arrange nodes with from/to dimension member ranges. The hierarchies you create here are what the Cost control workspace, the policies and the access list security refer to.
ExampleFor example, you set up an Organization hierarchy on the Cost centers dimension with Admin and Production nodes, each holding ranges of cost center IDs, so that managers can see costs aggregated at department level.
Dimension hierarchies page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Dimension hierarchies

Use this page to create a dimension hierarchy, choose its type (categorization for cost element reporting, or classification for rules and reporting on any dimension), and arrange nodes with from/to dimension member ranges. The hierarchies you create here are what the Cost control workspace, the policies and the access list security refer to.

Steps from Microsoft

  1. Go to Cost accounting > Dimensions > Dimension hierarchies.
  2. Select New, choose Dimension classification hierarchy as the hierarchy type, and select Create.
  3. Enter the Dimension hierarchy name and select the Dimension (for example Cost centers), then select Save.
  4. Select View hierarchy.
  5. Select New and enter a Node name for each level of the structure, selecting the parent node in the tree before adding subnodes.
  6. On a lowest-level node, select New in the dimension member ranges list and enter the From dimension member and To dimension member.
  7. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Dimension hierarchy nameThe name of the hierarchy, for example Organization or Cost behavior.Microsoft Learn Name
DimensionThe single dimension (cost element, cost object or statistical) that this hierarchy structures.Microsoft Learn Dimension
Dimension hierarchy type nameDimension categorization hierarchy (cost element reporting only, members may repeat) or Dimension classification hierarchy (rules and reporting, each member once).Microsoft Learn
Access list hierarchyYes marks the hierarchy as the one used to control which users may view which cost objects.Microsoft Learn
Node nameThe name of a node in the tree; a node can hold subnodes or leaf-level member ranges, but not both.Microsoft Learn
From dimension member / To dimension memberThe range of dimension member IDs assigned to a leaf node; a node can hold several ranges and may reference members that do not exist yet.Microsoft Learn
User ID (Users FastTab)User IDs attached to a node of the access list hierarchy to grant those users view access to the cost objects under the node.Microsoft Learn

Common errors and fixes

MessageWhat to do
A validation message says a dimension member is missing from a classification hierarchyAdd the member to a node of the hierarchy. A classification hierarchy must hold every member of its dimension. Microsoft Learn
A manager sees cost objects outside their node in an Excel exportThe access list hierarchy doesn't secure data exported to Excel. Limit who can export, and rely on the Cost control workspace and Power BI for secured views. Microsoft Learn
Power BI shows a manager every cost objectPair the access list hierarchy with row-level security: add the manager to the Cost object controller role on PowerBI.com and update the entity store. Microsoft Learn

Test checklist

  1. Create an Organization hierarchy on the cost center dimension with type Dimension classification hierarchy, plus nodes Admin > Finance and HR, each with From/To dimension member ranges.
  2. Create a Cost behavior hierarchy on the cost element dimension with Fixed cost and Variable cost nodes, and check that the ranges don't overlap.
  3. Set Access list hierarchy to Yes on Organization, add a User ID on the Finance node, and turn on Enable view access for cost object dimension members in Cost accounting parameters.
  4. Sign in as that user and check that the Cost control workspace shows only the Finance cost centers.
  5. Create a new Excel export for the hierarchy and check that the change appears without waiting for the 24-hour refresh.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Dimension hierarchiesDimension classification hierarchy for anything used in policies, access security or cost object reporting. Dimension categorization hierarchy only for cost element reports where one member must appear in more than one node.The classification type supports all dimensions and is the type used to define rules. The categorization type supports only cost element dimensions and is meant for reporting.Which dimension hierarchy type should each hierarchy use?Hierarchies aren't date-effective. An edit is saved straight to the record, flows into every policy rule that uses the hierarchy, and leaves no before/after version to compare. Use Copy to keep the old structure first. Excel and Power BI export only the first 15 levels.Test: Organization hierarchy aggregates cost centers

Feature management and licence

Licence or add-inCost accounting has four roles: Cost accounting manager (Activity licence), Cost accountant and Cost accountant clerk (Operations licence), and Cost object controller (Team members licence). Cost accountants and cost accounting managers maintain hierarchies; the access list nodes name the Cost object controllers. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: Cost accounting setup isn't kept per legal entity. It is the same from every company, and one cost accounting ledger can collect data from several legal entities. Checked in Dynamics 365
Can it be undoneHard to reverse: Changes are saved immediately and aren't date-effective, so you can't go back to an earlier version unless you copied the hierarchy first. Policies pick up the change automatically. Excel and Power BI see it after the 24-hour cache job, or straight away if you create a new Excel export.
If you change it laterChanges are saved immediately and are not date-effective, so you cannot compare before and after versions; policy rules that use the hierarchy pick the change up automatically, while Excel and Power BI see it only after the 24-hour cache refresh or a new Excel export. Microsoft Learn
Technical architect

6Technical

Menu itemCAMDimensionHierarchy Checked in Dynamics 365
FormCAMDimensionHierarchy Checked in Dynamics 365
TableCAMDataDimensionHierarchyShown as “DIMENSION HIERARCHIES” in Record infoKey field: NameChecked in Dynamics 365
Who can open it

3 security roles. Select a role to see its duties and privileges.

  • RoleCost accountantCAMCostAccountant
    • DutyMaintain dimension hierarchiesCAMDimensionHierarchiesMaintain
      • PrivilegeMaintain dimension hierarchy detailsCAMDimensionHierarchyMaintain
    • DutyMaintain dimension hierarchy access listsCAMDimensionHierarchyAccessListsMaintain
      • PrivilegeMaintain dimension hierarchy access list hierarchy assignmentsCAMDimensionHierarchyAccessListHierarchyAssignmentMaintain
      • PrivilegeView dimension hierarchy detailsCAMDimensionHierarchyView
    • DutyMaintain dimension hierarchy treesCAMDimensionHierarchyTreesMaintain
      • PrivilegeView dimension hierarchy detailsCAMDimensionHierarchyView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyMaintain dimension hierarchy treesCAMDimensionHierarchyTreesMaintain
      • PrivilegeView dimension hierarchy detailsCAMDimensionHierarchyView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into dimension hierarchy treesCAMDimensionHierarchyTreesInquire
      • PrivilegeView dimension hierarchy detailsCAMDimensionHierarchyView
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain dimension hierarchies CAMDimensionHierarchiesMaintainMaintain dimension hierarchy access lists CAMDimensionHierarchyAccessListsMaintainMaintain dimension hierarchy trees CAMDimensionHierarchyTreesMaintainTo use itInquire into dimension hierarchy trees CAMDimensionHierarchyTreesInquireGive people a role that holds these duties. On this system, 3 roles give access to this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): View hierarchy, Copy hierarchyChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMDimensionHierarchy
Data migrationLoad order: A dimension hierarchy has no data entity in Data management, so it can't be loaded from a file or a configuration template. Re-create the hierarchies by hand in each environment, or copy a hierarchy within the environment before you change it.Microsoft Learn
Everyone

8Sources

To cite this step: CA-DIM-040, Set up Dimension hierarchies. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CA-DIM-040