Описание: * Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDXn 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 databases and data warehousing, the authors move directly to providing practical examples of MDX in use. New material in it covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of "Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase". It also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions.
Описание: The MDX query language was developed by Microsoft to access multidimensional data warehouses used by companies to store vast amounts of customer information. This pack is a tutorial and a reference guide on MDX and provides examples of MDX in use, explains standard usage and more advanced techniques, such as optimization, cube design, and more.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
