This section describes how to create and use tuple expressions in DeepSee MDX.
In DeepSee 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 DeepSee MDX, a tuple expression can
include more than one member expression from the same dimension. In most cases, the result is null. However, in DeepSee, 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.soy,allerd.wheat)
represents all patients who are allergic to both soy and wheat, and this tuple could potentially have a non-null value.
(allerd.[dairy products], colord.red, 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.
You can use tuple expressions in the following ways:
As the argument to the WHERE