Hi, is it possible to Analysis Services return a "0" zero, when no data
appears for a cell???
I'm doing it by code but i think there may be a value to set that on
Analysis Services.

Thanks a lot
Nabani

Hi,
my guess is something like this:

IIf(IsEmpty(Measures.CurrentMember), 0,
Measures.CurrentMember)

However I think that "Null" means something else than "0".

It gives the signal that there is no data available for
this cell. In my opinion it might not be wise to replace
Null with a zero, for it effectly falsifies the data
displayed.

But you will probably already have considered this.
HTH Lutz

Hi,

For every measure, in the properties window, you
canspecify the format of the cell. You cna specify teh
format you need by customising this value.

Refer to "FORMAT_STRING Contents" for further details.

Hope this helps

Regards
GS

Thanks a lot!!!!, that was what i was looking for...

Nabani


"GS" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks a lot!!! I think using FORMAT_STRING as suggested by GS help me more
in this case...

Nabani



"Lutz Morrien" <lutz.morrien (AT) ocb (DOT) notthis.com> wrote