Hello:
In AS 2000 environment I'm trying to create a cube
with one measure value. In underlying SQL fact table this value is of real
data type and contains some NULL values. In created cube this measure value
is of double data type in standard display mode. The problem is: all NULL
values appears in the cube as 0 values.
Could you, please, give me a hint how to fix the problem. I need preserve
NULL values in the cube.

Thanks,
GB

Typically I suggest that customers build views on the relational-side to
remap data structures.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote

Could you,please, be more specific and give me more details?

Thanks,
GB

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

It probably depends on what why you need the nulls. Do you need to be
able to distinguish between nulls and 0?

If not you might be able to use a calculated measure.

eg.

IIF(Measure.Amount = 0, NULL, Measure.Amount)

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

In article <7u0mf.235817$ir4.189977@edtnps90>, v7v1k3 (AT) hotmail (DOT) com
says...