There was a handy feature released in CU11 called the entity store which might be helpful if you are looking at business intelligence scenarios with AX. You can read more in the PDF you can find here.
Click to access Entity%20store%20Microsoft%20Dynamics%20AX%202012%20R3.pdf
Cheers
Lachlan
OrganicAX 
Pingback: Setting up an entity store in AX2012 R3 CU11 | OrganicAX·
Pingback: Setting up an entity store in AX2012 R3 CU11 - Microsoft Dynamics AX Community·
Pingback: Setting up an entity store in AX2012 R3 CU11 - OrganicAX - Microsoft Dynamics AX - Dynamics AX Users - DUG·