Converting a Set Expression into a Table

The set is fundamental in MDX. Each axis is composed of a set of tuples. The slicer condition (WHERE clause) is a set (usually with just one tuple). This section does not describe how to map every set value expression. For illustration purposes, it does present a limited number of topics to convey the concepts, which will help with mappings optimized for your SQL implementations.

For introductory information about the process, see the following topics:

• Tables and Sets

• Literal Sets

The topics in this section provide information about converting a set expression into a table:

• UNION Function

• EXCEPT Function

• INTERSECT Function

• CROSSJOIN Function

• HIERARCHIZE Function

• Simple Extensions to SQL-92