BeyondERP.Newsletter
Menu

Setup step on the Imported statistical dimension members page · Cost accounting

Import statistical elements from a file

Load statistical dimension members from another system through the Imported transactions data connector.

Used by
Cost accountant, Cost accounting manager
Business process
Define cost accounting reporting structure in Dynamics 365 Finance
Menu item
CAMImportedStatisticalDimensionMember
Main table
CAMDataImportedDimensionMember
Data entity
CAMImportedStatisticalDimensionMemberEntity
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 staging page that shows the statistical dimension member records (source identifier, member name, member description, unit of measure) loaded through Data management with the Imported statistical dimension members data entity, ready for a dimension that uses the Imported dimension members data connector.
What you do hereUse this page to review the statistical dimension members imported from a file before you import them into a statistical dimension, and to see which source identifier each member belongs to.
ExampleFor example, statistical elements such as FTE (Ea.), Electricity (kWh) and Pack CC (Hrs.) can be loaded from a file and imported into a statistical dimension that uses the Imported dimension members data connector.
Imported statistical dimension members 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

Import statistical elements from a file

Load statistical dimension members from another system through the Imported transactions data connector.

Steps from Microsoft

  1. Go to System administration > Workspaces > Data management and create an import project.
  2. Add the Imported statistical dimension members entity with your file, map the columns and import.
  3. Go to Cost accounting > Imported data > Data entity > Imported statistical dimension members and check the rows, filtering on the source identifier.
  4. Open the statistical dimension and select Import dimension members.
  5. Check that each member appears with its unit on Predefined dimension member allocation bases.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Source identifier (SourceIdentifier)Identifier of the external source the member came from; the data provider configuration uses it to match imported rows to the dimension.Microsoft Learn
Member name (MemberName)The dimension member value, such as a main account number or a cost center code.Microsoft Learn
Member description (MemberDescription)The description shown for the dimension member.Microsoft Learn
Unit of measure (UnitOfMeasureSymbol)The unit the statistical member is measured in, such as Ea., kWh or Hrs.Microsoft Learn

Common errors and fixes

MessageWhat to do
Corrected source figures don't show in Cost accountingCost accounting keeps its own copy of the source data. Import the data again and process the source data for the period. Microsoft Learn
Statistical dimension members can't be brought in through the Dynamics 365 Finance data connectorStatistical dimension members can only come from the Imported transactions data connector. Enter them by hand or load them with the Imported statistical dimension members entity. Microsoft Learn
Imported members don't appear on the dimensionSet the dimension's data connector to Imported transactions, configure the provider with the same source identifier, and select Import dimension members. Microsoft Learn

Test checklist

  1. Load a file with FTE, Electricity and Pack CC and their units.
  2. Import the members into the statistical dimension.
  3. Open Predefined dimension member allocation bases.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Import statistical elements from a fileLoad each statistical element with its unit, for example FTE (Ea.), Electricity (kWh) and Pack CC (Hrs.).This entity is the only import route for statistical dimension members, and each member becomes a predefined allocation base.Should statistical dimension members be loaded from files or come from a connector?Changing a member's name in a later file: the new name becomes a new allocation base, and the rules keep using the old one.Test: Import statistical elements from a file end to end

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 load and check imported data. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: Data management lists the entity as shared by all companies, so the rows aren't tied to one legal entity. Checked in Dynamics 365
Can it be undoneReversible: A corrected file can be imported again; process the source data again to replace the entries.
If you change it laterImported rows sit in a Cost accounting staging table shared by every cost accounting ledger, so a change here affects every dimension and ledger that imports members from it. Microsoft Learn
Technical architect

6Technical

Menu itemCAMImportedStatisticalDimensionMember Checked in Dynamics 365
FormCAMImportedDimensionMember Checked in Dynamics 365
TableCAMDataImportedDimensionMemberShown as “IMPORTED DIMENSION MEMBERS” in Record infoKey field: Name, SourceIdentifierChecked in Dynamics 365
Data entitiesCAMImportedStatisticalDimensionMemberEntityImported statistical dimension members Microsoft data model
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyInquire into imported dimension membersCAMImportedDimensionMembersInquire
      • PrivilegeView the imported dimension membersCAMImportedDimensionMemberEntityView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into imported dimension membersCAMImportedDimensionMembersInquire
      • PrivilegeView the imported dimension membersCAMImportedDimensionMemberEntityView
Checked in Dynamics 365
Roles to set it up and use itTo use itInquire into imported dimension members CAMImportedDimensionMembersInquireGive people a role that holds these duties. On this system, 2 roles give access to this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMImportedStatisticalDimensionMember
Integrate withCAMImportedStatisticalDimensionMemberEntity data entity Microsoft data model
Data migrationCAMImportedStatisticalDimensionMemberEntity (Imported statistical dimension members): shared by all companies; Data management lists it as enabled in the Cost accounting module.Load order: Not part of Microsoft's default configuration templates. Load the dimension members first (cost element, cost object, statistical), then the general ledger entries, budget entries and statistical measures that refer to them, and then process the source data on the cost accounting ledger.Microsoft Learn
Everyone

8Sources

To cite this step: CA-IMP-030, Import statistical elements from a file. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CA-IMP-030