Database Reference
In-Depth Information
This query uses
NONEMPTYCROSSJOIN
to work on three sets: promotions,
resellers, and products. Note that this function does not require nesting when
working with more than two sets. Furthermore, the function accepts the re-
seller sales amount measure to determine which tuples will be empty and
therefore discarded from the result set. The last parameter (in this case
3
) advises
NONEMPTYCROSSJOIN
how many sets are needed to be cross
joined on the axis.
Search WWH ::
Custom Search