Fast Track to MDX

Mark Whitehorn, Robert Zare, Mosha Pasumansky

288 pages, parution le 30/12/2002

Ajouter à une liste

Indisponible

Résumé

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 to 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.

Contents

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

Appendixes
Sample Files
ProClarity

Caractéristiques techniques

	PAPIER
Éditeur(s)	Springer
Auteur(s)	Mark Whitehorn, Robert Zare, Mosha Pasumansky
Parution	30/12/2002
Nb. de pages	288
Format	17 x 23,5
Couverture	Broché
Poids	549g
Intérieur	Noir et Blanc
EAN13	9781852336813
ISBN13	978-1-85233-681-3