Management Reporter 2012 SQL Queries

I am currently using MR 2012 for my reports for GP 2018, but I was wondering if anyone knows how they are produced and what SQL Queries are used to create the generate the standard Financial Reports, as I was looking at trying to reproduce these in PowerBi and a mini project for myself

Parents
No Data
Reply
  • IIRC, there's a bunch of stored procs inside the MR database that are used to run the extracts.

    The other thing you can do is run a SQL profiler trace on a non-production environment when the extract is running.  That should show the way it's extracting and aggregating the results.

Children
No Data
Related
Recommended