Hi,

Does it possible to "flag" an unknown member as... "unknownmember"?

I mean...
In my database all the keys are filled, NULL values are NOT authorized.
so my "product_id" column always contain a value,
but
the "-1" ID is linked to an "unknown product".
using this "unkonwn" member, I control all the labels of the levels of my
dimension.
and also I control default values for my attributes (like the product
height, width, etc...)

But, can I flag this member as the unknownmember? and then use the
..unknownmember function to identify this member in my MDX formula instead-of
using the [dimension].[hierarchy].&[-1] syntax . unknownmember is more easy
to understand and read then the "-1" value.

thanks.

Jerome.

No -- but you could always use a SQL query to expose -1 as NULL

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jeje" <willgart (AT) hotmail (DOT) com> wrote