Earlier in this chapter, we discussed the deployment of predefined charts and KPIs that can then be made visible on the GP 2013 Homepage in Business Analyzer. In this section, we'll take a look at creating a metric that shows us the top ten items on unposted sales orders by extended price. A metric of this sort can give members of our organization insight into which items are generating the most sales at the moment. As the data source for this metric, we'll use one of the SQL views that is generated in each GP company database by the predefined Excel Reports deployment that was covered in Chapter 3, Working with the Builders – SmartList and Excel Reports, of this book: dbo.SalesLineItems
. Remember, SSRS metrics are only available for GP 2010 and later, and SQL Server 2008 and later environments!
In the previous example, we used Visual Studio to modify a default report. In this example, however, we are going to use Report Builder to create...