I have a problem processing null and zero values in my cube measure. I want
Null values to display as blank but zero values for the measure to display as
a zero. Currently, the Null and Zero values display as blanks in the
analysis manager. Does anyone know how I can achieve this? Thanks
--
JPC

Have you tried looking at the cubes using pivot tables in Excel? The
built in browser in AM does strange things occasionally and is not very
configurable. In Excel you can "tweak" the number format and the pivot
table has an option on how to display empty (null) cells (you can
display your own string).

For even more control look at using OWC to display the data.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <19F69769-A011-453A-A260-C27D51268997 (AT) microsoft (DOT) com>,
JPC (AT) discussions (DOT) microsoft.com says...

Thanks Darren, I think i didn't post this correctly as the problem has to do
with an mdx expression not evaluating nulls and zeros differently. In the
expression it treats the null as though it were a zero and I need to have the
expression treat the null as though it were a null values since a zero is a
legitimate value. I think I need to repost the question, thanks for
answering though.
--
JPC


"Darren Gosbell" wrote:

Yes, that is a different question.

Zero and empty are both treated as zeros in many circumstances. Because
OLAP is an aggregating technology null propagation is generally not a
good idea.

Have you tried using the IsEnmpty() function to check for nulls? (you
would do this check before you checked for a zero)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <A980F454-C788-4E75-BBC7-473048833FE8 (AT) microsoft (DOT) com>,
JPC (AT) discussions (DOT) microsoft.com says...