O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Speeding up navigation lists by disabling Business Analyzer

Reporting services' reports can be of great benefit to users of Dynamics GP by presenting relevant information to them on the Home page and also in the navigation lists. However, loading Business Analyzer in the navigation pane FactBox can cause the lists to load slowly so some customers may want to disable the FactBox.

Unfortunately, Dynamics GP only allows the FactBox to be hidden manually by individual users and needs to be hidden on each of the navigation lists separately. Fortunately, Dynamics GP databases are stored in SQL Server and can be updated with a simple SQL Trigger that runs each time a user opens a navigation list for the first time; this recipe will show you how to add ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required