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