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: