Name: Microsoft SQL Server OLAP Developer's Guide
Brand: John Wiley & Sons Inc
SKU: 5320091
Availability: OutOfStock

Microsoft SQL Server OLAP Developer's Guide

By Bill Amo, William C. Amo

Rating

Format

Paperback, 384 pages

Published

United States, 25 April 2000

Microsoft® SQL Server™ OLAP Developer' s Guide Your Complete How-To Guide

Understand the ROLAP, MOLAP, and HOLAP data storage structures
Populate a data warehouse using SQL Server 7 Data Transformation Services
Create data cubes with OLAP Manager Wizards
Use Decision Support Objects to build powerful OLAP applications for the enterprise
Retrieve and display OLAP data using ADO MD objects and PivotTable Services
Use MDX to write " what-if" and other sophisticated OLAP queries
Develop custom add-ins for OLAP Manager using Visual Basic
Build client-side applications to query OLAP data using Excel PivotTables
Construct a custom application that drills up and down through cell sets
Set up data descriptions in the English Query environment

CD-ROM Includes:

Microsoft SQL Server 7.0 120-day evaluation edition
Ready-to-use source code and all examples from the book
AntQuery (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

This item is no longer available.

Product Description

Microsoft® SQL Server™ OLAP Developer' s Guide Your Complete How-To Guide

Understand the ROLAP, MOLAP, and HOLAP data storage structures
Populate a data warehouse using SQL Server 7 Data Transformation Services
Create data cubes with OLAP Manager Wizards
Use Decision Support Objects to build powerful OLAP applications for the enterprise
Retrieve and display OLAP data using ADO MD objects and PivotTable Services
Use MDX to write " what-if" and other sophisticated OLAP queries
Develop custom add-ins for OLAP Manager using Visual Basic
Build client-side applications to query OLAP data using Excel PivotTables
Construct a custom application that drills up and down through cell sets
Set up data descriptions in the English Query environment

CD-ROM Includes:

Microsoft SQL Server 7.0 120-day evaluation edition
Ready-to-use source code and all examples from the book
AntQuery (trial)
OLAP@Work for Microsoft Excel (trial)

EAN

9780764546433

ISBN

0764546430

Writer

Bill Amo, William C. Amo

Publisher

John Wiley & Sons Inc

Age Range

Other Information

Illustrated

Dimensions

23.4 x 18.8 x 2.6 centimeters (0.65 kg)

Preface. Acknowledgments. PART I: Overview of the Microsoft OLAP Environment. Chapter 1: Introduction to Microsoft OLAP Services. Chapter 2: Building the Sample Data Warehouse. Chapter 3: A Tour of the OLAP Manager. Chapter 4: Maintaining OLAP Data. Chapter 5: Introduction to Decision Support Objects. Chapter 6: Getting Acquainted with the PivotTable Service. PART II: Examining the Microsoft OLAP Services Components. Chapter 7: Introduction to Multidimensional Expressions. Chapter 8: Building Applications with Decision Support Objects. Chapter 9: Using OLAP Manager Add-Ins. Chapter 10: More MDX. Chapter 11: Exploring Microsoft Excel 2000 and OLAP. PART III: Exercises in OLAP Services Programming. Chapter 12: A Server Application Using Decision Support Objects. Chapter 13: Client Applications Using the PivotTable Service. Chapter 14: Creating an OLAP Manager Add-In. Chapter 15: Exploring Data Transformation Services. Appendix A: What's on the CD. Appendix B: Sample Database Schemas. Appendix C: Decision Support Objects Reference. Appendix D: The MDX Statement and Format String Specifiers. Appendix E: The ADO MD Object Model. Appendix F: OLAP Services Specifications. Appendix G: OLAP Services Function Reference. Index. End-User License Agreement. CD-ROM Installation Instructions.

About the Author

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.

Table of Contents

About the Author