stevienova.com

Most people, when using OLAP cubes, are hitting the live version that is located on SQL Server Analysis Services (SSAS). They hit it with Excel, or some other reporting tool, etc. I have blogged previously about offline cubes and how you could possibly use them. Now, the blog I did before, I talked about creating [...]

One feature of Excel 2007 that I think is really cool, and also a little hidden, is the “Offline OLAP” feature. If you insert a pivot table connected to an OLAP cube into Excel 2007, and go to the PivotTable Options Ribbon Menu, You will see the “OLAP Tools” Button. Click on that and then [...]