|
|
 |
MDX Essentials: Basic Set Functions: The Filter() Function
|
| Total Hit (1108) |
This is the sixteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs
....Read More |
Rating
 |
|
|
|
|
|
MDX Essentials: Basic Set Functions: The EXCEPT() Function
|
| Total Hit (796) |
This is the fifteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
|
|
MDX Essentials: Basic Set Functions: The Intersect() Function
|
| Total Hit (804) |
This is the fourteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Union() Function
|
| Total Hit (771) |
This is the thirteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
|
|
MDX in Analysis Services: Calculated Members: Introduction
|
| Total Hit (811) |
This is the seventh tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimension
....Read More |
| Rating
|
|
|
|
|
|
Using Sets in MDX Queries
|
| Total Hit (1486) |
This is the sixth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimensional
....Read More |
| Rating
|
|
|
|
|
|
MDX in Analysis Services: Measuring Change over Time
|
| Total Hit (810) |
This is the fifth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimensional
....Read More |
| Rating
|
|
|
|
|
|
MDX in Analysis Services: Retrieve Data from Multiple Cubes
|
| Total Hit (906) |
This is the fourth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services," to save time
....Read More |
| Rating
|
|
|
|
MDX Essentials: MDX Member Functions: "Relative" Member Functions
|
| Total Hit (745) |
This is the eighth article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features design
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 2
|
| Total Hit (948) |
This is the third tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services," to save time
....Read More |
| Rating
|
|
|
|
MDX Member Functions: The Cousin () Function
|
| Total Hit (717) |
This is the seventh article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features desig
....Read More |
| Rating
|
|
|
|
MDX Essentials: Member Functions: More "Family" Functions
|
| Total Hit (709) |
This is the sixth article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designe
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 1
|
| Total Hit (933) |
This is the second tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services" to save time
....Read More |
| Rating
|
|
|
|
MDX Member Functions: The "Family" Functions
|
| Total Hit (887) |
This is the fifth article of the series, MDX Essentials. The primary focus of this series is an introduction to the MDX language. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding fea
....Read More |
| Rating
|
|
|
|
MDX at First Glance: Introduction to SQL Server MDX Essentials
|
| Total Hit (1426) |
To get the most out of the MDX Essentials series, we need to have installed at least the Analysis Services component of MSSQL Server 2000. While the full installation of SQL Server 2000 allows for virtually any exercise we might undertake, the majority of our sessions center on Analysis Services, th
....Read More |
| Rating
|
|
|
|
MDX Essentials: Structure of the MDX Data Model
|
| Total Hit (688) |
This is the second article of the series, MDX Essentials. The primary focus of this series will be an introduction to the MDX language. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively addi
....Read More |
| Rating
|
|
|
|
Introducing the SQL Server 'MDX in Analysis Services' Series
|
| Total Hit (659) |
This is the first tutorial of a new series, MDX in Analysis Services, that I hope will help new users get up to speed quickly with multidimensional expressions (MDX). The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis
....Read More |
| Rating
|
|
|
|
MDX Sets
|
| Total Hit (1452) |
In this chapter, you’ll learn MDX query terminology and how to
«LI»Use the MDX Sample application to enter queries.
«LI»Use set functions.
«LI»Create sets by using member constants.
«LI»Create calculated members that aggregate sets of values.
....Read More |
| Rating
|
|
|
|
Business Case Solutions Using MDX
|
| Total Hit (953) |
The purpose of the Multidimensional Expressions (MDX) language is to make access to multidimensional data more concise and efficient. However, because MDX reflects the natural complexity of multidimensional data structures, simple business questions may sometimes require complex MDX solutions.
....Read More |
| Rating
|
|