All,

I'm working with SQL Server 2000

How does OLAP treat null numeric measures? It seems to insert a zero for
all measures in my fact table that contain a null value. Can anyone help
explain this behavior? Is there a way to keep the null value in the cube
cell?

Thanks for the help.

Scott

I am wondering if this might not be a granularity issue. It's hard to
tell without knowing more details, but would it make sense to put this
measure in its own fact table?

In AS 2000 the only option I can think of is to either put this measure
in its own table (excluding null records), or create a view or where
clause over the current fact table to exclude the nulls. Then create a
second cube over this filtered data and create a virtual cube over the
top of the original cube and the new one.

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

In article <C0B08579-B71B-481F-9C2A-EC245EE06DF1 (AT) microsoft (DOT) com>,
ScottMescall (AT) discussions (DOT) microsoft.com says...

Hi,

It seems to be by design. Only AS authorth could explain its design.

Vladimir Chtepa


"Scott Mescall" <ScottMescall (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news:C0B08579-B71B-481F-9C2A-EC245EE06DF1 (AT) microsoft (DOT) com...

Thanks for the help!

"Darren Gosbell" wrote:

Thanks.

"Vladimir Chtepa" wrote: