Hi,

when I create a Dimension from a numerical column the values NULL and 0 are
both shown as NULL, however i do need the two separate values of 0 and NULL.
Is there a solution for this problem? Any help will be greatly appreciated.

Thanks
Thorsten

AS does not understand 3-value logic. It has no concept of NULL as a RDBMS
handles ANSI NULLs -- it translates it to zero automatically. What I
typically recommend to customers is to create a view where you cast NULLs to
whatever value you wish (e.g. create a "unknown" member within your
dimension tables).

With SQL Server 2005, AS does have specific logic for handling NULLs and
unknown members automatically.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Thorsten" <ButchCoolidge (AT) web (DOT) de> wrote