Summary
This chapter has covered extensive ground. You’ve learned how to use PivotTables, charts, and cell formulas from Excel 2007 and Excel Services to build compelling dashboards for your OLAP cubes. Also, by learning a small subset of the MDX query language, you learned how to use the MDX Query window in SQL Server Management Studio to query your cubes more precisely than you can with Excel.
You’ve seen how to apply your MDX knowledge programmatically by using ADO MD.NET and how to get detailed metadata and perform numerous DDL tasks with AMO. You learned how both libraries provide façades around XMLA, and you learned how to use XMLA directly, from the XMLA Query window in Management Studio and in code via Microsoft.AnalysisServices.Xmla, as ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
