Microsoft Dynamics AX (Archived)

DMF error for dimensions defined in advanced rule structure

(0) Share

Report

Posted on by MYGz

2,059

Hi,

I have 10 dimensions in standard accounting structure and 7 dimensions defined in advanced rule.

Importing journals through DMF in excel throws error for 17 dimensions but works with 10 dimensions.

What's the right way to resolve this?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (1)

Report

RE: DMF and Advanced accounting structure

Hi MYGz,

Are you really intending to use 17 dimensions for one single main account? There is a limitation to have per dimension combination one main account and 10 dimensions. What would be the reason to use this number of dimensions? Note that it is possible to use 17 dimensions active in one company, but not all 17 on a single account structure.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: DMF and Advanced accounting structure

Hi,

Even though you can use 17 findims, most forms and reports can only handle up to 10 as Andre mentioned.

Before continuing, I would urge you to review and modify your account structures and findims. Working with 17 findims is not a good practice and not all of them might be needed. Often there are alternatives available for analysis purposes that allow you channeling all information through the accounting system.

Best regards

Ludwig

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (1)

Report
RE: DMF and Advanced accounting structure

Thanks for the valuable inputs Andre and Ludwig.

It is airline data. For each ticket there are 17 dimensions that need to be store.

Forgot to mention that the journals are created by 2 ways, X++ code and DMF.

With X++ I'm able to successfully record the 17 dimensions by passing dimension container like so:

AxdDimensionUtil::getLedgerAccountId(myDimensionContainer)

This is how it's going to be recorded for sometime now. I'll take your advice and talk to the functional guy.

My Question: How can I make the DMF work? Create new entity or existing can be made to work with minor changes?

Thanks.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (1)

Report

RE: DMF and Advanced accounting structure

Hi MYGz,

To be able to support this, you need to do a deep dive in the existing dimension classes and also extend some (temporary) tables. There can be also impact on e.g. analytical workspaces and management reporter (MR can't be customized). You can also consider creating table with tickets with all these attributes as fields. Then make this ticket table dimensionable. For sure, every approach needs to have analysis with all pros and cons.

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

RE: DMF and Advanced accounting structure

Hi Andre,

Someone suggested KB 4054241 hot-fix to resolve this. But the problem is, hot-fix is available for CU13 version while our business client is using CU10 version.

Any tips on this? Can CU13 hot-fix be applied on CU10?

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (1)

Report

RE: DMF and Advanced accounting structure

Hi MYGz,

You cannot directly apply the CU13 hotfix on a CU10 environment. There can be a lot of dependencies changed. You can evaluate the changes for this KB to install it on top of a CU13 environment. Then you are able to see if you can manually extract the changes and make it as customization on the CU10 environment.

Note that this approach is not supported by Microsoft. They would recommend to install CU13 first. Depending on the current customizations or add-on solutions in your environment this is easy or a more cumbersome job.

Was this reply helpful? Yes No
Verified answer

MYGz 2,059 on at

Like (1)

Report
RE: DMF and Advanced accounting structure

Thanks for the info André.

I got the solution. The issue was in generateDynamicDimension() method in DmfDimensionHelper Class.

Although It was bringing in all the dimensions values from the Segmented Entry Dimension column from Excel Sheet, it was picking only those Dimension names from the table where DimensionHierarchyType is AccountStructure and not from the Advanced Rule. I included DimensionHierarchyType of AccountRuleStructure as well. Now it's working.

while select Level from dimHierarchyLevel order by dimHierarchyLevel.DimensionHierarchy, dimHierarchyLevel.Level where (dimHierarchyLevel.DimensionHierarchy == dimHierarchyId && dimHierarchy.IsDraft == false && dimHierarchy.IsSystemGenerated == false && (dimHierarchy.StructureType == DimensionHierarchyType::AccountStructure || dimHierarchy.StructureType == DimensionHierarchyType::AccountRuleStructure) join * from dimAttribute where dimAttribute.RecId == dimHierarchyLevel.DimensionAttribute exists join ledgerStructure where ledgerStructure.DimensionHierarchy == dimHierarchy.RecId && ledgerStructure.Ledger == Ledger::current()

DimensionHierarchyType Enum

Was this reply helpful? Yes No