InterSystems IRIS Data Platform 2019.2  /  InterSystems MDX Reference  /  Expression Types

InterSystems MDX Reference
Tuple Expressions
Previous section           Next section
InterSystems: The power behind what matters   

This section describes how to create and use tuple expressions in InterSystems MDX.
In InterSystems MDX, a tuple expression can have either of the following forms:
Notes and Additional Terminology
In other implementations of MDX, a tuple cannot include more than one member from the same dimension. In InterSystems MDX, a tuple expression can include more than one member expression from the same dimension. In most cases, the result is null. However, in Business Intelligence, a level can be based on a list value, which means that a given record can belong to multiple members. For example, the tuple (,allerd.wheat) represents all patients who are allergic to both soy and wheat, and this tuple could potentially have a non-null value.
If the tuple refers to each dimension in the cube, the tuple is fully qualified. Otherwise, it is partially qualified. The following shows an example of a partially qualified tuple from the Patients cube:
(allerd.[dairy products],, aged.35)
Another partially qualified tuple is as follows:
(diagd.asthma, aged.[age group].[30 to 59], MEASURES.[%COUNT])
Also, note that each data cell returned by a query is a tuple.
The CROSSJOIN function returns a set of tuples, as does the NONEMPTYCROSSJOIN function.
You can use tuple expressions in the following ways:

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-09-20 05:36:42