Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / In which tables are st...
Microsoft Dynamics AX (Archived)

In which tables are stored the financial dimensions?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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
    Sameer. 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
    Abubaker Siddiq 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
    dolee 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
    Iulian Cordobin 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
    Community Member Microsoft Employee 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
    Iulian Cordobin 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
    Guy Terry 28,621 Super User 2024 Season 2 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans