Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Reporting Practices
Description:Every time I hang out with Steve Gray I get a little smarter. (It's probably the opposite for Steve. Sorry about that.) He made good point on Saturday and I'm going to try to summarize it. GP's tables are a pretty good balance of optimization, not tremendously favoring transaction performance or reporting. This works pretty well in the middle space that GP occupies. (If you ever want to buy me a drink and argue the pros and cons of how far to take database normalization, my drink of choice is Diet Coke and Crown Royal.)

As a contrast, I have another app at work that is highly normalized for transaction performance. Don't even think about writing a SQL based report without joining 8 tables. It won't happen. Oh, and all the unique identifiers are GUID's. Great for transactions, yucky poo poo for reporting.

Even so, we all want better performance and easier report building. Steve's new mantra is to create a table with everything he needs to report off an area in GP. So for sales, he can prebuild a table with all the data from the sales tables. Then, every time he needs a sales report he doesn't have to join the pieces and figure out the joins from scratch. The initial work is a pain, but after that reporting gets easy.

This is essentially the same principal that most data warehouses run on. Despite all the benefits of a relational database, for reporting, flat files are faster. That's why GP's temp tables in report writer are still Pervasive flat files, not SQL tables.

Another benefit is that it makes reporting a lot easier if you don't have to figure out what tables you need. Just grab the Sales Reporting Table for instance and start plugging in fields. Yes this can cause some headaches around updating the reporting table, especially if need real time (versus near real time) data but you might still be able to get good performance and instant updates with a Stored Procdure instead of a table. It just depends on how much data you're using.

If I do anything around this to make my life easier, I'll put the SQL code up on the website for your use as well. Thanks again for the idea Steve.
Link Owner:
Date Added:June 21, 2010 06:11:20 PM
Number Hits:2
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.