web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Relation between table...

Microsoft Dynamics AX (Archived)

Relation between tables MainAccount and DimensionAttributeValue

(0) Share

Report

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Brandon Wiese 17,790 on at

Like
a
(0)

Report
Copy link

Link copied!

DimensionAttributeValue.EntityInstance == MainAccount.RecId

Was this reply helpful? Yes No
André Arnaud de Cal... 306,268 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans