|
Home > Archive > MS SQL Server OLAP > September 2005 > Displaying null values
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Displaying null values
|
|
|
| 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
| |
| Darren Gosbell 2005-09-22, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <19F69769-A011-453A-A260- C27D51268997@microso
ft.com>,
JPC@discussions.microsoft.com says...
> 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
>
| |
|
| 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:
> 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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <19F69769-A011-453A-A260- C27D51268997@microso
ft.com>,
> JPC@discussions.microsoft.com says...
>
| |
| Darren Gosbell 2005-09-25, 8:23 pm |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <A980F454-C788-4E75-BBC7- 473048833FE8@microso
ft.com>,
JPC@discussions.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.
>
|
|
|
|
|