Moving from NAV to AX 2012 - How to understand dimensions

bspencer

Hello, everyone. My company is moving from Navision 4.0 to AX 2012. I have been tasked with creating reports. I understand the dimension structure in Navision well after years of working with it, but am having trouble grasping where everything is in AX. In Navision, there are three of four tables that store dimension values per posted document ID or general ledger entry number, and there is a single dimension value per record (not all dimensions being recorded in a single field separated by a dash as in AX).

I have found a few blog posts online that have proven to be helpful, but still I am not understanding everything. I get the concept, but am having trouble seeing how all the tables involved join together. Is there any resource out there that anybody can recommend to me for learning the dimension structure in AX? Perhaps if somebody had a SQL statement that demonstrates all the joins to identify the dimensions for say a single general ledger entry? I will take anything I can get.

Thanks!