Microsoft SQL Server Olap Developer's Guide - Softcover

Amo, William C.

Softcover

ISBN 10: 0764546430 ISBN 13: 9780764546433

Verlag: Hungry Minds Inc,U.S., 2000

Inhaltsangabe

Microsoft?? SQL Server?(TM) 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

Über diesen Titel

Über die Autorin bzw. den Autor

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?? 7 Secrets?? and Transact-SQL: Programming Microsoft?? SQL Server?(TM) 7.

Von der hinteren Coverseite

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

Details zur Ausgabe

• Verlag: Hungry Minds Inc,U.S.
• Erscheinungsdatum: 2000
• Sprache: Englisch
• ISBN 10: 0764546430
• ISBN 13: 9780764546433
• Einband: Taschenbuch
• Anzahl der Seiten: 357
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar