One of the extraordinary benefits of Analysis Cubes for Excel is its endless possibilities for customization. The Analysis Cubes product gives us a solid base from which we can then extend to include other customizations. Customizations to the cube environment run the gamut from adding new attributes and measures to an existing cube, adding a new cube for another GP module to the existing SSAS database, to even incorporating data from a completely separate application in the same data warehouse as our GP data.

Although some customizations such as incorporating data from applications outside of GP require fairly extensive knowledge of the various SQL Server components involved, we have identified a few simple customizations that we can make to customize our environment. In this section, we'll explore the following customizations: