Building pivot tables using cube formulas
Excel 2007 is great for using pivot tables. I especially like the new cube functions since they give far greater flexibility. They also allow reporting from multiple cubes if needed where standard pivot table functionality only allows to report off a single cube. To create a blank report using just cube functions we need to firstly define our connection. Open up Excel and go to Data, from other sources, and select analysis services. Now select the required options and a cube or perspective, i used AdventureWorks for this example. Name the connection "adv" and select "only create a connection" in the last step.
Tags: excel