Microsoft SQL Server Olap Developer's Guide - Couverture souple

Amo, William C.

 
9780764546433: Microsoft SQL Server Olap Developer's Guide

Synopsis

Microsoft(R) SQL Server OLAP Developer's Guide Your Complete How-To GuideUnderstand the ROLAP, MOLAP, and HOLAP data storage structuresPopulate a data warehouse using SQL Server 7 Data Transformation ServicesCreate data cubes with OLAP Manager WizardsUse Decision Support Objects to build powerful OLAP applications for the enterpriseRetrieve and display OLAP data using ADO MD objects and PivotTable ServicesUse MDX to write "what-if" and other sophisticated OLAP queriesDevelop custom add-ins for OLAP Manager using Visual BasicBuild client-side applications to query OLAP data using Excel PivotTablesConstruct a custom application that drills up and down through cell setsSet up data descriptions in the English Query environmentCD-ROM Includes:Microsoft SQL Server 7.0 120-day evaluation editionReady-to-use source code and all examples from the bookAntQuery (trial)OLAP@Work for Microsoft Excel (trial)CD-ROM Included The Latest Tools and Best Techniques for Fast Results The OLAP (Online Analytical Processing) tools now available with SQL Server 7 give you the power to build data warehouses and perform sophisticated, multidimensional data analysis. In this detailed and very thorough guide, SQL Server expert Bill Amo explains the Microsoft OLAP implementation and shows you step-by-step how to warehouse data, set up OLAP data cubes, work with Decision Support Objects, construct PivotTable applications, and much more. Featuring clear directions and six well-developed examples that you can access on the CD-ROM, this book is all you need to create state-of-the-art data analysis solutions. www idgbooks.com

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

À propos de l?auteur

About the Author Bill Amo is a SQL Server expert and database consultant with more than 20 years of experience. His books include SQL Server(R) 7 Secrets(R) and Transact-SQL: Programming Microsoft(R) SQL Server 7.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.