Chapter 7. Utilizing Analysis Cubes for Excel for Dynamic Reporting
We are in the home stretch 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 last 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 connecting to this data and creating reports with every accountant's favorite tool, Microsoft Excel.
In this chapter, we'll discuss some of the following topics:
Creating a connection to individual cubes via Microsoft Excel
Exploring the Excel...