We are heading into the final chapters of this book, with only two reporting tools left in our toolset and we have saved the best ones for last. Until now, we have covered reporting tools that allow us to extract data sets from Dynamics GP or write reports by accessing the Dynamics GP data directly. In all of these tools, any type of summation or grouping that needed to be done, we had to create ourselves and know what tables to join together and where to find this data. In the previous chapter, we learned that Analysis Cubes for Excel is an out of the box data warehouse that does all of this summation and grouping for us.
Now that we have learned the backbone of the Analysis Cubes for Excel product, we will explore how to connect to this data and create reports with every accountant's favorite tool, Microsoft Excel.
In this chapter, we'll discuss the following topics:
Creating a connection to individual cubes via Microsoft...