MDX - Crossjoin with Empty sets -
01-08-2004
, 06:59 PM
If one of the sets in a crossjoin result to be empty, is
there a way to ignore this set and cross join the others?
For example:
The follow MDX produces results
SELECT {Hierarchize({CROSSJOIN({{[Customers].[All
Customers]}},{{[Product].[All Products].[Drink]}})})} on
0 from [Sales]
when the following MDX is excuted no results are returned
(as expected)
SELECT {Hierarchize({CROSSJOIN({{EXCEPT({{[Customers].
[All Customers]}},{{Descendants([Customers].[All
Customers])}})}},{{[Product].[All Products].
[Drink]}})})} on 0 from [Sales]
No result is returned as expected.
Question:
Is there a way to ignore the "emptyness" of the first
set and still display the results from the second set?
thanks |