* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases * The authors then describe the development processes for building dimensions and cubes from various data sources * Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems * Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions
* Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses * After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional…
Sivakumar Harinath, Matt Caroll, Sethu Meenakshisundaram, Robert Zare, Danny Guang-Yeu Lee, Wiley Publishing, 2009
- When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis. - Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other compon…
Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008 Analysis Ser…
Marco Russo, Alberto Ferrari, and Chris Webb, Packt Publishing, 2009
Design and implement fast, scalable and maintainable cubes * A real-world guide to designing cubes with Analysis Services 2008 * Model dimensions and measure groups in BI Development Studio * Implement security, drill-through, and MDX calculations * Learn how to deploy, monitor, and performance-tune your cube * Filled with best practices and usefu…
Hancock J.C., Toren R., Addison-Wesley Professional, 2006
In this book, two of Microsoft's leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C. Hancock and Roger Toren offer unprecedented i…