Can someone let me know the join relation of DimAttributeOMDepartment and DimensionAttributeValue? The reason that I want to understand it is I want to create a Department owner report which has 3 fields (Department Value, Description, Owner).
I tried to add owner field on the Financial dimension value form. It did added but didn't display any values. The only way that I can find out the owner info is highlighting one department on the left pane of Financial dimension value form then look at the Owner dropdown box at right pane of Financial dimension value form. One department at a time. If I have a list report has Department value, Description, Owner side by side that will be very nice.
You can download a whitepaper "Implementing the Account and Financial Dimensions Framework for Microsoft Dynamics AX 2012 Applications" from the next link:
This gives already some explanaition.
The link is based on the fields EntityInstance and DimensionAttribute fields ni the table DimensionAtrtributeValue.
The EntityInstance is equal to the RecId of the DimAttributeOMDepartment (view based on OMOperatingUnit and some other tables)
The table DimensionAttribute contains information on the backing entity TableId and fields. (Non visible).
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.
Thanks for your help André! It worked.
also thanks for the white paper link too. lots of useful info.