Hello

I have an MDX statement that looks like this:

SELECT
{ Measures.members } on Columns ,
{ CrossJoin( [Time].[Calendar].[2004].[May]:[Time].
[Calendar].[2004].[July],
[Business].[User].[Business Entity Id].[212].Children ) }
on Rows
FROM UsageStats


And it returns this via a matrix report:

2004
Alan Smith | 2 | 3 | 2 | 7 |
Amy Marcus | | 3 | 3 | 6 |
Bob Fields | | | | |
Carry Grant | 1 | | | 1 |
------------|------|------|------|------|
TOTAL | 3 | 6 | 5 | 14 |
------------|------|------|------|------|

The report above represents hits to a website on a per-
Monthly basis for each user.


I would like to supress the empty rows so that Bob Fields,
above, won't show up at all. I tried using
NonEmptyCrossJoin like this:

SELECT
{ Measures.members } on Columns ,
{ NonEmptyCrossJoin( [Time].[Calendar].[2004].[May]:
[Time].[Calendar].[2004].[July],
[Business].[User].[Business Entity Id].
[212].Children ) } on Rows
FROM UsageStats

and just NON EMPTY like this:

SELECT
{ Measures.members } on Columns ,
{ NonEmptyCrossJoin( [Time].[Calendar].[2004].[May]:
[Time].[Calendar].[2004].[July],
[Business].[User].[Business Entity Id].
[212].Children ) } on Rows
FROM UsageStats


Both methods above supress the empty rows, but they also
supress anyone who hasn't had any hits to the site in the
first month, even if they do have hits in the 2nd or 3rd
months (so both Bob Fields, and Amy Marcus are both left
out of the report above).

Does anyone know how to possibly get around this? Any help
at all will be greatly appreciated!!! []

Best regards
Maria