Microsoft Dynamics AX (Archived)

Financial Dimension set what is the limit for creation

(0) Share

Report

Posted on by atef@83

805

Dear All

i have in my structure 64 available Dim can i create in Financial Dim Set one for all or there is limit for creation

and if i want to display all when i print Dimension statement how is it possible

75678.Capture.PNG

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello atef083,

The limit in most forms and reports is 10 fin dims plus the main account. If you assign more then you have to adjust many reports, forms, etc. or alternatively analyze the data in PowerBI.

You can have a look at my blog where I once described the limits that we have here.

Best regard,

Ludwig

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

I struggle to understand how or why you would want to do that. On Ledger trial balance form in General Ledger (since CU6) it is possible to split ledger dimension field into separate columns, one per dimension.The code which generates the dimension values uses the DimensionFocusNameTmp table which has only 11 fields with dimensions. Therefore the maximum number of dimensions which can be visible on the form is 11.

There is a separate method in this table indicating there is a limit :t:

/// <summary>

/// Gets the maximum hierarchy length supported by this table.

/// </summary>

/// <returns>

/// The maximum hierarchy length supported by this table.

/// </returns>

private static int maxHierarchyLength()

{

return 11;

}

You could use array fields the table to simplify the process of adding new level of dimensions. However, because every dimension has a separate field it will take time and code to add a new dimension level to the table; However I doubt the TB would ever initialize or open with such a large set.

There is a performance cost for each additional dimension in terms of performance impact, and database size, and of course, the more data entry the more potential there is for data entry errors. The trial balance list page cannot page the data, so when selecting a dimension set that contains all of the dimensions to display, the system has to go through all the combinations for the current company and date range.

. (10 dimensions each having 10 values is 10x10x10x10x10x10x10 x10x10x10 possible combinations - and that then has to be multiplied by the number of main accounts)

If you create a financial dimension based on Customer and you have 10,000 customers, then you will have 10,000 values. Taken into combination with the other financial dimensions and their values, you could have 100s or 1,000s of thousands of combinations of account numbers generated which will impact the performance of many queries. What if you want to an expense split like marketing across all customers – how many journal lines will be posted? So then Customer group or line of business might be more pragmatic.

A good resource to help you understand the financial dimension framework on Dynamics AX 2012 is the technical document : Implementing the Account and Financial Dimensions Framework for Microsoft Dynamics AX 2012.

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

Like (1)

Report

Hi Atef,

I wonder how it would be possible to get a number of 64 dimensions in one legal entity. What is the purpose of all these dimensions?

Was this reply helpful? Yes No
atef@83 805 on at

Like (0)

Report

Hi Andre

i'am using this Dim instead of create a lot of account's here in my customer COA we have more than 1000 account so we change it to be 600 account and use the Dim but all of this Dim is using with advanced Rule for some accounts and i using only Main account in Structure so from your Exp is this will effect in my transaction in the future can i will face some lag in the data of any thing thanks in advance

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi atef083,

The original question was whether you can add your 64 findims to the financial dimension set.

As far as I remember that is not possible.

After you assigned 11 you should get an error message.

A possible workaround is to create multiple financial dimension sets.

As an example set 1 with the first 10 findims, set 2 with the next 10 findims and so on.

However, you mentioned that you even work with advanced rule structures.

This make me thinking that the complete account - findim setup must be very complex.

How do you maintain this for example if you have to add a couple of new cost centers or stop users from using specific departments or other findims that you use.

I would imagine that maintaining the whole 'thing' must be very complicated.

Can you share some insights on this?

Best regards,

Ludwig

Was this reply helpful? Yes No

Community site session details

Financial Dimension set what is the limit for creation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Financial Dimension set what is the limit for creation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates