Category: Dimensions

Dimension Analysis for MDA – SQL View for Dynamics GP

Earlier I wrote about how to use MDA for dimension analysis rather than Analytical Accounting.  You can find that blog here.

To continue that thought, I have created a SQL view to help users get that dimensional analysis data easily!  The script captures commonly used data – if you feel I am missing something, please let me know and I will try to add it to the view for others.  I also like to push this data to Excel and Power BI – take a look at the Excel Report and Power BI reports I created at the bottom of this post!

The script below should be run against your company database – you can then use it to build a smartlist.  Instructions for adding the view to a smartlist using Smartlist Designer are included with GP LifeHacks #137.

Here is the view:

Continue reading “Dimension Analysis for MDA – SQL View for Dynamics GP”