It's Raining Books Sale
 
 

Recently Viewed clear list


Original Essays | September 15, 2014

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »
  1. $18.19 Sale Hardcover add to wish list

    Juliet's Nurse

    Lois Leveen 9781476757445

spacer
Qualifying orders ship free.
$77.50
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Database- Data Warehousing

More copies of this ISBN

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase

by

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Cover

 

Synopses & Reviews

Publisher Comments:

An updated version of the leading tutorial and reference on the MDX query language

Now in its second edition, this invaluable reference explains why MDX (MulitDimensional eXpressions) is the most widely accepted software used for dimensional application. You'll learn how to build effective multidimensional data warehouses and you'll gain the necessary skills to access and analyze data to make better business decisions.

After a brief overview of the syntax and semantics of the MDX language, the authors move directly to the tutorial, providing practical examples of MDX in use. With more than 60 percent revised and updated content, this new edition addresses the increased number of analytical applications that use MDX. The authors cover both the 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.

This unrivaled book includes:

  • The range of possibilities specific to Microsoft and Hyperion
  • Techniques and tricks of combining the different functions of MDX to solve a variety of problems
  • Capabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior version
  • The standard syntax of MDX that handles the constructs and capabilities of numerous servers
  • Detailed reference appendices for MDX operators, functions, and related connection settings

The companion Web site includes a collection of sample databases and code for use in Analysis Services and Essbase, and an MDX query interface for Essbase.

Book News Annotation:

MDX (for MultiDimensional eXpressions) is, according to the authors (of Hyperion Solutions, Microsoft, IMS Health, and DaisyLabs), the most widely accepted software language for dimensional applications typified by the related notions of OLAP (online analytical processing) and dimensional data warehouses and marts. They present a guide to learning and using the language that, in addition to covering basics of syntax and capabilities, focuses on its use for Microsoft SGL Server 2005 Analysis Services 2005 (along with the older 2000 version) and Hyperion System 9 BI+ Analytic Services, based on Essbase functionality. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

  • 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 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
  • 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

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Synopsis:

MDX Solutions is both a tutorial and a reference guide to the MDX query language. It shows data warehouse developers what they need to know to build effective multidimensional data warehouses. And it teaches users what they need to know to access and analyze data to make better business decisions. The Second Edition provides 200 additional pages of new material covering both 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.

About the Author

George Spofford is a Distinguished Engineer at Hyperion Solutions, Inc. and the author of the first edition of MDX Solutions (Wiley).

Sivakumar Harinath is the Test Lead for Analysis Services 2005 at Microsoft.

Christopher Webb is a technical architect who specializes in BI solutions at IMS Health in London.

Dylan Hai Huang is currently working as a program manager in Microsoft Office Business Application Team. Before joining the current team, he had been working in Microsoft Analysis Service Performance Team. His main interests are business intelligence, high performance computation and data mining.

Francesco Civardi is Chief Scientist at DaisyLabs, a Business Intelligence Company. He is also Professor of Data Analysis Tools and Techniques at the Catholic Universities of Brescia and Cremona.

Table of Contents

Acknowledgments.

Introduction.

Chapter 1:A A First Introduction to MDX.

Chapter 2: Introduction to MDX Calculated Members and Named Sets.

Chapter 3: Common Calculations and Selections in MDX.

Chapter 4: MDX Query Context and Execution.

Chapter 5: Named Sets and Set Aliases.

Chapter 6: Sorting and Ranking in MDX.

Chapter 7: Advanced MDX Application Topics.

Chapter 8: Using the Attribute Data Model of Microsoft Analysis Services.

Chapter 9: Using Attribute Dimensions and Member Properties in Hyperion Essbase.

Chapter 10: Extending MDX through External Functions.

Chapter 11: Changing the Cube and Dimension Environment through MDX.

Chapter 12: The Many Ways to Calculate in Microsoft Analysis Services.

Chapter 13: MDX Scripting in Analysis Services 2005.

Chapter 14: Enriching the Client Interaction.

Chapter 15: Client Programming Basics.

Chapter 16: Optimizing MDX.

Chapter 17: Working with Local Cubes.

Appendix A: MDX Function and Operator Reference.

Appendix B: Connection Parameters That Affect MDX.

Appendix C: Intrinsic Cell and Member Properties.

Appendix D: Format String Codes.

Index.

Product Details

ISBN:
9780471748083
Author:
Spofford, George
Publisher:
John Wiley & Sons
Author:
Harinath, Sivakumar
Author:
Civardi, Francesco
Author:
Webb, Christopher
Author:
Huang, Dylan Hai
Subject:
Information Storage & Retrieval
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
OLAP technology
Subject:
Database Management - Data Warehousing
Subject:
Database Management - General
Subject:
Database-SQL
Subject:
Database & Data Warehousing Technologies
Subject:
Database-Data Warehousing
Copyright:
Edition Number:
2
Edition Description:
WebSite Associated w/Book
Publication Date:
December 2005
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
744
Dimensions:
9.24x7.22x1.65 in. 2.36 lbs.

Related Subjects

Computers and Internet » Database » Database Management
Computers and Internet » Database » Design
Computers and Internet » Database » General
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase New Trade Paper
0 stars - 0 reviews
$77.50 In Stock
Product details 744 pages John Wiley & Sons - English 9780471748083 Reviews:
"Synopsis" by ,
  • 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 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
  • 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

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

"Synopsis" by , MDX Solutions is both a tutorial and a reference guide to the MDX query language. It shows data warehouse developers what they need to know to build effective multidimensional data warehouses. And it teaches users what they need to know to access and analyze data to make better business decisions. The Second Edition provides 200 additional pages of new material covering both 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.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.