O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required