A hands-on tutorial on building and using multidimensional data warehouses
The SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques, such as optimization, cube design, and Pareto analysis. Finally, the appendices provide a handy reference guide that users can rely on.
"Sinopsis" puede pertenecer a otra edición de este libro.
A thorough tutorial and detailed reference to the analytical language of data warehousing
Understanding MDX is crucial for anyone designing or implementing a database in Microsoft's products. This informative book serves as both a tutorial and a reference guide by teaching you how to use MDX to access and analyze data for decision support. The standard language and Microsoft's own extensive additions to MDX are thoroughly explained. After the overview of the MDX language is presented, the author plunges into the tutorial, offering practical examples of MDX in use. He shows various techniques using MDX to access data and calculate results, and covers the more advanced techniques of aggregation, query templates, and MDX optimization.
This unrivaled book includes:
* Explanations of each MDX feature
* Simple and sophisticated applications
* Details of building and executing MDX queries
* Introduction to Visual Basic programming techniques using MDX
* Instructions for building and using client-side local cubes
* Detailed reference appendices for MDX operators, functions, and related connection settings
The accompanying CD-ROM includes:
* Samples of MDX expressions, queries, and local cubes
* MDXBuilder trial software
* Visual Basic sample code
Wiley Computer Publishing
Timely. Practical. Reliable.
Visit our Web site at www.wiley.com/compbooks/
GEORGE SPOFFORD (email@example.com) is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of OLAP-based DSS systems and related tools. He coauthored Microsoft OLAP Solutions (also from Wiley) and has extensive experience applying Microsoft's analysis tools. Working on OLAP technologies since 1988, he has also developed OLAP clients and servers, including Power Thinking Tools' FreeThink. He earned a Microsoft MVP award for his contributions to the OLAP user community.
"Sobre este título" puede pertenecer a otra edición de este libro.
Descripción Wiley, 2001. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0471400467
Descripción Wiley, 2001. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0471400467
Descripción Wiley. Estado de conservación: Brand New. Ships from USA. FREE domestic shipping. Nº de ref. de la librería 0471400467
Descripción Wiley, 2001. Paperback. Estado de conservación: New. Nº de ref. de la librería P110471400467
Descripción Wiley. PAPERBACK. Estado de conservación: New. 0471400467 New Condition. Nº de ref. de la librería NEW6.0248252
Descripción John Wiley & Sons Inc, 2001. Paperback. Estado de conservación: Brand New. bk&cd-rom edition. 448 pages. 9.10x7.30x1.10 inches. In Stock. Nº de ref. de la librería __0471400467