Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

In which tables are stored the financial dimensions?

(0) ShareShare
ReportReport
Posted on by

Hi Masters

We use AX2012 R3 CU8

In which tables are stored the financial dimensions??.

Thanks for help

*This post is locked for comments

  • Sameer. Profile Picture
    35 on at
    RE: In which tables are stored the financial dimensions?

    Business Unit, Cost center, Department are stored in OMOperatingUnit table based on OMOperatingUnitType.

    Location, Region are stored in DimensionFinancialTag table.

  • Abubaker Siddiq Profile Picture
    760 on at
    RE: In which tables are stored the financial dimensions?

    Thank you. Very useful.

    I just wanted to ask one question which related to Financial dimensions.

    The DimensionAttributeValueCombination table has a column "DisplayValue" which stores the complete account with the dimensions it is going to hit.

    Lets say we change department dimension from ABC to XYZ, will it have any impact? Is this field is used for any processing or it is only used to display the value. If it is only used to display the value, how the system knows which financial dimension to hit because it is not saving those dimension values in table column specified in the JV. 

    Waiting for reply.

    Thanks.

     

  • dolee Profile Picture
    11,279 on at
    RE: In which tables are stored the financial dimensions?

    Just to add, for custom dimensions, you can look at DimensionFinancialTag Table. It stores dimension values for all custom dimensions (not based on some master table)

  • Suggested answer
    Iulian Cordobin Profile Picture
    8,201 on at
    RE: In which tables are stored the financial dimensions?

    You can find the tables in the pdf mentioned, but to summarize they are: DimensionAttributeSet, DimensionAttributeSetItem, DimensionAttribute, and their *Value counterparts DimensionAttributeValueSet, DimensionAttributeValueSetItem, DimensionAttributeValue.

  • Community Member Profile Picture
    on at
    RE: In which tables are stored the financial dimensions?

    Hi Guy

    Both, but especially financial dimension values.

    dimen.jpg

  • Suggested answer
    Iulian Cordobin Profile Picture
    8,201 on at
    RE: In which tables are stored the financial dimensions?

    I think the whitepaper from this link (MS download) is the best at explaining what you are looking for download.microsoft.com/.../Implementing_the_Account_and_Financial_Dimensions_Framework_AX2012.pdf

  • Guy Terry Profile Picture
    28,751 Super User 2025 Season 1 on at
    RE: In which tables are stored the financial dimensions?

    Do you mean the dimension names like 'Cost center', 'Business unit', 'Purpose', or the dimension values that you can select for each dimension?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans