Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Moving from NAV to AX 2012 - How to understand dimensions
bspencer
Member Posts: 50
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!
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!
0