dbTalk Databases Forums  

MDX - Crossjoin with Empty sets

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MDX - Crossjoin with Empty sets in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom George
 
Posts: n/a

Default 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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.