Welcome to Office Zealot Sign in | Join | Help

Browse by Tags

All Tags » Analysis Services   (RSS)
Excel Services BI Goodness
I’ve always had a soft-spot for budgeting/forecasting applications. Show me a nice tight revenue/expense cube, a decent Excel-based client, and interactive browser-based reporting capabilities and I’ll show you a company with an efficient Read More...
Excel 2002/2003 Add-in for SQL Server Analysis Services
Check out Marco Russo , Teo Lachev , and Chris Webb’s posts regarding the newly available Excel Add-in 1.5 for Analysis Services which has been updated to support AS2005. Ted, in particular, had some thoughts that triggered further thoughts in me. Read More...
Part II: Analysis Services Reporting in Excel
In Part I , I discussed how to set the worksheet up, now it’s time to look at some code. Building a report consists of three logical operations: determining the correct MDX that will yield the desired results, fetching the data, and displaying the Read More...
Part I: Analysis Services Reporting in Excel
The main objectives in this post are to show some screenshots that demonstrate what you can expect when you complete the exercise and to do all of the preliminary setup on the workbook. The goal of this example is to show how you can create reports in Read More...
Introduction: Analysis Services Reporting in Excel
For me, the Holy Grail that has been missing from Microsoft’s BI platform is an Excel Add-In that provides the type of functionality that you can find in Hyperion’s Essbase Add-in for Excel (which only works with Hyperion’s much more Read More...
More Posts Next page »