Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Fast Track to MDX
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Fast Track to MDX

Fast Track to MDX

Mark Whitehorn, Mark Zare

336 pages, parution le 26/01/2006 (2eme édition)

Résumé

Fast Track to MDX (for SQL Server 2000) Second Edition Mark Whitehorn, Robert Zare and Mosha Pasumansky

OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions).

Fast Track to MDX gives you all the necessary background to let you write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems.

Mark Whitehorn, co-author of the best-selling Inside Relational Databases, is renowned for his knowledge of database systems and the lucidity of his writing. Robert Zare is a Program Manager for Analysis Services at Microsoft: his inspiring talks on MDX sowed the seeds from which this book grew. Mosha Pasumansky was one of the authors of the OLEDB for OLAP specification that defined the MDX language and later he was the developer in charge of the first implementation of MDX in the Microsoft OLAP Services 7.0 product. He is currently the development lead of the Analysis Services engine team.

Second Edition - It was the clarity, precision and sheer readability of the first edition that made it a best-seller. With that firmly in mind the authors have left the original 18 chapters intact (apart from minor updates); meaning that the second edition remains the best introduction to MDX for SQL Server 2000 that is available. What they have done is to add three brand new chapters. These introduce the topic of recursion in MDX, walk the reader through the process of creating recursive expressions and finally demonstrate how recursion can be used to effectively solve a series of business problems.

Forward by Amir Netz, Product Unit Manager, SQL Server - Analysis Services at Microsoft.

A CD containing examples from within the book, and a time-limited version of ProClarity, is included.

Sommaire

  • Introduction
  • Readme.doc - Definitions You Need to Know
  • How MDX is Used
  • MDX Queries
  • MDX Syntax
  • MDX Expressions
  • Navigating the Hierarchy
  • Snapshot Data Analysis
  • Moving Averages
  • Filters
  • Setting the Default Member
  • Member Properties and Dimension Security
  • Distinct Count
  • Parent-Child Dimensions
  • Advanced Data Modeling - Custom Order, Custom Rollup, Custom Members
  • Further Advanced Data Modeling Techniques
  • Actions
  • Server Side Color Coding
  • More About Querying
  • More MDX in general
  • Recursion in MDX
  • Query Performance (recursion vs. iterative) and NonEmptyCrossJoin
  • Appendix 1: Sample Files
  • Appendix 2: ProClarity
Voir tout
Replier

Caractéristiques techniques

  PAPIER
Éditeur(s) Springer
Auteur(s) Mark Whitehorn, Mark Zare
Parution 26/01/2006
Édition  2eme édition
Nb. de pages 336
Format 17,5 x 23,5
Couverture Broché
Poids 660g
Intérieur Noir et Blanc
EAN13 9781846281747
ISBN13 978-1-84628-174-7

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription