Notifications
Announcements
No record found.
Hi,
I am trying to replicate some Sales Cube results using T-SQL.
Is there any documentation as to what tables the Cube is built and how it all joins together?
Thanks
Hi Russell15,
There is no documentation apart from objects in Dynamics AX itself. You can view which tables are included under the Perspectives node of the AOT.
Hello Russell15,
There is some high level reference available here:
docs.microsoft.com/.../sales-cube-salescube-for-microsoft-dynamics-ax-2012-r2-and-r3
It does not show you details but gives you an idea what is inside.
Do you have a demo machine available where you can deploy and run the cube?
Then you can have a look at the detailed construction of the cube yourself.
Another option that might help also help at least a bit are the perspectives in the AX2012 AOT. When you open the node, you will find a reference to the different cubes and can at least see the tables/view it is build upon.
Best regards,
Ludwig
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
