Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bases de donnees --- Intelligence economique --- OLAP, Technologie

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

MDX (Computer program language) --- Client/server computing --- OLAP technology --- MDX (Langage de programmation) --- Architecture client-serveur (informatique) --- OLAP, Technologie --- SQL server

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL's declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught. This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the

SQL (Computer program language) --- OLAP technology --- SQL (Langage de programmation) --- OLAP, Technologie --- Information Technology --- General and Others --- OLAP technology. --- Structured Query Language (Computer program language) --- Declarative programming languages --- Query languages (Computer science) --- Online Analytical Processing technology --- Data mining --- Decision support systems --- Online data processing --- Multidimensional databases --- Almacenes de datos (40154310) --- Bibliografía recomendada

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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

MDX (Computer program language) --- OLAP technology --- MDX (Langage de programmation) --- OLAP, Technologie --- MDX (Computer program language). --- Computer Science --- Engineering & Applied Sciences --- OLAP technology. --- EPUB-LIV-FT LIVINFOR SPRINGER-B --- Online Analytical Processing technology --- Multi Dimensional eXpressions (Computer program language) --- Computer science. --- Programming languages (Electronic computers). --- Database management. --- Computer Science. --- Programming Languages, Compilers, Interpreters. --- Database Management. --- Data mining --- Decision support systems --- Online data processing --- Multidimensional databases --- Query languages (Computer science) --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Informatics --- Science --- Computer languages --- Computer program languages --- Computer programming languages --- Machine language --- Languages, Artificial