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

The Analysis Services OLAP feature set is impressive. Numerous dimension types, powerful calculations, KPIs, perspectives, translations, and proactive caching make it far easier to build cubes and make those cubes more powerful and more relevant to business users than was possible before Analysis Services 2005. Under Analysis Services 2008, these features are made more accessible and manageable through such designer innovations as BPAs, the Attribute Relationships tab in the dimension designer, and the Aggregations tab in the cube designer.

You now know how to build sophisticated cubes. In the next chapter, we’ll show you how to develop applications that query cubes by using Microsoft Office Excel 2007 and Excel Services, ADO MD.NET, XML ...

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