Perspective is a collection of tables

Posted on May 16 2014 in Tableau & Microsoft Dynamics

If you are not sure which tables you should select as a starting point for your Tableau data analysis you can get help from the cubes already created in Microsoft Dynamics AX.

The following cubes are provided:

  • Ledger cube
  • Human Resources Management cube
  • Sales cube
  • Purchasing cube
  • Accounts Receivable cube
  • Project Accounting cube
  • Production cube
  • Customer Relationship Management cube
  • Expense Management cube
  • Accounts Payable cube

In the Application Object Tree (AOT) expand the node for the perspective:

AOT

 

 

 

 

 

 

 

 

 

 

 

 

 

To see the tables that are used to define the cube, expand the cube (in this case the Ledger cube)

Ledger Cube

no comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>