Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Relation between tables MainAccount and DimensionAttributeValue

Posted on by Microsoft Employee

Hello,

Can anyone explain the relation between the tables MainAccount and DimensionAttributeValue ?

I am looking into form MainAccountsListPage where it uses a Preview Part MainAccountDetailPart.

This preview part has 2 datasources used in it. 1. MainAccount and  2. DimensionAttributeValue.

I am not sure on what relation it is making inner join between them. 

Can anyone explain? Thanks.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,663 Super User on at
    RE: Relation between tables MainAccount and DimensionAttributeValue

    Hi VDY,

    You can download the whitepaper "Implementing the Account and Financial Dimensions Framework". At the end of the document also some data models are included.

    Download the document using this link: technet.microsoft.com/.../hh272858.aspx

  • Verified answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,786 on at
    RE: Relation between tables MainAccount and DimensionAttributeValue

    DimensionAttributeValue.EntityInstance == MainAccount.RecId

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans