don't show rows with no data

#1

When I filter my report by certain members of a dimension I get some rows of
data that don't have any values. Is there a way I can supress the zeros or
no data rows?

Thanks.

#2

If you mean in MDX - use NON EMPTY to remove rows whose values are all null
and FILTER to remove zero-valued cells.

If you mean in Excel - you have to use Auto-Filter.

"Jesse Drogin" <JesseDrogin (AT) discussions (DOT) microsoft.com> wrote

Quote:

When I filter my report by certain members of a dimension I get some rows
of
data that don't have any values. Is there a way I can supress the zeros
or
no data rows?

Thanks.

#3

OR
the faster NONEMPTYCROSSJOIN if you are sure that NON_EMPTY_BEHAVIOR is
configured correctly for your members.

"Charlie" wrote:

Quote:

If you mean in MDX - use NON EMPTY to remove rows whose values are all null
and FILTER to remove zero-valued cells.

If you mean in Excel - you have to use Auto-Filter.

"Jesse Drogin" <JesseDrogin (AT) discussions (DOT) microsoft.com> wrote in message
news:925156EC-BC46-4BEE-AB4D-61FE22E5F6A2 (AT) microsoft (DOT) com...
When I filter my report by certain members of a dimension I get some rows
of
data that don't have any values. Is there a way I can supress the zeros
or
no data rows?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

don't show rows with no data

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

don't show rows with no data - 11-02-2004 , 05:22 PM

Re: don't show rows with no data - 11-03-2004 , 08:28 AM

Re: don't show rows with no data - 11-03-2004 , 05:04 PM