I have a simple MDX query as follows:

select
{[Sales]} on columns,
non empty [Stores].[Stores].[Alberta].children on rows
from [Cube]
where ([Time].[Calendar].[Day].&[2006-02-02T00:00:00])

and it returns the stores with sales on that day.

Now when I replace the "non empty" by "nonempty()" as follows:


select
{[Sales]} on columns,
nonempty ([Stores].[Stores].[Alberta].children) on rows
from [Cube]
where ([Time].[Calendar].[Day].&[2006-02-02T00:00:00])

I get 0 rows returned.

why is that ?

Forgot to mention: SSAS 2005 SP1.

"Pat" wrote:

The two are not equivalent. The nonempty function is executed independent of
the tuples on the other axes (in this case [Sales] and
[Time].[Calendar].[Day].&[2006-02-02T00:00:00]) but the NON EMPTY clause
takes them into consideration.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Pat" <pat (AT) online (DOT) nospam> wrote