Introduction
Sets are collections of tuples with the same dimensionality. Logical operations, NOT, OR and AND, are performed on sets in MDX. When putting the two tuples together to form a set, we ask for the results that contain a tuple. Therefore, the sets in MDX naturally implies logic OR.
The first part of the chapter focuses on the challenges and solutions of performing logic operations NOT, OR and AND, on sets.
Iterations and recursions can also be performed on sets. The second half of the chapter concentrates on iterations and recursions, and the different ways to perform them. Finally, we will cover how to apply the iteration technique to dissect and debug MDX queries and calculations.
